mercredi 7 mars 2018

IIF or IF statement in Tableau

I am trying to write a IIF statement in Tableau to check if a condition passes. If it fails the condition, I want it to show "No values" rather than filtering out the row.

Given below is the IIF statement I am using:

IIF(([Average monthly count] > [Today]),[Average monthly count],"No values in the range")

Thanks..

Aucun commentaire:

Enregistrer un commentaire