Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

CREATE A TABLE VISUALIZATION WITH A RANGE OF DATES

Hi to everyone,      I have a table of dates (referring to transactions) and I want to create a range of dates between two specified dates. I want to visualize the result on a table visualization,...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    So, not necessarily a great solution, but you could do something like create a new column with a formula such as:

     

    Date Range = IF(TODAY()-[Date] = 0,"Today",IF(TODAY()-[Date] < 30,"< 30 Days",IF(TODAY()-[Date] < 60,"30 - 60 Days","> 60 Days")))

     

    Then, create a slicer based on Date Range. You click the slicer, it filters the visualizations on the page to those date ranges.

     

    Obviously, this does not give the user the ability to enter specific dates and such.

     

    I know that parameters or input fields have been a fairly reoccuring feature request.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

So, not necessarily a great solution, but you could do something like create a new column with a formula such as:

 

Date Range = IF(TODAY()-[Date] = 0,"Today",IF(TODAY()-[Date] < 30,"< 30 Days",IF(TODAY()-[Date] < 60,"30 - 60 Days","> 60 Days")))

 

Then, create a slicer based on Date Range. You click the slicer, it filters the visualizations on the page to those date ranges.

 

Obviously, this does not give the user the ability to enter specific dates and such.

 

I know that parameters or input fields have been a fairly reoccuring feature request.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks smoupre, it's a great solution!