Dear All,
I have set up a simple Dial - with no Dimension, just a simple (ish...) expression;
=
Count ({<leadDescShort={'PRM'}>}leadSoldVehicleID)/Count ({<leadDescShort={'PRM'}>}leadContactID)
This divides Sales/Contacts to look at success of marketing activity
However, if I have Zero sales in this set - the Dial displays netiher a Needle, nor a value of Zero in the Text in Chart
I'd like to display a Needle and Text at Zero if the expression cannot be calculated, due to the Numerator being zero
Many thanks