2 Replies Latest reply on Mar 27, 2016 11:47 PM by Mahfooj Khan

    How to show null as text in chart

    Lynda Anderson

      We show some state data using a filter in which people select their state.  It works great when the state has data.  For the states that have no data, I'd like the text "Data Not Furnished" to pop up rather than a blank space.  I tried creating a calculated field using various iterations of IFNULL, if then, etc  and I still get nothing.  I have more than one measure that make up some of the charts and some times we get data for one measure and not another, so I still need the data to show when we have it and the "Data not furnished" text to show up in the fields that are NULL.  Any suggestions would be greatly appreciated.