I would like to display "n.a." or "available quarterly" (Value and Target) in the KPI card visualization, keeping in mind that in the column of my table I can have either Percentage or Integer
Is it possible?
What's the expected result? If the target has text values, how can the KPI evaluate the distance to the target?
The result can be either a Value "n.a." with Target "n.a." or Value "47%" with a Target "n.a.", therefore the will be any distance between them
The goal is to display a text that motivates the absence of value in the period, and not having an empty field