Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in a chart I have, there are certain instances where there are two values to display for the exact same constellation of dimensions - in that case, the chart will display a dash, that is understood and I can deal with it.
I have now even found out how to replace the standard dash that is displayed in that case by a short alternative text.
<=> Is it possible to differentiate whether there are multiple values there or simply nothing at all?
Thanks a lot!
Best regards,
DataNibbler
Hi DataNibbler,
on this place you couldn't differentiate them - you could there replace the dashes with NULL (and the option below them with EMPTY) and need to catch the missing aggregation-error from the calculation with something like:
if(substringcount(concat(value, '+'), '+') >= 1, 'SEVERAL VALUES', value)
or maybe you used with concat an aggregation-function for it.
- Marcus
Hi DataNibbler,
on this place you couldn't differentiate them - you could there replace the dashes with NULL (and the option below them with EMPTY) and need to catch the missing aggregation-error from the calculation with something like:
if(substringcount(concat(value, '+'), '+') >= 1, 'SEVERAL VALUES', value)
or maybe you used with concat an aggregation-function for it.
- Marcus
Hi Marcus,
good idea! Thanks!
Best regards,
DataNibbler