
1. Re: Importance vs. Satisfaction plot
Mahfooj Khan Sep 5, 2016 1:15 AM (in response to Luca Candela)Is that what your wanted?
I'll tell you what I've done. First I've splited your Pivot Value Name to get the IMP/SAT and the Remaining Strings in two diff columns. Like that
Now created two calculated fields to get the % of positive for IMP and SAT separately.
% IMP
ZN(SUM(IF [Pivot Field Names  Split 1]='IMP' THEN [Calculation_109212345889853441] END)/
COUNT(IF [Pivot Field Names  Split 1]='IMP' THEN [Pivot Field Values] END))
%SAT
ZN(SUM(IF [Pivot Field Names  Split 1]='SAT' THEN [Calculation_109212345889853441] END)/
COUNT(IF [Pivot Field Names  Split 1]='SAT' THEN [Pivot Field Values] END))
Now just drag %IMP in columns and %SAT in rows shelf and [Pivot Field Names  Split 2] in details. And using Analytics tab I've reference banding. Top rights are overserved and left bottoms are underserved and centre of the plots are servedright. That's it.
Workbook has been attached for your reference. Let me know If you've any query.
Mahfooj