4 Replies Latest reply on Feb 11, 2016 1:08 PM by Alen Glina

    Time allocation divided by unique values

    Alen Glina

      Hi there,

      I have a breakdown of resources per state on map and bar graph. The problem is that the bar graph shows 1 for each resource when in reality it is not a unique resource for the region, but a shared among several states.

       

      How can I show the bar graph by % of resources divided by states?

       

      I have tried creating custom calc "COUNT([Rep position])/COUNT([State])", but I am still not getting % of resource by state.

       

       

      Thank you,

      AJG