Forum Discussion
How to show data from specific date range?
Hello, I have two groupings cities names 1 and cities name 2. And i would like to create a filter for which if date is equal or greater to the earliest date available in the data source and b...
Hi Anonymous , you can add a calcualted column to create a group.
Column = IF([Date]<DATE(2021,1,1),[Country group],[City])Regards,
Jing
If this post helps, please consider Accept it as the solution to help other members find it.
Hello,
Please find attached the link to the sample data https://docs.google.com/spreadsheets/d/1Oa5DZHpIgFsy_tK2gterS6Nx3XEn7HD92AfQbdkVH2Y/edit?usp=sharing
My aim is to create group for which if date is > or = to 01/01/2019 and <1/01/2021 then use Country group else if date is >1/01/2021 use City
Hi Anonymous , you can add a calcualted column to create a group.
Column = IF([Date]<DATE(2021,1,1),[Country group],[City])Regards,
Jing
If this post helps, please consider Accept it as the solution to help other members find it.
Thank you for your help