Applying a mapping on the charts

[shirleyc40]

Hello!

Plan	Gender	Rank
A	F	1
B	M	2
B	F	2

I am trying to find the average plan per gender. In the data load, I have assigned each plan with a number. If I average it in the dashboard, and say I get 1.6 which I round to 2, how do I map 2 back to B?

[JordyWegman]

Hi Shirley,

You can do an aggregation by them and then join it again. Assuming your table is called Table:

Left Join (Table)

Load

Gender,

Plan,

Avg(Rank) as new Rank

Resident Table

Group by Gender, Plan;

Jordy
Climber 

[shirleyc40]

Is it not possible to do this in the analysis tab because I have several tables that differ by the dimension (here its gender).