Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Filter Scenario

Hi All,

 

Need your help on solving below scenario

I have a column "Order Date" which i need to use as a filter.

and same "Order Date" is shown in X axis and "Sales" in Y axis

 

I should able to select as Year,Quarter,Month,Week in the filter and 

when i select Year filter, it should show me current year+last 4 years in X axis

when i select Month filter, it should show me current month+last 4 months in X axis. similarly for weeks and quarter.

X axis values should change dynamically as we change the filter.

 

Thanks,

Rajesh

1 Reply