Does the plugin work with Influx databases? if so how to use it or configure it?

Best Regards Luke

Currently only "UNIX Timestamp (Number)" is allowed in "Time From/To Field"'

Hope to allow relative time such as '-1d' for last day or so.

Hello

After update new version of grafana 8.0.2 plugin stop working before on version 7.5 was ok

Thanks for the great plugin! I was performing a query (InfluxDB) and need to apply a transform on my query before supplying it to the timepicker-buttons panel. It appears the plugin does not use the transformed fields. Is this possible with the plugin framework?

->

The plugin does not work after upgrade to 8.5.0-beta1 (2022-04-06)
Please help, this is the only plugin in the enterprise

Environment:

• Grafana version: 8.5.0-beta1
• Data source type & version: MSSQL
• OS Grafana is installed on: Windows Server 2016
• User OS & Browser: Chrome

I'm getting the following error while trying to compile the master branch:

berger on nikos-desktop in ~/src/timepicker-buttons on  master is 📦 v1.0.0 via ⬢ v12.11.0 took 8s

✦ at [23:24:58] ➜ yarn build
yarn run v1.19.1
$ node --max-old-space-size=8192 ./node_modules/.bin/webpack --config webpack.config.prod.js
clean-webpack-plugin: /home/berger/src/timepicker-buttons2/dist has been removed.
Hash: b74a2e2513922ffd20b2
Version: webpack 4.43.0
Time: 6926ms
Built at: 06/12/2020 23:25:06
 2 assets
Entrypoint module = module.js module.js.map
 [48] external "lodash" 42 bytes {0} [built]
 [99] ./module.ts 4.53 KiB {0} [built]
[100] external "app/plugins/sdk" 42 bytes {0} [built]
[106] util (ignored) 15 bytes {0} [built]
[108] util (ignored) 15 bytes {0} [built]
[140] ./css/timepicker-btns.css 545 bytes {0} [built]
[142] ../node_modules/css-loader/dist/cjs.js??ref--5-1!./css/timepicker-btns.css 741 bytes {0} [built]
    + 137 hidden modules
ERROR in module.js from UglifyJs
Unexpected token: keyword «const» [../node_modules/apache-arrow/type.js:19,0][module.js:110,0]
error Command failed with exit code 2.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

I did a bit of googling and this must be due to UglifyJS not supporting ES6.
I've tried replacing it with terser-webpack in my fork but that doesn't seem to work and the timepicker widget isn't even visible in the grafana dashboard.

Notice that I don't really know my way around JS or webpack so my workaround may as well be completely wrong.

Any pointers?

P.S. Thanks for this great project! :)

Hello @WilliamVenner 👋

What happened:

Changing date by button changes panel relative time

What you expected to happen:
The relative time of the panel must be fixed on the panel and should not change by time picker and time picker buttons

Environment:

• Grafana version: 8.0

Hi,

I'm using Grafana 6.7.3 running on Windows server 2016. I've installed the plugin as you can see from the screenshot below but when I choose the type of panel I cannot find the timepicker-button option:

