Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average based on multiple columns (categories)

Hi there, In SQL we can do  Create table A ( Company int null, Job int null, Phase int null, Units int null ) Insert into A (Company,Job,Phase,Units) Values (01,161705,16109,23), (01,161705...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Cherry,

    I solved it by adding Summarize table with two columns 1 = Group by Phase 2 = Average(Projected UnitHour)
    Then established relationship on Phase with bi directional and it works

    Thanks,
    Ed Dror

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cherry,

It Didn't work I tried AverageX, Calculate measure, yours solution but nothing seems to work

Basiclly (see attachment) I want to repeat the Average (Mean and Median) to all rows based on Phase value

The Total Mean at the bottom 8.29 to show on each and every row So I can do the chart looks like this

The filter based on Phase only not Copany Job Phase.

Thanks,

Oded Dror

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cherry,

I solved it by adding Summarize table with two columns 1 = Group by Phase 2 = Average(Projected UnitHour)
Then established relationship on Phase with bi directional and it works

Thanks,
Ed Dror