Conversion rate within a Guage, possible?
Hi y'all,
I am attempting to work out the conversion rate for our Sales agents to be displayed for management in a nice gauge.
I am partially there; however, the result being returned is not the ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you tell us what the result is when you simply average the value of the $Sale value?
var number Sale = If(not IsNull([Agreement Signed]) and ToDate([Agreement Signed]) >= Today() - Days(30) and [Sales Agent Name] = "Agent Name", 1, 0);
$Sale
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hiya Mark,
The average value for just $Sale comes to 0.16%
The amount of Sales has increased since the initial calculation.
Sale = 126 and NoSale = 302
------------------------------
Nick Green
------------------------------