Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show dates after last data point in visual

Hi 

 

I have a stacked column chart showing my orders on y axis and dates on x axis. The problem is that the x axis ends on the date of the latest order. I'd like to be able to see if there have been a few days without orders so I'd like the x-axis to end on the current date. Any way to do this? I know I can set a fixed date to x-axis start and end but how about setting the end date dynamically to always be the date when the report is viewed.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    I would create a data table calculated by calendar(min([orderdate],today()), then make the relationship and choose the column from thta table to the x axis.

     

    Let me know if it worked, if so mark as solution.

     

    BR,

    DR

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    I would create a data table calculated by calendar(min([orderdate],today()), then make the relationship and choose the column from thta table to the x axis.

     

    Let me know if it worked, if so mark as solution.

     

    BR,

    DR