Forum Discussion

sieed's avatar
sieed
Helper II
9 years ago
Solved

Creating a custom date range

I have two tables namely App and Job. I am creating a graph that shows whether the job was finished/unfinished.  I would like to display the x-axis such that it shows the last fifteen ...
Need Help
Tips and Tricks
  • rocky09's avatar
    rocky09
    9 years ago

    I created a custom table with the help of calender function, then I created relation with date column from custom table to original table date column.

     

     

     

     

rocky09's avatar
rocky09
Solution Sage
9 years ago

sieed

 

May be you can create a custom table like below and make relation with date column.

 

mydatetable = CALENDAR(TODAY()-15,TODAY())
sieed's avatar
sieed
Helper II
9 years ago

I would appreciate if you can provide an example. I am still confused. Please see my updated post. 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi sieed,

     

    Have your tried the solution provided by rocky09? I just verified that it should work in your scenario.:smileyhappy:

     

    1. Use the formula below to create an individual Calendar table.

    Calendar = CALENDAR(TODAY()-15,TODAY())

    2. Create a relationship between your Job table and the created Calendar table with the date column.

     

    3. Use the date column from Calendar table as the Axis for the Chart on report.

     

    Regards

  • rocky09's avatar
    rocky09
    Solution Sage
    9 years ago

    I created a custom table with the help of calender function, then I created relation with date column from custom table to original table date column.