Use Bucket of a Measure as a dimension in BAR CHART

Abha_TCPL — Fri, 24 Nov 2023 07:39:13 GMT

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.

topic Use Bucket of a Measure as a dimension in BAR CHART in App Development

Use Bucket of a Measure as a dimension in BAR CHART