Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a bar chat count between 20-40,40-60,70-80,80-100.
Sample Table.
Name | Dept | Input1 | input2 | input3 | input4 | input5 |
abc1 | Level1 | 20 | 3 | 15 | 12 | 6 |
abc2 | Level1 | 3 | 5 | 5 | 10 | 3 |
abc3 | Level2 | 10 | 10 | 20 | 5 | 5 |
if Selection of Depat in list box.
Bar chat needs to display a value(count(names) between 20-40(first bar),40-60 second bar),70-80,80-100 (count(names) , selection of level1
Can you explain what you want counted and by what field should the counts be aggregated?
can you upload some sample data ? data provided is not so clear ? how did mentioned count 2 for 20-40 range ? what is the logic expected ?