1 Reply Latest reply on Sep 9, 2015 5:09 PM by diego.medrano

    LOD - access at least one report

    emily.reinherz

      I am trying to calculate the percent of users who have accessed at least one report. So far, I have two calculated fields:

       

      ALP : IIF ( { FIXED [User ID] : SUM ( [# of report accesses] ) } >= 1, 1, 0)

       

      PER : SUM( [ALP] ) / ATTR ( { SUM [which user] ) } )

       

      note: [which user] is a calculated field to toggle a user category parameter

       

      Then I graph AGG( PER ) over time. I know estimates of what I should be getting, and I am getting percentages way too small to be correct.