why does (total hrs and illness hrs =9, lines 2 to 7) in bucket >4 and at the same time its in bucket >6 (lines 20-27). what differentiates them?
in general, there are two ways to approach this.
1. if your definition of bucket is based on totals (bucketing for the aggregated day), then you have to compute it on the fly in your chart. it answers the question, what bucket is the total for this date is in.
2. if your definition of bucket is based on the transaction, you need to determine it in the script, it answers the question what bucket is this transaction in and you can show volume per bucket per date.
it appears your question is more in line with #1, the logic for determining the buckets is to run it against a range. a simple solution would be below (assuming your total expression is labeled TOTAL ILLNESS), create a new expression with the following
=if([TOTAL ILLNESS]>6,'>6',
if([TOTAL ILLNESS]>4, '>4',
if([TOTAL ILLNESS]>2, '>2', '<=2'
)
)
)
you can implement a similar logic in your script if you want to implement #2 scenario.
.png "Former Employee"){kind=icon}
