Forum Discussion

zgiersky's avatar
zgiersky
Frequent Visitor
7 years ago
Solved

Filtering Part of chart

Hello Everyone,   I am working on individual statistics report showing production of employees.   I want to have certain employee's production, second bar will be average production by his team, ...
Need Help
  • zgiersky's avatar
    zgiersky
    7 years ago

    Hi Maggie,

     

    You are correct.

     

    I already solved this creating additional table.

     

    So I have tables like this:

     

    T1:

    Case ID, finish date, finish user

     

    T2: Country, Team, User

     

    T3: Team, date

     

    T4: Country, date

     

    Rest goes with relationships. and creating columns where I put measure

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi zgiersky

I make a test for your case, but i'm not very clear, please see my example below.

assume certain employee is a, his production=2,

average production by his team=total  production of employees of the Team A/count of employees of Team A , 

average production by country=total  production of employees of the Country sd/count of employees of Country sd

 

Is my understanding right?

 

Best Regards

Maggie

zgiersky's avatar
zgiersky
Frequent Visitor
7 years ago

Hi Maggie,

 

You are correct.

 

I already solved this creating additional table.

 

So I have tables like this:

 

T1:

Case ID, finish date, finish user

 

T2: Country, Team, User

 

T3: Team, date

 

T4: Country, date

 

Rest goes with relationships. and creating columns where I put measure