I am building a dashboard and I want to include a line graph that shows the trend for each statistic in the dashboard. I would like the graph to show a rolling 30 days.

For example, Revenue is a statistic shown in the dashboard. I have a data table that includes the revenue for every day. I want the line graph to show revenue for the last 30 days, starting with today.

How can I have the "Series" that the chart is using to build itself dynamically change? Can I use variables or lookup functions within the series?