Skip to main content
Solved

Perform calculations & Computations - Event Segmentation


Forum|alt.badge.img

I’m trying to perform complex calculation (weighted percentage) in Event Segmentation for which Formula cannot be used. I was wondering how can that be done.

One way was to download dashboard data to csv and do further processing in Excel.

Two main questions:

  1. Perform complex calculation (weighted percentage) in Amplitude
  1. How can I export multiple charts to one csv file ?

Best answer by Esther Trapadoux

@srushti.wadekar great questions! (And apologies for the delay.) The complex calculations you’re looking for can likely be done using derived properties, but this is only available on our Enterprise plans or if you purchase the Govern add-on.

 

  1. How can I export multiple charts to one csv file ?

Unfortunately there’s no easy way to export multiple charts to one csv file. One option is to use our API to retrieve the data and apply a python or JS script to combine the files. Or you’d need to manually combine the files in excel. (Neither of these are super ideal, I know. I can submit a feedback request since this is something I’ve heard users ask for before.)

View original
Did this topic help you find an answer to your question?

2 replies

Esther Trapadoux
Community Manager
Forum|alt.badge.img+9

@srushti.wadekar great questions! (And apologies for the delay.) The complex calculations you’re looking for can likely be done using derived properties, but this is only available on our Enterprise plans or if you purchase the Govern add-on.

 

  1. How can I export multiple charts to one csv file ?

Unfortunately there’s no easy way to export multiple charts to one csv file. One option is to use our API to retrieve the data and apply a python or JS script to combine the files. Or you’d need to manually combine the files in excel. (Neither of these are super ideal, I know. I can submit a feedback request since this is something I’ve heard users ask for before.)


Forum|alt.badge.img

Thank you, @Esther Trapadoux !

One more question regarding Amplitude’s exports - Grouped columns in an Event Segmentation chart are exported into one single column in .csv file. Also, there are few rows appended in exports before actual column headers - is there a way to customize or transform the table before exporting ? Thanks!


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