Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working on a quick bar graph to show how many help desk tickets get sent to certain teams. I need to do two things that I'm having a bit of trouble with accomplishing.
For the first part I'd like to do this without having to resort to a filter pane since there are hundreds of teams in the organizations.
For the second part we have several teams that I'd like to group together in a fashion like
IF <field name> is like DSK* or RMT* then <assign it a group name>
Any help with this would be greatly appreciated.
Thanks,
Mike
Hi Mike
here different simple ways to group your team
first : by adding a table from an excel file with 2 fields team and group team. You can add several another fields if not exist in your data base as geographic ventilation:
Team group_team localisation
Team 1 group A NY
Team 2 group A NY
Team 3 group B LA
Team 4 group B LA
My team - -
and so on
load this kind of file and ensure the team field name is the same in your different data base
second :
by adding calculated dimension in the script :
something like that
base:
LOAD
Team,
If(Team='*DSK*' OR '*RMT*',group_A,
if(Team='*ABC*' OR '*DEF*',group_B,null())) as GROUP_TEAM,
From .....
Hope it's help
Bruno
Hi Mike
here different simple ways to group your team
first : by adding a table from an excel file with 2 fields team and group team. You can add several another fields if not exist in your data base as geographic ventilation:
Team group_team localisation
Team 1 group A NY
Team 2 group A NY
Team 3 group B LA
Team 4 group B LA
My team - -
and so on
load this kind of file and ensure the team field name is the same in your different data base
second :
by adding calculated dimension in the script :
something like that
base:
LOAD
Team,
If(Team='*DSK*' OR '*RMT*',group_A,
if(Team='*ABC*' OR '*DEF*',group_B,null())) as GROUP_TEAM,
From .....
Hope it's help
Bruno
WILDMATCH function will let you check your Team against a list, rather than a long list of ORs
Think this link will be more useful!
Hi Mike,
An additional field in your script which specifies a group for each entry can help solve your issue.
For example:
Member, Team
A,Team 1
B,Team 1
C,Team 1
A,Team 2
D,Team 2
E,Team 2
F,Team 2
Now if you use the team as a dimension you will be able to achieve what you are looking for.
Thanks,
Sangram
Along with the original answer this is extremely helpful as well. Thank you
That worked. Thanks. Also the other suggestions are going to be helpful long term so thank you everyone.