Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
Is it possible to create a new line in pie chart dimension field created as an expression?
Eg:
something like this
=IF (LEN(field1) >0, field1&', '& chr(10) & chr(13) & aggr(COUNT(([key1])),[field1]))
Current Result value for Pie Chart Dimension:
JamesBond, 7
Expected Result value for Pie Chart Dimension:
JamesBond,
7
Thank you in advance
Yes, Using this you can play?
=IF(LEN(field1) >0, Dual(field1&', '& chr(10) & chr(13) & aggr(COUNT(key1),field1), field1))
Hi Anil,
Tried it, but no success. I am looking for aggregated count of all values of the key1 dimension grouped by field1 (not the dual value)