How to bring multiple date values in chart and which chart to use

[Ashwini_B]

Hi,

i have a field called Expiration date. whenever i select a customer name the expiration date should appear. There can be multiple expiration date  for one customer. which chart will be appropriate to use and how to bring multiple date values.

i tried Button chart but i am unable to get multiple dates. please help.

[henrikalmen]

Perhaps you could use a formula like concat(distinct ExpirationDate, ', ') to create a field with a comma separated list of unique expiration dates. But your question is a bit unclear, it would be good to know something more about how you would like to present your data.

[Ashwini_B]

the below is my data, i have to display all 3 expire date dimension for Customer A when i select customer A in the filter. i tried using button chart (below screengrab) but unable to get all 3 dates. i have tried using the  concat(distinct ExpirationDate, ', ')  still the same.

Customer	Contracts	Expire date
A	Published	06-03-2030
A	Published	11/31/2023
A	Published	10/31/2023