Dimension

[#1]

I have a bar chart. My dimension is 'Usergroup' but I want the bar chart to only display all 'Usergroup' not equal to MGR or VP.

Any help would be great.

[#2]

In the expression add the below set analysis

{<Usergroup-={'MGR','VP'}>}

Kiran Rokkam.

[nagaiank · Accepted solution]

Use calculated dimension defined as

If(Match(Usergroup,'MGR','VP')=0,Usergroup,Null())

and check 'Suppress when value is null'

[#4]

I already have two expressions. One for a count and one for a sum of hours.

=

count({<Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"},
Month=, Day=, Year=, Week=, Quarter=>} distinct(TechID))*40

=

sum({<Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"}>} TimeReportedActual)

Would that have to integrate with these or would it be by itself as another expression?

[CELAMBARASAN]

Try this

IF(Not Match(Usergroup, 'MGR', 'VP'), Usergroup)

[#6]

That worked perfectly. Thank you!

[CELAMBARASAN]

Then expressions should be

=

count({<Usergroup -={'MGR', 'VP'}, Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"},
Month=, Day=, Year=, Week=, Quarter=>} distinct(TechID))*40

=

sum({<Usergroup -={'MGR', 'VP'}, Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"}>}TimeReportedActual)

Set analysis is faster than calculated dimensions

[#8]

Neither of those work.

If set analysis is better I would prefer to do it that way.