10 Replies Latest reply on Jul 30, 2018 1:19 PM by Jeremy Dempsey

    Need help with LOD Calculation

    Jeremy Dempsey

      Hi Experts,

      I'm working on a calculated field to be used in a tooltip in a dashboard to count the number of records  grouped by [QueueName] where the [ServiceLevelCalc] is less than 80%.  

       

      Here is the calculated field I'm using.  How can I change this to display the total number of records in a tool tip if granularity used in the tooltip is different than the worksheet?

       

      if [ServiceLevelCalc] < .80 and attr([DATE_CALC]) = attr(TODAY()) then CountD([QueueName]) END

       

      For instance, please see the pic below, the tool tip should display 8 records in this case.

       

      Queue LOD Pic1.png