search

michaeldmoore / michaeldmoore-multistat-panel

A smart table display panel with fixed, updating rows (or columns)
MIT License
58 stars 14 forks source link

Renaming Columns #62

Open jerommeke-bos opened 3 years ago

jerommeke-bos commented 3 years ago

Hi Michael,

It would be nice to have a function where it would be possible to rename the columns. I imagine it could be something like the one you implemented as "Recolor col".

In case you'll refer to the transformation rule "Organize fields", that doesn't work, I can only rename a column a not a field value.

Best regards,

Jeroen Bos

michaeldmoore commented 3 years ago

I don't think I completely understand what you are asking for here. Something about renaming grouping and/or dates?

The case I can understand seems to be when you have a Unix-timestamp returned in a field and you want to display it as a formatted/readable date

If it weren't for the sorting aspect, I would have thought the organize-fields system in the query manager might have done the job - either by transforming value in place or by adding an additional calculated (in this case, formatted) field to the table query. I've been looking at the current functionality and I think you're right - the features needed just don't seem to be in the query manager just yet. Hopefully, there might be something like this in the future, but Grafana probably has a lot more important features to work on right now.

Maybe I could add something like you describe. A label-reformatter. I'm thinking of two use cases - one to reformat dates, the other to provide a set of name->value pairs for substitutions, probably as regular expressions.

Let me think about this some more. Michael

On Fri, 15 Jan 2021 at 11:07, jerommeke-bos notifications@github.com wrote:

Hi Michael,

It would be nice to have a function where it would be possible to rename the columns. I imagine it could be something like the one you implemented as "Recolor col".

In case you'll refer to the transformation rule "Organize fields", that doesn't work, I can only rename a column a not a field value.

Best regards,

Jeroen Bos

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/michaeldmoore/michaeldmoore-multistat-panel/issues/62, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA4NLLSGJZP6HZNOVD4CBYDS2AHVDANCNFSM4WD2GKOA .

jerommeke-bos commented 3 years ago

Hi Michael,

Thank you for your reply.

What I'm getting out of influxDB is something like this:

What I would like to do is overwrite the values in the entity_id column in grafana, ie "energy_production_low" should be replaced for the labels as "Production (low)" and I thought that this might be implemented like the "Recolor col" functionality in the "Columns" section: 2021-01-15_14-15-38

but instead of choosing a color picker, have a field where you can put in a value that is used for the label tag and when a rule is not present, or the field is empty, use the name from the originating field.

Regarding the time aspect of InfluxDB, as it is implemented as a UNIX timestamp, that you aren't able to manipulate via the query language of influxDB, it would be nice that something can be implemented to overwrite the value of a column in the graph. In fact you did implement already something like that for the tooltips: 2021-01-15_14-22-37 2021-01-15_14-23-52

If something like that could be implemented for the grouping section and columns section that would be very and I can get rid of the ugly UNIX timestamps.

Thank you already for the fantastic job you did with this plugin.

Best regards,

Jeroen Bos

michaeldmoore commented 3 years ago

I've sorted out the signing issue that was holding me up with these feature additions (thanks to Marcus O of Grafana). But I'd like to do something about this issue of your before the next release.

To that end, can you send me a csv file with your table-formatted data set so I can make sure it works properly? Also, a set of the renamed columns that you would like to see - both in the column labels and the groups.

No promises, but I think I know how to handle this.

Michael Moore

jerommeke-bos commented 3 years ago

Hello Michael,

attached you'll find the CSV export from Grafana, but because Grafana converted the datetime stamp already, I also attached the json response.

Best regards,

Jeroen Bos.

Op di 26 jan. 2021 om 20:18 schreef michaeldmoore <notifications@github.com

:

I've sorted out the signing issue that was holding me up with these feature additions (thanks to Marcus O of Grafana). But I'd like to do something about this issue of your before the next release.

To that end, can you send me a csv file with your table-formatted data set so I can make sure it works properly? Also, a set of the renamed columns that you would like to see - both in the column labels and the groups.

No promises, but I think I know how to handle this.

Michael Moore

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/michaeldmoore/michaeldmoore-multistat-panel/issues/62#issuecomment-767768644, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOT3GN5OV42JYI5URS77RRLS34IQPANCNFSM4WD2GKOA .

michaeldmoore commented 3 years ago

I think you forgot to attach the file...