Scenario: Customer satisfaction, based on job priority.
Jobs have different priorities, and customers rate their satisfaction afterwards. There are three satisfaction levels, 'Yes', 'No' and 'N/A'. There are four priorities.
I am attempting to rate percentage satisfaction against priority, rather than against all jobs (eg if there are a 17601 jobs, but only 12917 are Urgent, and of those 12917, 10487 customers were satisfied, then 81.19% is the satisfaction).
I cannot get a bar chart to do this, so I have been playing with a Straight Table chart to to see what figures come out.
If I add a calculated dimension with the formula
=aggr(count(jobID), PriorityBandDescription)
, the number I require appears against each row. If I add an expression with exactly the same formula, the number required only appears against one row for each PriorityBandDescription, with '-' against the others. This is my problem! Where am I going wrong?
I would hope the expression I require is something like
=count(JobID) /aggr(count(total JobID), PriorityBandDescription)
, but that does not work. Help!
