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:
- Perform complex calculation (weighted percentage) in Amplitude
- How can I export multiple charts to one csv file ?
Best answer by Esther TrapadouxView original
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.)
@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!