topic Re: Grouping calculated dimensions in Visualization and Usability

Grouping calculated dimensions

Mon, 22 Jun 2015 14:07:11 GMT

Hi, I have created two calculated dimensions called North Agents and South Agents like below.

North Agents	South Agents
David	Bob
Stephen	Jane
Alex	Nancy
	Jake

I want to create a new dimension called North South Agents including the North Agents and South Agents grouping. So the drill down would be like North South Agents -> North Agents & South Agents -> Bob, Jane, Nancy, Jake, David, Stephen, Alex.

Is there anyway I can do this? I would appreciate any answers. Front end calculated dimension is preferred but scripting is also very appreciated.

Thank you.

Re: Grouping calculated dimensions

Mon, 22 Jun 2015 14:19:31 GMT

Hi,

You have to create a table like this :

Agent	Group	SubGroup
David	North South	North
Stephen	North South	North
Alex	North South	North
Bob	North South	South
Jane	North South	South
Nancy	North South	South
Jake	North South	South

The script depends on your data model.

Regards;

Xavier.

Re: Grouping calculated dimensions

Mon, 22 Jun 2015 14:21:52 GMT

Hi Xavier, is there a way to do this on the front end using set analysis and conditional statements?

Re: Grouping calculated dimensions

ramoncova06 — Mon, 22 Jun 2015 14:33:56 GMT

you need to create a calculated dimension like this

if(Agent = 'David' or Agent = 'Stephen' or Agent = 'Alex', 'North', 'South')

Re: Grouping calculated dimensions

Mon, 22 Jun 2015 15:39:43 GMT

Thanks. It's a really tedious process because in the real data I have like 40 text values for conditions and in other datasets the number of conditions go up to +200. Thumb up but I'd appreciate it if there is an easier way to do this...

Re: Grouping calculated dimensions

ramoncova06 — Mon, 22 Jun 2015 17:16:12 GMT

you could always try with an applymap but that would be a backend script change, if you have another way to identify that is not at that granular level, you might be able to do a front end expression