Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;