you can create a calculation field as below:
IF [# Of Objects]< [Threshold 1] THEN
ELSEIF [# Of Objects]>= [Threshold 1] AND [# Of Objects]<=[Threshold 2] THEN
ELSEIF [# Of Objects] > [Threshold 2] THEN
Workbook attached for your reference.
Hope this could help
Sample bar threshold.twbx 7.7 KB
Thanks for this,
What if the threshold value is not in my data source ? I.e. it is pretty much subject to change from time to time hence it has to be inserted manually into the calculated field. Also for each GROUP it is a different value i.e look at previous example.
So my data would like below - with a minor difference that it would be thousands of records and around 10 groups.
Group # of objects A 25 B 20 C 15 D 10
Thank you ,