Our current dashboard is shown weekly with 2015 data. Before the January's results are loaded, can it show December 2014 monthly results when monthly is selected?
You have to provide a lot more information if you want a detailed response. Is it in a chart, in that case what kind. It sound like there are several object that need to change?
You need to change your dimensions into expressions with if statements.
There are several ways to do this but a simple way be something like this:
create a variable in the loadscript with the max(date) of your data. lets call it vMaxDataDate
You have to provide a lot more information if you want a detailed response. Is it in a chart, in that case what kind. It sound like there are several object that need to change?
You need to change your dimensions into expressions with if statements.
There are several ways to do this but a simple way be something like this:
create a variable in the loadscript with the max(date) of your data. lets call it vMaxDataDate
Default view is weekly for my dashboard. In January 2015 if a user selected monthly, it would be blank. I would like it to go to December 2014 until monthly results for January 2015 were loaded. Can I create a loadscript to show previous (December 2014) year's month ending data even though the default view for the bar charts is showing 2015 weekly data?
So is the problem that on january 2 you will not have any for january? that the data might come on say january 23 or even later? I'm not sure I understand the issue well enough but I'm sure I can help you out once I do.
How do you obatin the default view? is anything selected when you show weekly for jan 2015? if so do you use a trigger for that?
otherwise do you use set analysis to make it show jan 2015?
I think your issue will be solved with a few variables and set analysis.
For your bar charts you can use a variable that contains either week or month depending on your rules for this.
