Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Display value in table if no data

Hello,

 

I need to report on SLA incidents on a monthly basis. They are broken down into 4 groups:  Critical, High, Moderate, and Low.  I am linked to an Incident Excel file, which is the data source.  For this month, there are counts for High, Moderate, and Low incidents, but none for Critical.  But I need to show Critical in my matrix and corresponding bar graph, but it only shows what has greater than a 0 value.

 

Thanks.

Need Help

3 Replies

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    3 years ago

    If you click the fields in the values well for the visual, there is an option to "display items with no data" that will make it show. It will just show blank for the value though unless you write a measure with an IF statement where if the result is blank you tell it to return 0 instead. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks christinepayton, but I tried that. No luck. There are no records in the data that have 'Critical' priority.

      • christinepayton's avatar
        christinepayton
        Icon for Most Valuable Professional rankMost Valuable Professional
        3 years ago

        If you force your measure to return 0 instead of blank when there are none, that should make it show up. E.g. 

         

        Measure name = 

        var somevarname = thing you're measuring 

        RETURN IF(var = BLANK(), 0, somevarname)

         

        This returns 0 if it is blank, otherwise it returns the actual value-- alternately you can have your measure add +0 in the calculation.