How can we help?

New post
0

How to reference no data

Avatar
Accounting Manager
None
Follow

The dashboard I am creating is using survey data. The people who do the surveys don't have to fill out every question and this causes problems when trying to show different data calculations. The problem occurs when the data is filtered.
Before it is filtered:

After if is filtered:
(After it is filtered it should show no data)
I have tried to use the indicators to say, if the current value equals undefined, zero, or blank then display N/A. I have also tried the same thing within the equation to get it to show N/A if there is no data to use for the calculation. But nothing seems to work.

This is the equation I have to get the current value:

Any help with this would be great.

Date Votes

1 comment

  • Avatar
    Parker Selman Official comment

    Hi there, 

    Thanks for the post! 

    Happy to help with this. You'll want to insert some logic into this formula so that an empty state is recognized as valid. Since I can't see your data in detail, my suggestions are based on assumptions of your setup, and if you continue to face challenges with this Klip I'd recommend sending a support request to support@klipfolio.com so our support team can assist more closely. 

    With that in mind, if you set up your current value formula to the following structure, you should see the chart update when all values are filtered out:

    IF( COUNT (&DATA1+&DATA2+&DATA3) = 0, BLANK(), (&DATA1+&DATA2+&DATA3)*20 ) 

    This formula will check to see if the data elements contain values, and if they don't, will return a blank value. This should update on your gauge. 

    I hope this helps! 

    Parker

Please sign in to leave a comment.