11 Replies Latest reply on Aug 23, 2016 12:30 PM by piotr.biaka

    Results and dynamic threshold


      Hi Guys, I'm working on a solution where i suppose to check, whether given result meets the required threshold. The problem is, that the threshold is dynamic, depending on the level of the data drill.


      So i have a set of results per Region/Country/Province/City and the results with same columns.


      Thresholds.png Results.png


      By default, I would like to check each result and see whether it's within the city threshold or not. So the result in my report would be:


      And that's cool. Now, I would like to change Threshold from the lowest level (by City) to Country, so that each result will be checked against Country's General Threshold instead of the one above, so:




      How can I achieve that? Is that even possible with data structure?

      Thanks in advance.