Forum Discussion
Dynamic Grouping of Dates
Hi community, I have a simple table which include only dates (start of the week) and respective percentages. I have already done the dynamic filtering of dates so that if I select any date from the...
Hi JunedS
I don't understand the logic of the grouping, Based on your original output, don't you want to implement a return date every 14 days?
Best Regards!
Yolo Zhu
Hi Anonymous
Let me clarify the logic behind the grouping. Instead of setting a return date every 14 days from the selected date, the idea is to group the dates into bins of two weeks each based on the chosen date in the slicer. This means we're organizing the dates into two-week intervals, but we're not directly grouping the selected date itself.
Imagine the user selects a date in the slicer, and let's use January 7th, 2024, as an example. With the grouping logic based on two-week bins, it might look like this:
- Group 1: January 7th 2024 (Selected date) 40%
- Group 2: December 24th 2023 - December 31st 2023 , the average CTSP 67.5%
- Group 3: December 3rd 2023 - December 17th 2023, the average CTSP 55%
- Group 4: 26th Nov 2023, this is the last one left out so only one in the group with CTSP 50%
In this case, the selected date (January 7th) falls within its own group, and the surrounding two-week periods are organized accordingly.