help with group_by over the api

  • 17 March 2023
  • 3 replies

On my dashboard I have a “segmentation by ‘order - create’” with a “group by” on “plan”. I get a graph and table like:

plan | date

planA | 45

planB | 53


I am trying to retrieve this using the API, but can’t quite figure out how to do it. I tried the following:{"event_type":"order - create","group_by":[{"type":"event","value":"plan"}]}&i=30&m=totals&start=20230101&end=20230131

I get the aggregate total, not the breakdown by planA, planB, etc. What am I doing wrong? How do I retrieve the table as on the dashboard? I believe I can create a chart and query the chart, but I want to dynamically select the date range.




Best answer by effem 17 March 2023, 22:53

View original

3 replies

Userlevel 7
Badge +10

Hey @effem 

Can you share the API response and the chart breakdown you are trying to replicate?

nvm. reverse engineered it from the calls the dashboard is making.

Userlevel 6
Badge +9

Thanks @Saish Redkar and @effem. Do you need additional support here?