topic Display values basis on the custom buckets in App Development

Display values basis on the custom buckets

Manav_1988 — Tue, 21 Mar 2023 15:22:03 GMT

Hi All, I want to display values on the basis of a custom bucket in a bar chart.

e.g. my custom buckets are

1. >=5000 and <50000

2. >=50000 and <200000

3. >=200000 and <500000

4. >= 500000

Now, I want to display Count of Sales total based products and it location.

Consider the below table:

As a result it'll display

4 bucket's on the Y axis and Count of the sum of Sales in the related bucket.

Result

SabrinaV — Tue, 21 Mar 2023 14:53:30 GMT

Hello,

I think you can use the class function.

Or — Tue, 21 Mar 2023 15:00:15 GMT

As is generally the case with uneven-sized buckets, the easiest way to approach this is nested if() statements.

If(Sales > 5000 AND Sales < 50000, 'Bucket 1', If(Sales < 200000, 'Bucket 2', etc))

If you need this done with an aggregation, you would use aggr(Sum(Sales),Dim1, Dim2) instead of the simple Sales.

Manav_1988 — Wed, 22 Mar 2023 07:04:14 GMT

Hi,

Thanks. I tried but Class function won't work here as It's a custom bucket scenario.

Manav_1988 — Wed, 22 Mar 2023 07:05:35 GMT

Hi,

Thanks for your message. I tried the same way as you mentioned but it is not working. adding all the value for a single bucket.