Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
someone please help me with the solution,
I have KPI object: sum({dates<dates={'=max(dates)'}>}sales),</dates={'=max(dates)'}>
where the sales values are null for many dates.
Suppose if i select the dates filter, the KPI object displays: "Data visualization fails to render".
Instead i have to display data not available
Perhaps this expression will do:
If(sum({dates<dates={'=max(dates)'}>}sales), sum({dates<dates={'=max(dates)'}>}sales), 'No data available')
Perhaps this expression will do:
If(sum({dates<dates={'=max(dates)'}>}sales), sum({dates<dates={'=max(dates)'}>}sales), 'No data available')
Thank you so much, it is working fine.
But there is one issue, i have two measures in single KPI differentiated by two dates with red n green color accordingly.
Based the > and < (red n green) color are dynamic.
If the above solution is implemented the current color red or green will be applied. I need single color to be displayed when the data is null.
Is it possible to implement it in Data Handling