Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I've made some gauge charts with all the correct expressions etc.
The only problem I have now is with 1 chart, which is the NBV vs. Budget.
I cant seem to go over 100% with a gauge chart?
As you see on the "Budget vs. actual" chart, it is correctly done, and the expression colored grey is:
=sum({<[Application Status group before cancel (Application)]={'Approved'},[Disbursement Flag]={1}>}[Financed Amount (Application)])/Sum(Volumen)
Whereas the green one is calculated with:
if(sum({<[Application Status group before cancel (Application)]={'Approved'},[Disbursement Flag]={1}>}[Financed Amount (Application)])/Sum(Volumen) > 0.8, rgb(69, 234, 21),
if(sum({<[Application Status group before cancel (Application)]={'Approved'},[Disbursement Flag]={1}>}[Financed Amount (Application)])/Sum(Volumen) > 0.7, rgb(255, 255, 0),
rgb(255, 0, 0)))
So my only problem is the NBV vs. Budget - Can anyone tell me how I can go over 100%? so it actually shows the grey area and actually marks the correct part with green.
Anis, it will likely help greatly on this one if you can attach a sample app with the issue, so folks can dig into things on their own...
Regards,
Brett