hourSelection minute filtering

Darkenblot · March 22, 2023, 9:09am

Hi, the hourSelection function is really great but I found a little limited as you can apply the filter only to the hours but not to the minutes. Does anyone know a workaround for this problem?

Anaisdg · March 22, 2023, 6:10pm

Hello @Darkenblot,
Welcome!
If you really wanted to you could write your own based off of:

github.com

influxdata/flux/blob/e39096d5049ae193f808d4ec8106a49e42820f9a/stdlib/universe/hour_selection.go

package universe

import (
	"github.com/influxdata/flux"
	"github.com/influxdata/flux/codes"
	"github.com/influxdata/flux/execute"
	"github.com/influxdata/flux/internal/date"
	"github.com/influxdata/flux/internal/errors"
	"github.com/influxdata/flux/plan"
	"github.com/influxdata/flux/runtime"
	"github.com/influxdata/flux/values"
)

const HourSelectionKind = "_hourSelection"

type HourSelectionOpSpec struct {
	Start      int64           `json:"start"`
	Stop       int64           `json:"stop"`
	Location   string          `json:"location"`
	Offset     values.Duration `json:"offset"`

This file has been truncated. show original

And then rebuild Flux

I’d suggest creating a feature request there as well except that Flux is being de-prioritized right now…in favor of SQL and Arrow Flight in influxDB Cloud.

Darkenblot · August 11, 2023, 10:44am

Ok, sorry for the late reply thanks a lot

Topic		Replies	Views
Does InfluxQL has equivalent hourSelection() function? InfluxQL influxql	4	346	November 20, 2023
I want to retrieve data from a specific period of time InfluxDB 2	4	603	December 13, 2023
hourSelection() not working in Grafana Dashboards	7	2030	November 9, 2023
Use of "hourSelection()" with Python Dashboards python	1	719	October 9, 2020
Converting InfluxQL to Flux with maths functions Fluxlang	2	380	July 14, 2021

hourSelection minute filtering

Related topics