NULL Values in Metrics

image avatar

Melanie Hobman

Gepostet 07. Feb. 2020

Hi,

Hoping someone may be able to assist.

I'm trying to add multiple numeric fields in Explore,... previously in Insights I had as below (small sample, this contains over 50 metrics being summed).  

 

I have not been able to figure out how to replicate this Metric in Explore, the below works as long as there are no filters because there are no NULL values in the full ticketing history, but as soon as I apply a filter to a date range (e.g.  1 month) the Query returns blank.  I can't seem to get the correct syntax in the metric for dealing with the NULL values as a 0.

I tried using Result Manipulation > Metric Filter > Remove blank values but it didn't make any difference.

Thanks

Melanie

0

2

2 Kommentare

Datum
    Neueste
      image avatar

      Ruth Nogueron

      Thank you! This was EXACTLY what I needed!

      0

      image avatar

      Melanie Hobman

      I found a resolution to this one 

      First I needed to create a custom metric for each as below

      IF SUM(No. of TEM: Username Updates) = NULL
      THEN 0
      ELSE SUM(No. of TEM: Username Updates)
      ENDIF

      Then I was able to sum the custom metrics together :)

      1

      Melden Sie sich an, um einen Kommentar zu hinterlassen.

      Sie finden nicht, wonach Sie suchen?

      Neuer Post