Question Can I still not display the average elapsed time of an event?

I have several things in my game where I want to be able to time how long they take. So I created a custom event with a float parameter "elapsed". But there seems to be no good way to display the data in a readable manner.

I want to be able to populate a graph with the average elapsed time of event "X" per day for example.

If I cant do it using the GUI tool, is there somewhere I can read up on how I can look up custom events using the SQL explorer? It's not very intuitive and all samples you post you the pre-filled code.

In SQL Id like to make the query: select all events named "generationTime" sort by desc. I then want to be able to view the average "elapsed" (float parameter of generationTime) per day in the table.

 

Should be something like:
SELECT avg(elapsed), EVENT_DATE FROM EVENTS WHERE EVENT_NAME = 'generationTime' GROUP BY EVENT_DATE

But the SQL seems only a subset of sql, for example "SELECT * " is not allowed.

 

avg(elapsed) does not seem to work. How do you select the value of a custom parameter?

Got it, its EVENT_JSON:elapsed::FLOAT

So the SQL is:

SELECT avg(EVENT_JSON:elapsed::FLOAT), EVENT_DATE FROM EVENTS WHERE EVENT_NAME = 'generationTime' GROUP BY EVENT_DATE