Beginner problem with time series graph

[cmcmetcons]

I have a report linked to a google sheet (as data source), i have applied to this report a control to be report-level, this control selects a value from the google sheet to show the values in the report from the row of the selection made in the control. Now im trying to add a time series graph, that shows the values from the row i selected in the control and the ones before but I´m not sure how to configure it or if its possible.

The control is linked to “MES” and i want to show a time series graph of “PRODUCCION” If i choose June (1/6/2024) i want the graph to show data form ]une and the two month before (1/5/2024 and 1/4/2024)

[Karan2958]

For this you can create different tables and overlap them there is no such filter or view selection for the same

you can have table 1 with data source of June Month then you can overlap the table 2 with data for May only and send it to back to avid overlapping of columns and table 3 with data for only April and do the same once created you can give a dropdown filter for day only and select days you want to see and then the data for 4-6 date will be displayed for each month in each table