How to group percentages on time series with MYSQL

Grafana Plugin Development
1

Hi im new here, im trying to get percent of success of a total sales on day (for example).
I cant group by date the total and percent to show in time.

2

you should show the structure of the table, and example with data of what you hope to obtain