How to divide two different series in Chart XML

(0) Share

Report

Posted on by epark06

1,320

My end goal for this chart is to show Utilization (sum of duration/sum of available hours) from the previous 7 days, at the business unit level, then drill down to the user level. The data I'm pulling from is Timecards. My issues:

1. My Available hours numbers is off. It's supposed to be 40 hours X each user. I don't know how I would get this number on this chart. I guess I could just hard code the available hours based on each business unit (ie Customer Support has 7 users so I would divide by 280 hours; Cabling has 4, so 160). Is this possible in XML? Or is there another way to do this via calculated fields or somewhere else?

2. If I can get available hours to pull through correctly, I then have to divide the two bars against eachother and have it show on the chart as a percentage to get utilization.

Any help would be greatly appreciated.

1300.Utilization-Report.png

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to divide two different series in Chart XML

Hi!

Our advise is to pay attation on this link: crmchartguy.wordpress.com

Dynamica Labs http://dynamicalabs.com/

Disclaimer:

Any post on this page provided "as is" without warranty of any kind and is for educational and information purposes only. We disclaim any liability arising from any reliance placed on any post.