COUNT Of Products for Three date Tables. E.g., Create Date, Fix Date and Close Date

[paarinya2001]

I want to show the count of Machine ID on these Dates seperately and show them on a line graph.

[Rockstar7]

@paarinya2001  you can create a line chart with alternative dimensions with your dates. you can switch to other dates at any time and refer below images

[paarinya2001]

Hello,

Tried the above method, but I want to show all the three dates directly without selection.

[Rockstar7]

@paarinya2001 

as far as i know it is not possible because here we need to treat dates as dimensions.

In line chart  we can't add more than 2 dimensions, even if we provide 2 dimensions it becomes grouping and result is not as desired.

If you want to create a line chart like above then try with one dimension and 3 different measures, you will get.

Hope this helps.