topic Re: pie chart with count with an integrated condition in App Development

pie chart with count with an integrated condition

ZimaBlue — Fri, 10 Jun 2022 20:00:55 GMT

Hello!

I need a slightly complicated chart. I want to build a pie chart with count with an integrated condition instead of a field.

My condition is:

if orders_sum is more than 7000, then 'target customer', if more than 3000 then 'on the border', otherwise 'not targeted'

Further, based on this condition, i want the pie chart to show the number of customers for each of the resulting categories: target, on the border, not targeted. I know that it is possible to load field in the script, but this is not the best option for our data, so i would like to build this by calculations in the chart.

So I need something like aggr( count( <{sum(order_cost)={>7000} }> user_id), user_id) but all the options i've tried give an error or null

Thanks for any tips!

Re: pie chart with count with an integrated condition

abhijitnalekar — Fri, 10 Jun 2022 21:12:26 GMT

Hi @ZimaBlue ,

Why don't you create a master dimension which you can use in your pie chart?

Re: pie chart with count with an integrated condition

vinieme12 — Mon, 13 Jun 2022 04:30:43 GMT

Add a Calculated Dimension as below

= AGGR( if(sum(order_cost)>7000,'target customer' ,if(sum(order_cost)>3000,'on the border' ,'not targeted' ) ) , user_id)

Add Measure as below

=count(distinct user_id)