Could you guys please help me with a make additional backstep chart in my grafana panel.
For example, on the same panel, I want to display an additional chart for 7 days backward (trough make addition query (B))
My query (A):
date,
round(ifNull((sum(revenue_raw)),0), 1) as revenue_auction
FROM
$table
WHERE
$timeFilter and user_id NOT IN (13, 18639)
and original_adformat = 'popunder'
GROUP BY
date
So the Clickhouse Datasource plugin page describes some detailed descriptions with examples of how to use it.
In your case, you want to display the result from 2 different queries on the same panel. I see that you had already defined your 1st query in the Query A box inside the panel.
Just put your second query in the Query B box and it should be able to display the data.
I attached a screencast (open it in a new window as will be easier to zoom in and view more clearly)