Hi I have a survey that outputs in this type of format
worker | searchhours | birdfound |
AN | 1 | Y |
CP | 0.2 | Y |
AN | 0.5 | |
AN | 0.75 | Y |
JO | 0.6 | |
PR | 0.1 | Y |
LK | 0.3 | Y |
LK | 0.6 | Y |
CP | 0.4 | |
CP | 0.5 | Y |
JO | 0.25 | |
PR | 0.7 | |
JO | 0.15 | Y |
PR | 0.35 | Y |
I would like to create a Dashboard widget/chart to display the number of times bird found per hour worked, by using formula 'count of birdfound'/'sum of workhours'.
Is it possible to get a calculated value in any of the dashboard chart options from two fields, one a count and the other a sum? This page on indicators seem to suggest that its possible to do a simple calculation for a ratio value at least in the indicator widget, but I'm unsure how to place a count or sum of a field into the 'Reference' section (as displayed in the description|formula table).
Thanks!
edit: found relevant instructions - 3. Normalise your metric, Step 2. onwards