Forum Discussion
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 ...
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.
I would appreciate if you can provide an example. I am still confused. Please see my updated post.
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