Forum Discussion

gpuc09_'s avatar
gpuc09_
Regular Visitor
1 year ago
Solved

FILTERING WITH DATE RANGE VALUES

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!