How can I add percentage of execution times greater than 5seconds

  • What Grafana version and what operating system are you using?
    Version 10 and data source is elasticsearch

  • What are you trying to achieve?
    Create a table with count,average and percent of execution times for apis
    Count is the total count of hits for that api
    Average for that particular api based on execution time
    Percentage should be count of execution times greater than 5seconds/total number of counts for api *100
    How can I display all these fields in a table format

Fields I have is executiontime and apinames

  • How are you trying to achieve it?
    Through UI or query
    UI is preferable

  • What happened?
    Unable to display percentage column

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?