7 Replies Latest reply: Jul 13, 2012 1:18 PM by Ethan Beaulieu

# Dimension

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.

• ###### Re: Dimension

In the expression add the below set analysis

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

Kiran Rokkam.

• ###### Re: Dimension

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?

• ###### Re: Dimension

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

• ###### Re: Dimension

Neither of those work.

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

• ###### Re: Dimension

Use calculated dimension defined as

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

and check 'Suppress when value is null'

• ###### Re: Dimension

That worked perfectly. Thank you!

• ###### Re: Dimension

Try this

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