I am using grafana, yes. However when i tried the query you sent in “explore” tab it is complaining about the dollar sign for range.
“invalid: compilation failed: error at @2:12-2:18: unexpected token for property key: ILLEGAL ($)”
I have another question i have two queries which are slightly different and wanted to know how i can specify specific columns in flux.
SELECT last(UniquePublishCount) as UniquePublishCount, last(ExpectedValue) as ExpectedValue, last(Result) as CheckResult FROM “Feed_UniquePublishCount_jmx” WHERE $timeFilter GROUP BY “ComponentName”
SELECT last(PublishCount) as PublishCount, last(ExpectedValue) as ExpectedValue, last(Result) as CheckResult FROM “Feed_PublishCount_jmx” WHERE $timeFilter GROUP BY “ComponentName”
I thought i got query 1 working with the below conversion to flux however i realised when i tried to convert the second one that i have not specified the column name ie query 1 should be for column “Unique Publish Count” and query 2 should be for “Publish Count”. So both influxql to flux conversions were exactly the same.
@scott - legend! it seems to work however the only issue is under the ComponentName column i am only getting one component back, so there is only one row. There should be 4 components that should populate which i was getting from the flux query i sent you above. I’m wondering if it has anything to do with the query.
@scott - ok i managed to see where the issue was, for the second one we are querying a different table called “Feed_PublishCount_jmx” compared to the first one which was querying “Feed_UniquePublishCount_jmx”.
Thanks for your help scott, i have managed to conver alot of dashboards over to influx however i have come across another one which i am struggling to convert.
SELECT last(“CurveName”) as CurveName,last(“CurveEnabled”) as CurveEnabled, last(“LastCurvePublished”) as LastCurvePublished, last(“CurveLogMessage”) as ErrorMessage, last(ExpectedValue) as ExpectedValue, last(Result) as CheckResult FROM “SwapCurve_FFT_jmx” WHERE $timeFilter and CurveName !~ /""/ GROUP BY “MBean”, host
Its the “and CurveName !~ /”"/" that i am struggling to conver to influx.