OK, so now I'm going to show you how to graph noontime time series as your data in.
OK, so long time series data is data that doesn't have timestamps.
So for example, in the last video, I'm on my SQL server here logging into to Moscow if I select all
from my two status order by time est descending limit.
10.
All these values have a timestamp.
OK, so this is from the last VIDEO In this video, I'm going to show you how to graph this kind of
data where the data is just names and values.
There's no timestamp there, and you'll find tables, autism databases where they are built just to
be a summary of statistics, for example.
There's nothing sophisticated about it.
It's just rows and values.
OK, so normally microphone is used for graphing time stamped data, but I'll show you how to do something
like this.
OK, so to demonstrate this, log on to your Moscow and we'll create a simple database called Example
Database.
So copy that line.
Don't copy the great event sign.
Obviously, no signs to indicate that these are SQL statements throughout my documentation, so I'm
already logged into my my there.
Right click Create Database Example DB.
OK, so now show databases and I have a new database called Example DB.
Now we can add a table to that.
First, let's create that table.
So I just copy that section there, not the arrow.
This is a great table command in Haskell.
Your credit type of code.
Simple table on example DB with an ID username and total columns.
Until now, let's just fill it with some data so that we have something to query to insert into example
DB.
Simple table use name total columns just these values.
It's all hypothetical data has just been made up.
Any resemblance to anything real is purely accidental and coincidental.
I just made it up because we need some data to query, Hey, we can check that data exists, select
or from simple table there.
And then we go.
That table exists.
Neither doesn't have timestamps, so we can't visualize that in Gravano sort of way.
Now, Amber, when we created the my to collect a, we had to give our user co-founder a microphone,
a service IP address, select permissions.
Well, that user won't have select permissions on Example DB Simple Table.
So let's add that now.
So we'll grant select on this particular table to my user, and I just have to update the IP address
to being that of microphone a server, which is that now press enter.
That is because it's microphone, a server that will be making the connection to the secure database.
Using a user call Carafano from that IP address.
So that way, the host that my is allowing flush privileges, lost privileges and we can quit.
Excellent.
Now let's go and take a photo and go to the Explore tab Explore Select module, which is already is
going to edit SQL and replace the template that has given us with this so missing control i.e. to select
all and control V to paste.
Click out of that.
So if we do table, we could see the actual table data now in your file there, the values down the
right there.
We can't see that as time series because there is no time clock, so we need to invent a time column.
And to do that, we can add an extra line code now as time second.
So up here, select now as time second.
Now is an actual function that tells you what the current date is and what returning it as the column
time sick.
So for now, run that query as a table.
Again, we're seeing a time column now.
Now that time column is just now, so it's always going to be the most recent time, which is now.
So if I run that again, every time you run it, the seconds and milliseconds on the Saints will be
updated.
OK, so that's a trick.
But the problem with that is you can't really graph it as a default graph.
In Safana.
We can see that series names down there, but Definer isn't really able to show us what's happening
exactly right now.
So on this graph, anyway, so just copy this section and we'll go into our last dashboard the way credit
in the last video.
The dashboard time that was new Dashboard Copy three, that is the custom query.
There are credit in the last video do that for twenty four hours.
It looks a little more interesting.
They add panel, add an empty panel.
Moscow Edit Squirrel Control Light is like dual control V2 placed.
Click out of that.
Now we have time series.
Split it up there.
Change that to gauge and that is a graph of the values in my simple table there in the database looking
at the documentation.
There it is.
That's the data that I've put into the database using this insert command.
Now not only can we use the page, we can also use the stat, the gauge and also the pie chart.
So there are many options there on how you want to display that.
I'm going to use the bar gauge and select horizontal, for example, retro LCD that looks pretty good
or vertical.
I can also use thresholds, so a lot of few thresholds.
And change their orders, so, for example, that that can be 20, that can be 30, that can be 40 and
that can be 50, for example.
Apply that and then we go, that's a bar graph of my simple table in the database.
Now if I said that to refresh it five seconds, so it's asking the database every five seconds now for
the latest data, I can log in to my MySchool again and I can update one of these values using a new
skill statement toward the bottom there.
Update example DBE simple table set.
Total equals 50 where username equals koala will end to that.
Your statement is right clicking so it's going to set total equals 50.
Where username is koala, that's the koala column that's currently 26.
And so in a moment that'll be 50.
OK, I guess that's updating every five seconds.
We can change that again to being something like 150.
There we go.
Put it down to something else, like 50 and change different one.
And let's try changing Amir to being 50 as well, the same, you know, to the five second update,
it's updated.
So you might have tables like that and you might want to grab some and they might not be time stamped,
but you can still show them in profile if you need to.
Anyway, that's non time series data and you have lots of options on the presentation.
Excellent.