Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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.

Shishir22's avatar
Shishir22
Solution Sage
5 years ago

Hello Anonymous ,

 

Request you to please provide some sample data and expected result.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi I am not sure why I can not upload a table with a sample data as i am receiving an error message. However my goal is use a grouping called states if the date is >= 01/01/20019 and <1/01/2021 while using city names if the date is >1/01/2021

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Hi Anonymous , you can upload your sample data to some cloud storage services like OneDrive, GoogleDrive, Dropbox... make it public and share the link here. Remove sensitive info before sharing.