I have a page where the user is prompted to select a time period. There are several charts on the page is it's all good and working. However, now I need to add a chart that shows purchases over time on the same page. My problem is that if the user selects a period, the chart by time only shows the selected period (which makes sense). I've found that detaching the line chart by time solves the issue, but it's not permanent (in server environment).
Perhaps there is a solution using calculated dimensions / set analysis?
Basically what this means is that the set analysis will ignore any selections made on the date field, but will take account of any other selections made.
Yes, you should look at the SET ANALYSIS samples on the help with attention, it is indeed worth the time. No need to detach.
You aggregation formula in all the expressions very simply should contain a {1} like in ... sum ({1} yrfield) ... this doesn't affect the dimensions just "eliminates" the effect of the "filters" to refer to whole data set.
You could want to use a specific bookmark to limit somehow your set and you can do that also.
