Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a straight table which has around 15 fields out of which 14 dimension and 1 expression.
we are facing an issue in displaying this chart in the way the End user wants.
Problem is, for few records, all 13 dimensions have single value where as one dimension(Called Root Cause) has 4 values because of which the lines get duplicated 4 times.
Data looks something below:
ID | Name | Root Cause |
---|---|---|
2 | Site | Leak |
2 | site | damage |
2 | Site | Dirty |
2 | Site | Rejected |
But End Users want to see it like below:
ID | Name | Root Cause |
---|---|---|
2 | Site | Leak, Damage,Dirty,Rejected |
Could someone please help with the above?
Thanks & Regards
Jyothi
Instead of using the Root Cause as a dimension, use it in a expression and use the following expressions:
=Concat([Root Cause], ',')
HTH
Best,
Sunny
PFA a sample application:
Best,
Sunny
use
=concat([Root Cause],',')
See below app
Thanks
BKC
Hi Jyothi,
Concat([Root Cause], ',') as RootCause
Group by ID
Thanks alot for the Quick response. It worked
Hi Avinash,
I tried your suggestion too. but it does not let me do this in the script. I get an error saying Invalid Expression.
Not a problem! Glad to help.
Best,
Sunny