5 Replies Latest reply: Nov 21, 2017 6:25 AM by Shraddha Gajare RSS

    Hiding Null values from measures

    Tim Poismans

      Hi all

       

      Is there a way to hide null values from a measurement?

      Asking as I got the following problem:

      Employees belong to profiles. Each employee has a driving score. When comparing a driver's score to the average score, selecting a profile influences this average score (Completely normal behaviour).

      So I changed my formula accordingly, with the set analysis "{<Employee = , Profile = >}":

       

      (

      (

      (Sum(total<Year,Month,Week>{<MessageType = {'Acceleration'}, Employee = , Profile = >}IndType)*(Max(total<Year,Month,Week>{<MessageType = {'Acceleration'}, Employee = , Profile = >}WeightFactor))/10)

      +

      (Sum(total<Year,Month,Week>{<MessageType = {'Deceleration'}, Employee = , Profile = >}IndType)*(Max(total<Year,Month,Week>{<MessageType = {'Deceleration'}, Employee = , Profile = >}WeightFactor))/10)

      +

      (Sum(total<Year,Month,Week>{<MessageType = {'Curve'}, Employee = , Profile = >}IndType)*(Max(total<Year,Month,Week>{<MessageType = {'Curve'}, Employee = , Profile = >}WeightFactor))/10)

      +

      (Sum(total<Year,Month,Week>{<Employee = , Profile = >}IndSpeed)*(Max(total<Year,Month,Week>{<%MessageTypeKey = {200}, Employee = , Profile = >}WeightFactor))/10)

      )

      /4

       

       

      / ((Sum(total<Year,Month,Week>{<Employee = , Profile = >}Distance)/1000)/50)

      )

       

       

      Though with my employees listed in a table, whenever I selecht an employee or a profile the following happens:

      Null issue.PNG

      Employee S and Employee S T belong to profile 1, but the rest does not, but are shown as Null because of the set analysis.

       

      Is there any way to hide these Null-values? Every help is welcome.

       

      Thanks in advance.

       

       

      Kind regards,

       

      Tim Poismans