Discard fields table calculation?

[holynumbers]

Hi,

I'm a newbie in this world so please be patient.

This is the table object I have:

Employee	Team	Yesterday	Yesterday Department
Jane Doe	Team A	=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))
John Doe	Team B	=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))

I also have a flag for the department.

What I want is to make the same calculation but on the Department flag. I've looked in to the Aggr-function but didn't make it. Someone that has any suggestions?

/John

[sunny_talwar]

Would you be able to share some numerical data and the output you are looking to get out of it?

[holynumbers]

Sure.

Employee, Team, Yesterday, Yesterday Department

Jane Doe, Team A, (5/2), (10/5)            (departmentflag = 1)

John Doe, Team B, (5/3), (10/5)            (departmentflag = 1)

James Bond, Team C, (9/6), -                    (departmentflag = 0)

Don't know if this got any clearer.

[sunny_talwar]

It hasn't, are you able to provide a app you are working with to help you better?

[holynumbers]

Sorry, I can not share app due to company policy.

Lets make the problem easier instead.
In the last column I want to show the sum of the team/groups achievement.

Name, Team, Result, Team Result

John  , T1     , 5         , 8

Jane  , T1     , 3         , 8

I want the SET-formula to calculate the Team total result on each row.

I don't know I can explain it any easier.

[sunny_talwar]

If this is needed directly in a chart, you can try this

Sum(TOTAL <Team> Result)

[holynumbers · Accepted solution]

Thank you for your help and guiding me in the right direction!

Sum({<Yesterday={1}, Team=, Employee=>} TOTAL denominator)