5 Replies Latest reply on Jun 12, 2017 5:45 AM by Magda Kwiatkowska

    Using action filtering to calculate %of Total.

    Magda Kwiatkowska
    Magda Kwiatkowska Jun 12, 2017 5:27 AM

      Hi,

      I have a dashboard with Map, few filters and ratio - %of Total.

      > Filters affect Map and values of nominator and denominator.

      > If any state is selected at the map  - ratio is 100%.

      > When state at the map is selected, ratio should be calculated as All values from selected state / all values before selection

       

      I thought that the only thing I need to keep denominator resistant to action is to use EXCLUDE at denominator calculations (and exclude filtering by "state") or to use FIXED (at list all filters besides "state". But it doesn't work.

       

      Maybe combing LOD calculations and Actions is not good idea, but to be honest I don't know to solve that problem. Maybe you have any idea?

       

      Untitled.png