How to create a range section for date or year in chart

[diptojyotidutta]

Hi everyone,

I have a field "Year" in my dataset. What i want in my chart is that i want an option to choose the range of year where the user can set an initial year and a final year by themselves in order to get the relevant data in that period like sales or no.of champions in that period.

What must be the script/expression/chart/custom object for this purpose?

Regards,

Diptojyoti Dutta

[Anil_Babu_Samineni]

You may decide what range dates should be, As an Example

Load Dim1, Dim2, If(Year>Max(Year), 'Forecast Year', If(Year>=AddYears(Max(Year), -2) and Year<=Max(Year), 'Last 2 Years', ...)) as Flag_Self Resident Table Group By Dim1, Dim2;