I am having trouble with something I feel should be relatively straight forward.
I am sharing a query from one panel to others to reduce redundancy. This works great and allows for the supporting panels to provide the appropriate context. However, the percent change on the stat panel does not behave as intended. It shows change from first and last value instead of the current and prior value.
This should be fine if the relative time setting worked like it does for time series. Details blow.
version: Cloud
goal: I want to see percentage change from last to current in my stat panel
method: I am trying to use relative time to accomplish this.
outcome: Relative time is ignored and the full dataset is considered by selecting the first and last value for comparison.
expectation: I expected that stat panel would function similarly to the time series panel and trim the dataset to rows that matched the relative time settings.
When I change the panel to time series, it shows the truncated chart with the target weeks in view but then reverts to ignoring the setting when I select the stat panel.
configuration:
“datasource”: {
“uid”: “-- Dashboard --”,
“type”: “datasource”
},
“interval”: “1w”,
“options”: {
“reduceOptions”: {
“values”: false,
“calcs”: [
“lastNotNull”
],
“fields”: “”
},
“orientation”: “auto”,
“textMode”: “auto”,
“wideLayout”: true,
“colorMode”: “value”,
“graphMode”: “none”,
“justifyMode”: “auto”,
“showPercentChange”: true,
“percentChangeColorMode”: “standard”
},
“timeFrom”: “now-2w”,
“hideTimeOverride”: false
}
errors: None