Case CY0, PY=0 then YOY% is to display N/A in label and in tooltip

Question

In a table chart where CY, PY, and YOY% are used as measures, how can we handle YOY% calculation such that:

When CY > 0 and PY = 0, YOY% displays ‘N/A’ (in both label and tooltip),
When CY = 0 and PY = 0, YOY% displays ‘0%’,
And for all other cases, YOY% is calculated and displayed normally,
without affecting the overall YOY% logic across the chart
As shown in image I have to display YOY%=N/A without affecting other YOY% values

Case CY>0, PY=0 then YOY% is to display N/A in label and in tooltip

Hasan Mustafa · Accepted Answer

@VARSHA GHOGARE https://trailblazers.salesforce.com/profileView?u=005KX000001mbA4YAI , create a separate display calculation. Keep your real YOY% as a numeric field, but return NULL when CY > 0 and PY = 0, because YOY is mathematically undefined in that case. Then create a second string field for label/tooltip that returns "N/A", "0%", or the formatted YOY value. This avoids breaking the actual YOY% logic while still showing N/A to users.

VARSHA GHOGARE · Answer

@Hasan Mustafa https://trailblazers.salesforce.com/profileView?u=0053A00000E7SsLQAV  I have tried this approach I kept  real YOY% as a numeric field, which is showing null in YOY% and  created a second string field for label/tooltip that returns "N/A" but this second field type is string and I cant drag it to measure values to display N/A

Case CY>0, PY=0 then YOY% is to display N/A in label and in tooltip

Tableau Public

Aprendizaje relacionado

Más ayuda