Set Analysis Not Responding to Filters

[etrotter]

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!

[luismadriz]

Hi Erica, that's odd! what chart are you working on? Statistic?

Cheers,

Luis

[jonathandienst]

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(...))

[etrotter]

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')

[jonathandienst]

Nothing special here. I suggest that you upload a small sample that illustrates your problem. What field(s) are the users selecting?

[luismadriz]

Is this one really changing or is it the other measures in the bars?

[woshua5550]

what is the dimension of your chart ?

this matter may happen when you use a calculated dimension

attach your app if possible

[sasiparupudi1]

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')

[etrotter · Accepted solution]

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