Forum Discussion

sieed's avatar
sieed
Icon for Helper II rankHelper 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.

     

     

     

     

sieed's avatar
sieed
Icon for Helper II rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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