Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Last N days

Hello,

I have a calendar table that contains a "date" column and a "Working day" column. I want to create a column "Last7Days" which takes the last 7 working days based on Today().

thanks in advance.

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    If your calendar table is in import mode and is refreshed daily then you can add a flag to each date to indicate if it falls into that 7 working days range or not. Then you can use that flag as a filter on the page or the report.

     

    Measures can only filter individual visuals.

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    a column can only contain a single value.  What are you planning to do with that column?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I want to use that column to filter all my page on last 7 days to get data of the last 7 days

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It can be a mesure, not only a column.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      If your calendar table is in import mode and is refreshed daily then you can add a flag to each date to indicate if it falls into that 7 working days range or not. Then you can use that flag as a filter on the page or the report.

       

      Measures can only filter individual visuals.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    May I ask if your problem has been solved. If lbendlin 's reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

     

    Best Regards,

    Ada Wang