topic Re: Aggregating a sum over two dimensions for a chart in App Development

Aggregating a sum over two dimensions for a chart

alespooletto — Thu, 16 Jan 2025 08:14:40 GMT

In my table, I have the correct amounts of items ordered and quoted associated with different USERNAME (cancelled out field in red).

Each of these users made one of these either orders or offers, and the numbers to the rigth in the two columns show the sum of items associated with those offer/orders. Now, in the chart, I want to display the same values, but not broken down by single order/offer number, instead I want it to be generic for all of the users.

You can clearly see it doesn't work at the moment, since the number 1 has 40k items, when the real numbers show all of the users made < 70k. Can someone please help me out? The two fields are just calculated as Sum(Items_Ordered) + Sum(Items_Offered) as of now.

Here is a sample of the data:

USER1	422436722	84157737	62	74
USER2	422436722	84157737	62	74
USER3	420829135	82884584	55	22
USER4	420829135	82884584	55	22
USER2	420829135	82884584	55	22
USER5	420829135	82884584	55	22
USER3	420829135	82884584	55	22
USER3	421432294	83460793	53	55
USER1	420682572	82904020	46	0
USER1	421525688	83514189	46	78

Re: Aggregating a sum over two dimensions for a chart

Bhushan_Mahajan — Thu, 16 Jan 2025 05:49:31 GMT

@alespooletto Please provide sample data.

Re: Aggregating a sum over two dimensions for a chart

alespooletto — Thu, 16 Jan 2025 08:15:01 GMT

Hello, thanks and I added a sample

Re: Aggregating a sum over two dimensions for a chart

Bhushan_Mahajan — Thu, 16 Jan 2025 09:40:56 GMT

@alespooletto It is working in my case with provided data. Check below screenshot.

Re: Aggregating a sum over two dimensions for a chart

alespooletto — Thu, 16 Jan 2025 09:48:30 GMT

Huh, interesting. It doesn't work at all for me, gives me very high values like in the photo... I wonder if its a data model issue now