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
