Two trend plots from a same Date slicer.

[ksahil16]

I have a date column by the name "published_on". I want to create 2 trend plots. First one for the date that is selected in the date slicer and the second one for the period before the selected date eg - 1 year before.

If possible we can even give in options to the user to create the 2nd plot for 1 year or for 2 years. This is something which would allow me to compare between the trend between these 2 time periods (One selected by the user and the other one generated for the previous year).

Is it possible to achieve this on the same page, where in we can maybe have a table hidden or something. I would also like to use the values created separately for the other table for some calculations.

[christinepayton]

I would use field parameters for this, one chart linked to one and one to the other. Turn off multiselect in the slicers to force one selection per slicer. You could add a third field parameter for the number of years and add it to both visuals.