Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am trying to plot count of companies based on their Sentiments (Positive, Negative, Neutral) on x-Axis and Ratings (1,2,3,4,5,6,7,8,9,10) on Y-axis with 4 quadrants in order to spot the customers who are giving us good ratings but in their comments are not so happy or seem not so satisfied.
I will share three images later on this thread
1) Theorotical View of Quadrant chart
2) Manual Output in MS Excel
3) How data looks like
The problem with Quadrant Chart by MAQ Software is it accepts sort of numerical value on X & Y axis and reqires to perform aggregate functions like count, ditinctcount on the values dragged into it.
Thanks in advance
You may try using Scatter chart instead.
How it can server as an alternate or replacement to Quadrant chart.
Any link where I can be referred, so that I can tweak and each my end goal
Achieved it today. There is no direct way rather than creating a sub table and playing around with data.
However, by the grace of God achieve it what I initially was so worried for. Will post all the steps soon
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |