unable to fix dimension as i have different date fields

[#1]

Hi All,

I have a requirement to show case count of an item based on different dates in a single chart selection(selection can be multiple)

I can make comparative selection like ordered and issued

I have say 3 date fields

ItemOrder

Item issued

Item expired

so em facing problem in fixing dimension I have to represent in cyclic way

year-month-quarter- week

Kindly suggest some way to resolve

Regards,

Prajna

[#2]

Thank you Angad

It was really helpful

Regards,

Prajna