jlhalliday1
New Member
New member here - and I did search before I posted...perhaps I'm using the wrong terminology as most posts here around "normalization" aren't what I'm looking for.
I am attempting to chart performance of individual PIDs against the performance of their entire PF. In the attached document, I have exported 2 charts from BOXI, the first was a normalized SR Volume by SR Rate (=[SR Count]/[Install Base Qty]) for all PIDs as individuals, the second was all PIDs combined as a PF. I then overlaid the two charts to have the individual performances of the PIDs displayed over the overall performance of the PF. The image speaks volumes to those I'm reporting to, but it’s a convoluted process I'd like to automate within BOXI.
The question: can I produce a chart within BOXI that represents an "x axis" of the PF as a group to which I can display multiple "y axis" of the PIDs against it. To us, this is called Normalization. We've used install base to give us a rate so we'd like to see this exact data represented in one report.
Sincere thanks for feedback...
Jan
PS - I have a file I can post as well, but don't see anywhere to upload it
I am attempting to chart performance of individual PIDs against the performance of their entire PF. In the attached document, I have exported 2 charts from BOXI, the first was a normalized SR Volume by SR Rate (=[SR Count]/[Install Base Qty]) for all PIDs as individuals, the second was all PIDs combined as a PF. I then overlaid the two charts to have the individual performances of the PIDs displayed over the overall performance of the PF. The image speaks volumes to those I'm reporting to, but it’s a convoluted process I'd like to automate within BOXI.
The question: can I produce a chart within BOXI that represents an "x axis" of the PF as a group to which I can display multiple "y axis" of the PIDs against it. To us, this is called Normalization. We've used install base to give us a rate so we'd like to see this exact data represented in one report.
Sincere thanks for feedback...
Jan
PS - I have a file I can post as well, but don't see anywhere to upload it
