NRQL with math showing no results

Hi,
I’m having a problem with this query - no results are displayed.

SELECT custom.total/200 as hwr, custom.warmup * hwr FROM SyntheticCheck WHERE monitorName = 'Monitor Blahblah' since 24 hours ago 

Hi, @sharond: You cannot use an AS alias as a variable in another calculation; it is for display only. Try this:

SELECT custom.total / 200 AS hwr, custom.warmup * (custom.total / 200) ...

When I log into your account and start typing FROM SyntheticCheck SELECT in the query builder, I do not see a custom.total attribute.

Thanks. I must say that this limitation is very annoying.

That’s understandable @sharond, completely get where you’re coming from.