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

    Results and dynamic threshold

    piotr.biaka

      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:

      Example_1.png

      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:

      Example_2.png

      Result:

      Example_3.png

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

      Thanks in advance.