4 Replies Latest reply on Feb 15, 2019 6:40 AM by Alex de Lorimier

    Filter for individual metrics

    Alex de Lorimier

      Hello all. I have a dataset that includes a level of service metric (%) and a volume metric (n).

       

      For the LOS metric to be accurate, I have to filter out the null values, because not every record goes through the performance process. But for the volume metric, I do not want to filter out the null values because each record still counts towards the total volume.

       

      Is there any way I can filter the null values only for the LOS metric, but not for the volume metric? Ultimately, I'd like to show both the LOS and volume in the same workbook, but so far that has been impossible.

       

      Thanks for your help. Alex