Hello Everyone,
I want to show a bar chart having count of engineers with a dimension as bucket range of measure Revenue Achievement %
formula of Revenue achievement %=
(((sum(if(DuplicateFlagService='1',0,service_charge_c))+
sum(if(DuplicateFlagpart='1',0,price*comsumed_qty))-
sum(if(DuplicateFlagpart='1',0,ReturnedPrice))+
sum(if(is_installation='1',installation_charge_c,'0'))+
sum(transport_cost)+
sum(other_charge)-
sum(discount))
/
(count(distinct Fsecode)* 30000)))
I am unable to use this in bar chart as the values in table is working fine. I tried making the all measures in backend. Measures made in backend is giving wrong values and group by is not working with sum function. If I take sum in table of measures created in backend values are wrong but comes right upto an extent when aggregated engineer wise.
The problem is I want full fledged measure to be created in backend with correct values. So that I can make a bucket of it in Script and use it as a dimension in a Bar Chart.