Create a Line graph for Trailing 7 Days,

[Tanisha_Shetty]

Please help me create a Line graph for Trailing 7 Days. The graph should update dynamically for Trailing 7 days based on the date picked via the control.

[darcoli]

Assuming you have a parameter called $date you simply need to add a line chart and add the following relative date filter on your date/time field being used in the x-axis:

[Tanisha_Shetty]

@darcoli,

Hi Darren, Thanks! Any way to dynamically update the date control? Right now all I see is that I can set a default static. What I’d want to set is the date to pick up current date as its default.

Thanks!

[darcoli]

If you can live without having the date selectable and always having everything relative to today’s date, then you choose Set dates relative to Current date time

However, if you still want to have a parameter that is by default set to today’s date, then you would need to implement the workaround mentioned here:

How to make Dynamic parameter

Currently the solution is to create a dataset that is refreshed daily and which keeps the value of today’s date. Then you can use this dataset to set up a dynamic default for the parameter. You can see the last section here on how to set up Dynamic Default Parameters: You need to keep in mind that for dynamic defaults you need to provide a username or a groupname. So you, in your dynamic defaults dataset, you would need to create a group for all users or else keep adding all your users into th…

[Tanisha_Shetty]

Thank you very much! I will read through this and try to implement this.