1 Reply Latest reply on Mar 10, 2016 1:18 PM by miles.k

    cumulative percent total calculation that bypasses filter

    miles.k

      Hello,

       

      I want to calculate the cumulative % total, but the last bar is always 100%...

       

      Each bar represents an hour. When I add more then 4 hours to the filter, all of the cumulative percents shift, with the new last bar going to 100%.

       

      I want to calculate the true cumulative %, which would be the number of records in the given hour/number of records for the sum of 24 hours....

       

      I also don't want to just count every single record in the database in the denominator, as this current view already has several filters restricting it. I want to preserve the filters when calculating the denominator except the filter restricting the hours to only 4 hours.

       

      I am looking for a table calculation or LOD calc that allows me to do this. The calc's I have tried have been unsuccessful. Any help appreciated.