Set Analysis on Line Chart

[#1]

I currently have a line chart that I have applied set anaylyis against the dimension of [Project Name].  I do not want this chart affected by the filter for [Work Entry Year] so I used the following logic, but it is not working.  When someone filters against [Work Entry Year] the chart is being filtered.

aggr(only({$<State={"Request"}, [Work Entry Year]>} [Project Name]), [Project Name])

[Nicole-Smith]

Good call Michael Solomovich!  I completely missed that little detail.

[#3]

Yes, I am using a calculated dimension.

My current expression looks like this (see below).  Where would I add the {<[Work Entry Year]>} logic?

if([Front Door Status] = 'New', 1, if(Match([Front Door Status], 'Needs Reqs', 'Needs Design', 'Product Review'), 2, if([Front Door Status] = 'Approved for Estimate', 3, if([Front Door Status] = 'Estimating', 4, if([Front Door Status] = 'Estimated', 5,

if([Front Door Status] = 'Committed', 6, if([Front Door Status] = 'Approved', 7, if([Front Door Status] = 'Cancelled', 8, if([Front Door Status] = 'On Hold', 9)))))))))

[Anonymous · Accepted solution]

Try this (I just tested with a similar expression, it worked):

only( {<[Work Entry Year]>} <your long expression here>)

If it doesn't help, upload your file.

[#5]

that worked, thanks everyone for your helped