Hi, I'm trying to set up RTMC Pro 4.0 for http://128.46.174.145 so that visitors to the site can choose from a drop-down menu which data they want to have displayed on a time series chart. I've tried doing it with a virtual data source connected to a drop list and then having an IIF statement in the time series chart. This kind of works, but then the chart only displays the new data which is recorded after the new option was selected in the menu: it doesn't update the full two weeks' worth of data. Would anyone have an idea for this?
Additionally I'd like visitors to be able to change the date range of the chart so that it can show not just the last two weeks of data, but also the last month or year, or perhaps just last month's data.
Thanks.