Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Below is the data I'm having
ORG | Name | Count of tickts |
TCS | A | 100 |
TCS | B | 90 |
TCS | C | 80 |
TCS | D | 70 |
TCS | E | 60 |
CTS | F | 40 |
CTS | G | 30 |
CTS | H | 20 |
CTS | I | 10 |
Wipro | J | 8 |
Wipro | K | 7 |
Infy | L | 6 |
Infy | M | 5 |
Dell | N | 4 |
Based on the Count of the tickets, Employee might be 500 +
But for each ORG
I need to get Top 5 Employees and Colour code them
in the above example
I'm Plotting a line chart, by *date*
For TCS
Top 5 employees, based on count of tickets, by date
should be shown in a line chart and constant 5 colours should be plotted & even legends should be shown on the Top
In different chart for CTS, By date in x-axis, top 5 Employee based on count of tickets
Qliksense is taking colour automatically, but they wanted to give constant 5 colors & show the legends as well
and those 5 colours should be same accross each segment, & show the legends as well