Skip to main content
Question

Calculating on Data Table

  • July 29, 2024
  • 1 reply
  • 184 views

Forum|alt.badge.img+1

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?

 

1 reply

Jacenda Davis
Team Member
Forum|alt.badge.img+5
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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings