Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
5 years ago
Solved

Multiple date filters in same table

I need a table which shows the % sick leave for employess over 12 and 3 months, so the two numbers easily can be compared. For the 12 months I just added a relative date for the last 12 months.  ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ThomasWeppler , relative date filter the dates in table. Means 3 months of data is only available.

     

    Say you filter for a date and use dateinperiod for 3 month with date table , Then you will get data rolling for 3 month for that date.

     

    If you more than one date selected dateinperiod  will give 3 months for all the dates

     

    Also, check this video when wanting to select one date and show a trend https://www.youtube.com/watch?v=duMSovyosXE

amitchandak's avatar
amitchandak
Super User
5 years ago

ThomasWeppler , relative date filter the dates in table. Means 3 months of data is only available.

 

Say you filter for a date and use dateinperiod for 3 month with date table , Then you will get data rolling for 3 month for that date.

 

If you more than one date selected dateinperiod  will give 3 months for all the dates

 

Also, check this video when wanting to select one date and show a trend https://www.youtube.com/watch?v=duMSovyosXE