Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having a problem forcing QV to ignore a selection within a given field.
Let's say I have a line chart with the below design:
Dimension: Day
Expression: Avg(Sales)
The range for the dimension is 1-125. I want the chart to IGNORE any selection in the 'Day' field but include all others so it ultimately will always display Days 1 through 125. Changing the expression to Avg({<Day=>} Sales) does not work. Any ideas?
Thanks in advance.
Brendan,
Not sure what is happening in your app but attached is a test app that does what you want, I think. Let me know if you need further help
Shawn
Brendan,
Not sure what is happening in your app but attached is a test app that does what you want, I think. Let me know if you need further help
Shawn
Shawn,
I had a few formulas in the Static Min/Max fields in the 'Axes' properties that were conflicting with the expression formula. I appreciate your help.
-Brendan