Forum Discussion
gpuc09_
1 year agoRegular Visitor
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!
Needs a disconnected table to feed the slicer.
1 Reply
- lbendlinSuper User