I’m not sure I would find combining transaction and pageview metrics together to be useful. I’d really want to see these separate normally. I actually do to the trouble to compare pageviews etc that correlate to specific transactions to help locate issues shown by large deltas.
I think you will find there is a limit of 100 buckets. Also, the bucket names will be messy due to the precision of your data.
This kind of thing can help you compare if you want this type of format.
SELECT filter(count(*), where name = 'Web/Spring/Controller/getStuff') as 'Transaction' , filter(count(*), where transactionType LIKE '%Web%') as 'Pageview' from Transaction, PageView where appName = 'API' FACET buckets(duration, 100, 25)
You can also do this kind of thing to bucket the event types:
SELECT filter(count(*), where eventtype() = 'Transaction' ) as 'Transaction', filter(count(*), where eventtype() = 'PageView') as 'Pageview' FROM Transaction, PageView where duration <= 30 FACET buckets(duration, 30, 100) limit 1000
You can limit your query to certain duration ranges if you really need the granularity and range and hit the limits. 3 widgets…
The Histogram chart is also pretty useful, but not with that many buckets.