Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is there a way to covert a bar chart dimensions(Product) to be displayed separated by Comma(,) for certain Customer ID
| Customer ID | Products 1 |
| 1 | Pen |
| 2 | pencil |
| 3 | book |
| 4 | Eraser |
| 5 | Pen |
| 6 | pencil |
| 7 | book |
| 8 | pen |
| 8 | pencil |
| 9 | Book |
| 9 | Eraser |
| 10 | Pencil |
| 10 | Book |
I have Data Like this, can I convert this into a bar chart that shows the product in the dimensions separated by (Comma) so there is only one bar for a specific ID(where the ID has more than 1 product).
Hi, you can try with a calculated dimenion like: =Aggr(Concat([Products 1],','),[Customer ID])
Note that when the user clicks a bar selections will be done on the [Customer ID] field