Points work, but bars streak across x axis to infinite

Grafana Time Series Panel
1

Hi. I am trying to get bars to display in the time mode graph panel but something weird happens when I switch to the bars mode. Points seem to work fine, lines appear as points, which I expect is because the time values are instantaneous. But bars just go all the way to the right. Currently using $_timeGroup, but maybe that’s the wrong macro or I’m using it wrong.

cap2
cap21725×1705 117 KB
cap3
cap31741×1689 124 KB

Here is the relevant part of the query:

c AS (
SELECT
Sales
, [Target]
, Salesperson
, DATEADD(HOUR, - (2 - SPNo), GETDATE()) AS ‘time’
FROM
b
)
SELECT
Sales
, [Target]
, Salesperson
, $__timeGroup([time], ‘1m’) as ‘time’
FROM
c

Here is a sample result set from that query:

|Sales|Target|Salesperson|time
|296083.600|279326.923|User 1|2019-04-10 16:36:13.403|
|31425.320|177788.4615|User 2|2019-04-10 17:36:13.403|
|63885.850|66153.8461|User 3|2019-04-10 18:36:13.403|
|25533.000|30673.0769|User 4|2019-04-10 19:36:13.403|
|22593.350|18269.2307|User 5|2019-04-10 20:36:13.403|
|39322.380|5769.2307|User 6|2019-04-10 21:36:13.403|
|178214.440|0.00|User 7|2019-04-10 22:36:13.403|