Dashboard Table Graph Format

[cryptoquick]

@nathanielc asked about displaying data in a table format, and we don't currently support that as a graph type on the dashboard.

[nhaugo]

Dupe of #1031

[jaredscheib]

Not quite @nhaugo – #1031 is about Data Explorer, whereas this one's about Dashboard. Re-opening for now (the other one was closed anyway).

[botzill]

Hey guys,

Any plans to add such graph in the future ?

[nhaugo]

@botzill yes, but it is not currently schedule for any particular release.

[nhaugo]

See also #2246

[russorat]

customer feedback: this would be really useful for "Top N" tables that could be used for identify bad actors. For example, i have a list of the top apps/ips/services that are making requests and I can investigate apps that are making way too many.

[hasselrot]

Would be extremely useful!
Any updates on this?

[nhaugo]

Hi @hasselrot,
I don't can't give you an exact timing, but it is near the top of the list for 2018

[121watts]

this package might be useful https://github.com/bvaughn/react-virtualized

[russorat]

Initial Requirements:

• A user shall be able to select to display their data as a table
• A user shall be able to show or hide columns in the table
• A user shall be able to sort table by any column
• A user shall be able to override the name of each column
• A user shall be able to correlate rows of the table with data from other graphs on the dash
• A user shall be able to format the displayed timestamp
• A user shall be able to set threshold values similar to single stat and change the color of the text or background

[alexpaxton]

table-graph-design--v2.pdf

Included all the relevant details I can think of in here
I can handle styling next week

[alexpaxton]

table-graph-design--v3.pdf

[evo7master]

We often need to compare two datasets at the same point in time, so it
would be exceptionally useful to not mandate time series on one axis , but to allow comparison of multiple measurements at the same point in time in a matrix, see example below:

[russorat]

thanks @evo7master ! we will see what we can do to tackle that use case.

[russorat]

after looking at this, i've asked @alexpaxton to look into a simple way to format numbers in the table.

[russorat]

also, eventually, we may be able to use influxql functions for this: influxdata/influxdb#9625 influxdata/influxdb#9626 influxdata/influxdb#9627 influxdata/influxdb#9628

[alexpaxton]

The UI for number formatting would be super simple (at least for this initial release)
The input would be type="number" to prevent users inputting decimals or non-numerical characters. You can also enforce a max/min from the HTML itself.

This input would either truncate the value or add 0s to the end depending on the value

I'm also thinking that we should right-align cells with numerical data to ensure the decimal point is vertically aligned within each column. I arbitrarily put 3 as a reasonable default for decimal places to show.

I think in the future we'll move towards scoping some of these options (thresholds, decimal places, suffix/prefix) by column instead of applying to the whole table

[russorat]

I think that makes sense

[russorat]

• headers slightly off due to vertical scroll bar

[russorat]

• Need a way to reorder columns in the table (@ebb-tide)
• Need a way to adjust the size of the columns. Sometimes they are really wide even if the data isn't (@ischolten)
• Group by data should appear as a column duplicated for each row. This would allow you to use queries like select host, usage_user from "telegraf"."autogen"."cpu" group by host limit 1 and get a table with two columns: host and usage_user. Ask @ebb-tide for examples spreadsheet (@ebb-tide )
• In Thresholds, the default should always be the normal display of data (black with blue text). Only items that hit a threshold should have the text or background changed. ( FYI @alexpaxton )
• don't apply threshold values to the time column (@ebb-tide )

[micw]

Great work! Will there be an initial version available in 1.4.4?

[russorat]

feedback from demo:

• see if there is a way to fix the ugly scroll bars on firefox

[russorat]

Found this issue with table graphs. When jumping to the CEO, the query and visualization jumps back to the old mode.

[russorat]

• need to fix the render of subqueries: select sum("rate") from (SELECT difference("usage_user") AS "rate" FROM "kube-infra"."autogen"."cpu" WHERE time > :dashboardTime: GROUP BY *) WHERE "rate" > 0 GROUP BY cpu

[russorat]

Final few requests after using this for a little bit:

• number values in the table should be right aligned, all other values should be left aligned. In future releases, we may allow this to be configurable by columns.
• Do not highlight text values with thresholds. we may add a feature later specifically for non-numerical values
• when time column is hidden, stop syncing the scroll with other graphs.

[russorat]

• left align number is being covered by the scroll bar. Could we shift it to the left a little bit?
  

• double clicking on a frozen left column highlights the entire column (or multiple rows). Is there a way to get it to highlight a single value? Not sure if it's OS and browser specific or some css thingy.