FILTERING WITH DATE RANGE VALUES

[gpuc09_]

Suppose I have this data (Image 01), where I have several values for the dates from October 1st to October 10th. When I create a filter, with a single selection, of the dates present in my column (Image 02), I need the table to show the values of that selected date and the previous day, in separate rows (Image 03).

 

 

I think it's clearer this way! If you can send me a draft with this solution, that would be great!

dataset used:

data,value

2024-10-01,213

2024-10-02,245

2024-10-02,113

2024-10-02,105

2024-10-03,318

2024-10-03,187

2024-10-04,373

2024-10-04,325

2024-10-04,188

2024-10-05,261

2024-10-05,122

2024-10-05,357

2024-10-06,363

2024-10-07,380

2024-10-08,150

2024-10-08,420

2024-10-09,391

2024-10-10,380

Thank you very much! 

[lbendlin · Accepted solution]

Needs a disconnected table to feed the slicer.