Ifelse function: group the same fields into multiple categories

Question & Answer
,
1

Hello team, I am doing an average time analysis for a process and I need to create something like the following in a table:

image

Therefore, in the first row I need to see the data belonging to team A, in the next row team B, in the third row I need to see the average time of A and B together, and the data of the other teams in the team D.

I tried to use this formula:

ifelse(
{team_name} = "Team Jhon", "Team A",
{team_name} = "Team Sussan", "Team B",
{team_name} = "Team Jhon" OR {team_name} = "Team Sussan", "Team C",
"Team D")

The problem is that the table shows me only the data of group A or B but not the combined ones, and if I place team C first in the sintax, then it does not show me the individual data of A and B.

Is there any way to do this?

2

Hey Danny,

This might not get you 100% percent the way there but it’ll get you really close.

What you can do is make a separate calculated field that groups A & B together and the rest into a different group. Then you can add a row to your pivot table and take subtotals of your calculation.

group field = ifelse({team_name} = “Team Jhon” OR {team_name} = “Team Sussan”, “Group A”,“Group B”)

Here is how it might look.

image
image1074Ă—780 45.1 KB

You can also hide the group field and rename the subtotal rows.

image
image842Ă—674 41.6 KB

Let me know if this helps.

3 Likes
3

@Max you hit the nail. I think sometimes it’s important to have another point of view, and although it’s not exactly what I was thinking, this solves my problem perfectly. Thanks a lot for your help.

1 Like