Hello,
I was wondering if you can have a chart that compares the average of one field depending on the value of several other fields. I want to compare the average runtime of a query and compare the time depending on how many certain conditions are set. So for example I want to see the difference of having 1 integer condition compared to 1 varchar condition as a side by side bar chart. The two charts I have that show the results are below:
| chart avg(runtime) as "Average Run Time(ms)" by Total.Count.Integer.Conditons
| chart avg(runtime) as "Average Run Time(ms)" by Total.Count.Varchar.Conditons
So the above two charts would ideally be one grouped by the number of conditions.
Thanks!
... View more