Aggregation on Drill Down

[Former Member]

Hi

I have a table with data that looks like this (example):

Company	Team	Employee Name	Height	Weight
XYZ	Alpha	Alex	1.91 m	88 kg
XYZ	Alpha	Peter	1.69 m	59 kg
XYZ	Beta	Alex	1.91 m	88 kg
XYZ	Beta	Doug	1.80 m	72 kg

Alex is working 50% for team Alpha and 50% for team Beta.

Now i'd like to create a Drill-Down-Chart that shows me the average employee height for the company (layer 1) and each team (layer 2).

The calculations i expect to be made are:

Average height Company XYZ = (1.91 + 1.69 + 1.80) / 3

from there i can drill down to

Average height Team Alpha = (1.91 + 1.69) / 2

Average height Team Beta = (1.91 + 1.80) / 2

I tried several custom calculations but cannot get to this result. Can somebody help me?

Regards

Gar

[varunanand · Accepted solution]

Hi Gar,

With the current format of your data, it gets little complicated to get the result you require. Is there a way you can create two tables one for company and the other for the team. You can then get the average results and bring the visualizations from these two different tables together in the Compose tab.

Thank you,

Varun Anand

[Former Member · Accepted solution]

Thanks Varun, how should the data look like, according to you? If i bring two tables together in the compose tab, i can't do a proper drill-down? My goal is to add location data and then drill down on a map. Is this possible at all?

[sudarshan_pavanje · Accepted solution]

Hi Gar,

I feel this can be achieved  with "out of context" calculation which is currently not supported in Lumira.

Thanks,

Sudarshan

[TammyPowlas]

Gar:

What is your data source? Is it on the BI platform? 

Why not have the 2nd report already do the calculations (not necessarily in Lumira) and use the OpenDoc interface to call the second report?

[Former Member]

My datasource is an oracle db, but how would the data need to look like to do the drill-down correctly?