Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have date column, one date can have multiple Products. How do i show the product names in a KPI? Or what could i use instead as an alternative?
Example: when i select a time of day i see the product name, but when i select one more time of day, the kpi value stops working. I want it to show two product names
Thanks
You could concatenate the results, e.g. Concat(Product,', ').
this works, is there a way add a new line between the values?
You could try adding chr(13), but I'm not sure if the KPI object respects newlines.