[Request Feature] Stacked bar fill(0) feature for DB please have a look :(

trungld269 · February 8, 2018, 11:16am

Sorry I had a post here but for some reasons I cannot get notifications from any developers and my post also seems grey out

Basically I wanna ask is there anyone working on this pull request from @svenklemm

github.com/grafana/grafana

postgres+mysql: add optional fill parameter to $__timeGroup macro to fill in missing values in series

grafana:master ← svenklemm:macroengine-interpolate

opened 10:34PM - 08 Dec 17 UTC

svenklemm

+203 -59

This changes the Interface for MacroEngine.Interpolate and adds the Query to the… Interpolate call. This will allow accessing query state in macro evaluation it will also give macro evaluation access to datasource options which enables implementing macro "flavors". This PR also adds the Query to transformToTimeSeries and transformToTable signatures to get access to query state when transforming the resultset. Those signature changes also allow the implementation of #10096. Those functions are only used by mysql and postgres datasource and I adjusted all the calls for those. The 3rd parameter to $__timeGroup which will be used as value for missing data can either be NULL or any float value. Test queries to test the feature: ```sql -- fill in NULL every minute for interval with no data select $__timeGroup(time,'1m',NULL), random() r1, random() r2 from generate_series($__timeFrom(),$__timeTo(),'120s'::interval) as times(time) -- fill in -1 every minute for interval with no data select $__timeGroup(time,'1m',-1), random() r1, random() r2 from generate_series($__timeFrom(),$__timeTo(),'120s'::interval) as times(time) ``` Fixes #9487

I really hope this feature can be added to version 5, it looks awesome

Many thanks

anon34853223 · February 9, 2018, 8:44am

Your other post seems to work for me so closing this as duplicate

Topic		Replies	Views
Issues with stacked bar and $__timeGroup macro and Mysql MySQL mysql	10	4282	June 22, 2020
How does grafana $__timegroup[fillvalue] works? Grafana	0	1824	September 4, 2020
How show gap when no new data in mysql mysql	4	2054	March 26, 2018
Equivalent to $__timeGroup(dateColumn,‘5m’, 0) in MySQL MySQL mysql	3	1618	February 4, 2019
$__timeGroup error	4	2831	January 13, 2021

[Request Feature] Stacked bar fill(0) feature for DB please have a look :(

Related topics