Is there a good example making a custom graph block with data coming from a table query? I can’t get anything to display other that the x and y axis.

I created a Data Table from your example data. I named it “Entries”. [image] For the dashboard block data query, I selected the “Entries” data table and left the query fields blank, which means it will return all data from that Data Table. [image] Here’s the Vega-Lite configuration that will p…

Are you just trying to make a time series graph? Can you provide some simple example data you’d like to display?

Can you see my test graph on dashboard Energy ?

I’m not a member of your organization so I can’t see the dashboard. I wouldn’t necessarily recommend adding me to the organization based on your data security needs. If you can paste a couple of example rows with fake data, I can use that to base a graph on.

I have a very simple data table with just 3 records as follows: Record1: Xvalue=1, Yvalue=2 Record2: Xvalue=2, Yvalue=4 Record3: Xvalue=3, Yvalue=6 I can’t even get that to work. so I must be missing something completely.

Thanks, I think I figured out what I did wrong. My real table had the Xvalue as a string (containing minutes) but the format was nn:nn:nn , so nothing showed up. My current source file I would like to use contains date (as: 12/10/2018) and time (as 21:05:00) as two separate fields. Do I have to c…

That’s a good question. Vega has a concept of transforms that are likely what you’d used to combine the fields, but I don’t have much experience with those. I’ll see if I can figure it out.

If not, how should the time stamp be formatted for a time series data point?

Vega-Lite will understand dates in ISO format : [image] Time Unit Vega-Lite - a high-level grammar for statistical graphics. Vega-Lite provides a higher-level grammar for visual analysis, comparable to ggplot or Tableau, that generates complete Vega specifications. Vega-Lite specifications…

I got it kind of working. Since the date format “MM/DD/YYYY” can’t directly be parse, you can’t coerce it easily into a date, which means you lose some functionality. If you can reformat the date before storing them, things will be much easier. Anyways, here’s a transform that simply combines the d…

Thank you so much for your late hour support. I got it show pretty good now. Now to the next hurdle. My imported table data has about 20 values sampled every 2 Seconds. Dashboards graphs is able to show a graph for about 1.5 hours, but forward/rewinding doesn’t seem to work. Do I have control ove…

Vega lite graph with data from table query

Help

Dylan_Schuster December 28, 2018, 2:58pm 16

Here is a post where I helped another user do something similar in the Vega-Lite chart - combining two data sets into one.

Topic		Replies	Views
Vega Lite Custom Charts Help	11	2819	December 5, 2018
How to create a custom dashboard using Vega-lite Help dashboard , edge	4	711	January 25, 2023
Custom chart with timestamp from payload as the X axis Help workflow	2	345	February 20, 2023
VEGA data import Help dashboard , vega-lite	5	772	March 31, 2020
Latest value for custom dashboard Help dashboard	2	662	March 20, 2019

Vega lite graph with data from table query

Related topics