Skip to main content

Hi! I use formulas on graphs and they work like a charm! 

Now I want to calculate the following on the table element:

 

You can see that my Store #1 is selling cars in different values. I want to sum all of the profit from Store #1 so I can group by different stores and see the profit per store.

 

How'd I do it?

 

Hello Mauricio,

Thanks for writing to Amplitude Support. Happy to help!

Would it be possible for you to share a link to your table? I would help to take a closer look at the events and properties.

In this case, to total the profit you could try creating a custom metric column using the the PROPSUM function with the _Cars Sold_ event and the _Funding Amount_ property.

Here is our documentation on Custom Formulas.

Here is our documentation on creating a metric.

Let me know if you have any questions! I hope this helps.

Best,

Jacenda


P.S. Checkout upcoming events and user meetups on our events page.

Reply