Incorrect Aggregated value

[RajatAr]

Hi,

I am using CJA and facing an issue with the aggregated Revenue
my revenue is coming in CJA such a way that is multiplied by events so I had to create a metric using if condition
i.e. 
if 
equals
events = 0
Then 0 
else 
Revenue / Events
Using this way i am getting the correct revenue of my product but getting incorrect aggregated value
                  Revenue      
product        20 (aggregated)
a                   2
b                   90
c                   16
d                   65
So Ideally the aggregated value would be  173 but it is showing me 20 only 
Is there any change in the metric I can make to correct the aggregated value

[FilipeFreitas]

Hi RajatAr,

I hope this message finds you well.

If I get your message correctly, you are trying to build a cummulative sum. Did I get it right? If this is the case, you can do so by creating a calculated metric using the cummulative function.

Components > Calculated Metrics. Then add a container with the cummulative funcion set, and add the desired metric.

There is a playbook shared by Mandy George you can download from that explains how this can be achieved:

https://experienceleague.adobe.com/en/perspectives/calculated-metrics-playbook-your-one-stop-shop-fo...

My apologies if I misunderstood your quesiton. If this doesn't help you, I would kindly ask you to provide more information about how you are building the metric.

All the best!

Filipe

[RajatAr]

Hi @FilipeFreitas 

When we drag the metric into the freeform table, we first see the summed (aggregated) value, and then, based on the breakdown dimension (in this case, "product"), we see the component-wise values. In my case, I'm using a metric coming from AEP, which represents Revenue * Events. I'm trying to create a calculated metric to extract only the revenue from this.

To do this, I used the following logic in the calculated metric:

If events equals 0 then 0
else Revenue divided by Events

This gives me the correct revenue values at the product level. However, the aggregated (summed) value at the top of the table is incorrect.

[MandyGeorge]

It sounds like what you're looking for is a sum of all the products revenues. But what that total is showing you is an average instead of a summation. This is the normal way that metrics work. Depending on how many products are in your list, this may or may not be feasible. Dragging in the row items individually, or bringing in the dimension but then using "display only selected rows" - either of those methods makes the table treat each row like its own dimension, so the total would be a sum and not an average any more.

[Josh__Stephens]

Hi @RajatAr I just posted on your other question but now understand this one more thoroughly. In CJA you can use the summarize function to aggregate values at the event level. I think a derived field similar to this should get you what you want.