11 Replies Latest reply on May 11, 2018 12:16 PM by Shinichiro Murakami

# Grand Total Avg of Column to a Bar Graph by Month

Hi Guys,

I'm stuck on trying to get the average cost per loan number to show up in my bar graph.

On Sheet 1:

Cost per loan (3rd column ) the GRAND TOTAL AVG = \$2,290.86 for all 5 employees.

On Sheet 2:

Each bar for each month this year should represent the following totals. These totals are the average cost per loan each month.

January: \$5,796.68

February: \$3,154.20

March: \$3,060.86

April \$2,290.86

I'm trying the LOD calc but still not getting the right numbers

Best,

Lashaw Salta

• ###### 1. Re: Grand Total Avg of Column to a Bar Graph by Month

Could you clarify the sheet 1 logic  first ?

Thanks,

Shin

• ###### 2. Re: Grand Total Avg of Column to a Bar Graph by Month

Hey Shin!

Good to hear from you.

Yes so Total Comp = Bonus + Commission + Salary

Cost per loan = Total Comp / CountD

Does that help?

Thanks,

Lashaw Salta

• ###### 3. Re: Grand Total Avg of Column to a Bar Graph by Month

HI Lashaw

Then where 2290.86 come from?

Shin

• ###### 4. Re: Grand Total Avg of Column to a Bar Graph by Month

The viz is currently showing the Avg Cost per loan in the Grand total row for March \$3,030.86.

When you change the post date filter to April it will give you an average cost per loan in the grand total row of \$2,290.86. Screenshot is below.

• ###### 5. Re: Grand Total Avg of Column to a Bar Graph by Month

Hi Lashaw,

I missed that part of description, then does this help?

Not sure January's amount though.

There might be easier way, but I tried not touching current formula as much as possible,

Thanks,

Shin

• ###### 6. Re: Grand Total Avg of Column to a Bar Graph by Month

Shin this is correct! I was creating an unnecessary table calc with a LOD instead of just adding it to the original cost per loan calc. Thank you for working on this.

When I did this calc on my original workbook, all bars are correct except for one. Do you have any ideas on why this would be?

Thanks,

Lashaw Salta

• ###### 7. Re: Grand Total Avg of Column to a Bar Graph by Month

HI Lashaw,

I don't know what is THIS.

Shin

• ###### 8. Re: Grand Total Avg of Column to a Bar Graph by Month

On my original workbook this number should show \$534.59 instead it shows \$1,337.82

The other bars are 100% accurate and pulling those same numbers we created in the table similar to the one I posted on here. Would you have any idea why this bar would be different and the others be correct?

# What is this?

• ###### 10. Re: Grand Total Avg of Column to a Bar Graph by Month

The screenshot didn't post: the highlighted number

• ###### 11. Re: Grand Total Avg of Column to a Bar Graph by Month

No idea without seeing data.

Could you re-attach the twbx with error part?

Thanks,

Shin