I am able to display multiple queries (non-timeseries) within the same graph. But the x-axis is showing duplicate values. I mean say, my x axis is 12,13,14. and I have 2 queries, say A,B. Then graph plots 1B,2B,3B,1A,2A,3A.
I would like to see 1A,1B,2A,2B,3A,3B.
Second part of my problem is I would like to have these 2 series plotted on a common x-axis (as stated above) while the query B plotting on negative axis.
Query A:
SELECT
servertime AS “time”,
Strikeprice AS metric,
CAST(openinterest as unsigned) AS value
FROM oi
WHERE
underlyingsymbol = ‘$symbol’ AND
optiontype = ‘CE’ AND
expirydate = ‘$expiry’ AND
Strikeprice>=14000 AND
Strikeprice<=16500
Query B:
SELECT
servertime AS “time”,
Strikeprice AS metric,
CAST(openinterest as unsigned) AS value
FROM oi
WHERE
underlyingsymbol = ‘$symbol’ AND
optiontype = ‘PE’ AND
expirydate = ‘$expiry’ AND
Strikeprice>=14000 AND
Strikeprice<=16500
Thanks,
AB