Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am trying to create a chart that will not respond to the the time filters, here is what I have so far:
{$<Year=,Month=,WeekNum=>}
It is still responding to the filter selections, any ideas?
Thanks in advance!
I ended up going into the back end and creating a new field that wouldn't respond to date as opposed to using the goal line
Hi Erica, that's odd! what chart are you working on? Statistic?
Cheers,
Luis
Hard to say without a sample or a lot more information.
Some thoughts - the override applies to selections only. Selections in other fields could reduce the data set, including the fields in the override set selection.
If this in a nested expression, make sure that the set is applied to both the outer and inner expressions (especially for constructs like Sum(Aggr(...))
I am using it in a bar chart to make a goal line by using the reference line, here is the whole expression:
=num(SUM({$<VALUE-={0},Year=,Month=,WeekNum=>}Department_Goal),'#,##0.000')
Nothing special here. I suggest that you upload a small sample that illustrates your problem. What field(s) are the users selecting?
Is this one really changing or is it the other measures in the bars?
what is the dimension of your chart ?
this matter may happen when you use a calculated dimension
attach your app if possible
May be try without the VALUE-={0} to see if the selection still getting influenced by the time selections?
=num(SUM({$<VALUE-={0},Year=,Month=,WeekNum=>}Department_Goal),'#,##0.000')
I ended up going into the back end and creating a new field that wouldn't respond to date as opposed to using the goal line