Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use calculated dimension defined as
If(Match(Usergroup,'MGR','VP')=0,Usergroup,Null())
and check 'Suppress when value is null'
In the expression add the below set analysis
{<Usergroup-={'MGR','VP'}>}
Kiran Rokkam.
Use calculated dimension defined as
If(Match(Usergroup,'MGR','VP')=0,Usergroup,Null())
and check 'Suppress when value is null'
I already have two expressions. One for a count and one for a sum of hours.
=
count({<Date = {">=$(=weekstart(today(),0))<=$(=weekend(today(),0))"},
=
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?
Try this
IF(Not Match(Usergroup, 'MGR', 'VP'), Usergroup)
That worked perfectly. Thank you!
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
Neither of those work.
If set analysis is better I would prefer to do it that way.