Is it possible to limit an entire chart with one set analysis expression?
I have an extremely complicated stacked bar chart that uses 9 expressions and each expression is riddled with nested IFs. I need to limit this chart to only populate for current quarter regardless of user selections but trying to implement that set analysis within each expression has so far proven to be futile.
The only thing I can think of is to add a calculation condition on the entire chart which makes it so it won't populate unless current quarter is selected; but that seems very inconvenient rather than just displaying current quarter regardless of selection.
I am using alternate states but the issue is that SOME of the field values are common and need to be passed between states. I recently learned that "on activate" triggers in sheet properties are not supported in ajax client which completely ruined the dashboard that I had setup. I was storing field values as variables and then had sheets set to "select in field" based on the variable values. Have any ideas on how to do something similar that will work in ajax client?
Yup, triggers not working in the Ajax client, especially the "on activate" triggers, is a right pain. I have been burnt by that too.
It is very hard to give any specific suggestions without seeing your extremely complicated stacked bar chart that uses 9 expressions and each expression is riddled with nested IFs. Any chance of sharing a sample qvw demonstrating things ?
