2 Replies Latest reply on Feb 9, 2017 10:46 PM by Norbert Maijoor

    More Dynamic LODs depending on granularity needed

    Adam Ehrenworth

      I have set up LODs that do a calculation by unique User ID but the current approach is a Year level.  If I want to be able to have a worksheet calculate if I want to do only a quarter of data or quarter verus quarter comparison would I need to set up a completely different set of LODs?

       

      This is how the one of the current LODs is set up.

       

      {Fixed[User ID], [Year]: SUM([OP_Manual_Entry_LaterFound])/SUM([Is Open Payments Reportable])}

       

      And the other one

       

      {Fixed[User ID], [Year]: COUNT([Open Payments Reportable Flag])}

       

      Can I do it with a parameter to adjust the LOD?

       

      Thanks,


      Adam