aggr not working in expression

[#1]

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!

[#2]

Michael,

please provide a short QV example we can work with.

Thank you!

Rainer

[#3 · Accepted solution]

Guten Tag Rainer!

I inserted NODISTINCT in my aggr and now that particular chart works a treat:

=count(JobID) /aggr(NODISTINCT count(JobID),PriorityBandDescription)

Vielen Dank

michael