We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

how to get values of a hierarchy that remain after a filter?

Resolved
Michael T asked on May 9, 2022

With two three hierarchies for example, "Country" and "City" "Country-City"
On a chart that has measures that don't show any of the three hierarchies (e.g. population by year)

If the filter is set to a certain value for a "Country-City"
e.g. "USA - New York"
Is there a way to iterate through each row  that satisfy the filter and retrieve the City and Country?
 
Data example:
Country, City, Country-City
USA, New York, USA-New York
USA, Washington, USA-Washington
Netherlands, Amsterdam, Netherlands-Amsterdam
 
The hierarchies I would like to retrieve are not shown on the chart or grid so getData would not work.
The reason I want to do this is because I am creating a dashboard and want to set filters for City and Country specific charts to the correct value, in a manner similar to your syncFilter example.
And want to want the user to only need to filter the combination of "Country-City" that have values (i.e. do not want them to filter Country and City independently)
 
I do have a workaround, but it is ugly so it would be nice to know if there is some technique that I am unaware of..

Thank you so much,
 
Stay safe,

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 10, 2022

Hello, Michael!
 
Thank you for your question.
 
Kindly note that Flexmonster does not provide any options to filter out the members with no data from filter pop-up.
Still, we could see the following workarounds:

  1. Pre-filtering data before passing it to Flexmonster.
  2. Implementing custom filtering functionality using our API calls.

 
Please let us know if you need more details on the suggested approaches. Feel free to contact us in case of any questions.
 
Regards, 
Solomiia

Please login or Register to Submit Answer