Am I trying to use it in the wrong way? How do I insert a timepicker-button? (that's exactly what I need)

Dear developers,

I'm having problems trying to make your plugin works on Grafana 7.1, is this version supported?

If it helps you here you have a screenshot from my browser debug console:

Hello,
I just want to query the last time values (time_from & time_to) from InfluxDB, although it returns the queried value correctly under query inspector, it is not showing on the panel display, what could be wrong here!? Moreover, if I remove the 'Order By' Clause/Command the panel displays all the times(1....1000 items)!

Error on Panel Display:

Query Inspector:

Panel Displays without Order By Query:

Please help!

Regards,
Mukara

Hey,

when I set a time_to the to is set to the same value as from. The values offered by the query are different (seen in Query Inspector).

I can't really determine why. Can you help?

Tested with Grafana 7.0.3 and 7.2.1 with Timepicker-Buttons 2.0.0.

Thank you in advance!

I am fairly new to Grafana. I know how to make dashboards and add panels, but the README leaves out a lot of setup details for this plugin. Here is a list of questions I have.

• I only have InfluxDB installed. Do I need to install MySQL like you showed in your pictures
• What information does the MySQL database need to contain for this plugin to work?
• You showed yourself setting the "button_text" and "time_from" in your database queries. Do I need to have that information also in the database? Or do you just make a query to an empty database and provide all the information in the grafana query?

Hi Friend, good job!

In grafana repo is still old version (((
Please, publish the built version for self-managed grafana
I can't build it on my own!

I'm not sure if this plugin is broken in Grafana 7.5.1, but there is no "Field Mappings" option in the panel settings.

Dear,

I recently implement this plugin and I love it !
My (future) users are non-technical and grafana standard time range chooser is too complex.
I am now able to let them choose (in native language !) their time range in my predifined choices.
Thansk a lot.

I would like to suggest an enhancement. Let me know if it is possible:
I have a dashboard and analysis is weekly based. Today I am using buttons so the user can select the week they want to analyse.
However, There can be 52 choices in the future so would be great to be able to propose a scrolldown list instead of individual buttons.

Best Regards,
Antoine

I am using the date time picker plugin with Influx 2.0 as the data source which works fine but i have not found a way to control the order of the buttons or the content of the dropdown. I already tried to add sorting to the flux query without success so an option to have the button sorted on eithr

• button texy asc/desc
• time from asc/desc
• time to asc/desc

would be very usefull.

Examples of my button text
PI 20-1
PI 20-1
...
PI 21-4

This is the order in which the buttons / dropdown are shown but the majority of the users needs the last value (this is also the primary values) and need to scroll down every time they open the dashboard

Hi I currently testing the panel for my use case but it seems that for some reason the panel is not displaying the options to configure it.
The panel version I got is version 2.0.1.
I created a panel with the last 10 date ranges I need to use to update my dashboard but it seems it only creates one button at the time I would like to confirm if that is the expected behavior or is it a bug related to what I'm reporting.

I followed the instructions in the README and under the plugins menu in grafana I get this message:

What version you are using:

• Grafana: 8.4.1 cloud Pro
• Plugin version: 4.1.1

Describe the problem:
When I want to create a PDF report the timepicker button is not selected and appears blank

Dashboard:

Generated report:

Is there a way how to make this work?

Hello

I would like to configure myself three buttons with a time range for three working shifts, e.g.

1 Shift from 06:00 to 14:00
2 Shift from 14:00 to 22:00
3 Shift from 22:00 to 06:00

But the date had to be dynamic, always the current day, is it possible to add such functionality or maybe it can be done now in the current plugin version, if so, if not, is it possible at all?

Once a button is clicked it is hard to recall which button was selected after the button loses focus.

@WilliamVenner what are your thoughts on adding a feature to highlight or change a button or list item's appearance based on the selected time?

I can see this being implemented a few different ways:

1. Highlight a button/item if the item's range overlaps the currently selected time (this overlap could be to and from or to or from). This best matches my use case and allows the user to see all items which are contained in the selected range. However, this may be confusing if there are buttons with overlapping times.
2. Highlight the item if the item's to/from equals the selected time range to/from.
3. Highlight the button/item after it is selected until the time range changes. This seems fragile.

hello, i have an issue about timepicker. this is the data that i uploaded in grafana in table form

And this is the timepicker panel that shows the time.

as you see, the timepicker panel shows date and time that is not same as data in table form. can you give me a guide to solve that problem?

I found your approach very intereseting and would be even better :) if possible to add below time frames. It is more less feature request, is it possible to set buttons the way I describe below ?

This would be very helpful and many users would benefit from that, that was the initial request from Custom Time ranges to the time picker drop down

Yesterday: all shifts
yesterday from 06:00 to today 06:00

Yesterday: 1st shift =
yesterday from 06:00 to 14:00

Today: 1st shift
today from 06:00 to 14:00

etc.

Hi,

I am very happy about this plugin but have a question:

• Is-it possible to define the value by default before the user choose something in the dropdown ?

My use case is:
I use a grafana dashboard to display information and analysis based on regular week (from monday to sunday).
I use the plugin so the user can easily select the week of analysis
I would like that the last week will be automatically displayed

Today I have to to select the last week value and I save this value in the dashboard but i have to do this step manually every week. Not feasible anymore.

Would be great if we could define (or have another way) to select automatically the "default selected / current" value in the table.
I would for example add a column default value. It would be easy to update the value of this column that would have an impact on all the grafana dashboard every week automatically.

Let me know if you have any advice or remark,
Antoine

Dear,

I integrate the timepicker in list mode and I love this feature !
On my computer, no problem to select the right option.
But when viewing on a smartphone, the list is like on background and I can not scroll on the list itself.
When I try to scoll, it scroll on the page itself, not on the list.

Is-it possible to modify something to be correctly displayed on mobile?

Best Regards,
Antoine

Hi,
I've tested this panel, this is exactly what I was looking for!!!

I'd like to see such panel to Grafana, but to variables because variables are hides on kiosk mode

Thank you!