How to display a trend for 3 years for selected year

[gurusai sankar]

Hi All,

I have a period name (String) column which includes month & Year data , also have cost.

We are showinga line graphfor Period name (X-Axis) and Cost(Y-Axis) based on List box filter for Year .

It shows a trend based on selected year in YEAR filter.

Now my requirement is -

we have to fix a check box filter under Year filter which gives 3 years trend , means if we select 2019 in Year filter , it shows 2019 trend in the lineGraph, at the same time when we enable check box filter then line graph should change to 3 years (ie current year (2019) + Next 2 Years (2020, 2021), when we unchecked check box filter, it should go to the previous position. (it means it shows a trend line based on selected year in Year filter)

Kindly suggest how should i achive this

If it is not possible in this way - Kindly suggest a alternation solution

 

 

 

Regards,

Guru.

[James Watts]

Create a calculated column that is the integer year value of the date.

Create a parameter and list box based on these numbers.

Create a parameter and list box for choosing between a one or three year chart.

Create a calculated check column that gives true if

one year chart and year equals list box year

or

three year chart and calculated year column is equal and bigger than the list box value

and calc year column is smaller than the list box year plus three

Edit the data settings of the chart to only display data when the calc check column is true.

See the attached DXP.

[gurusai sankar]

Hi Jim,

 

Thanks alot  for your prompt responce. This is what i am looking . i am following the same. but i am unable to create a paramYear List box as i am unable to see and selcet Yearcalc . i am not sure why it is not visible . i am selected the same data table which we have create a calculated column for Yearcalc. 

 

Can you plese tell me if i did anything wrong.  

 

 

[James Watts]

You probably haven't created the document property in the correct data type. To have integers in a list, the document property needs to be an integer.

[gurusai sankar]

Thanks a lot JIm for your great help and prompt responce. It worked.