1
00:00:00,120 --> 00:00:03,160
OK, so let's look at the table visualization now.

2
00:00:03,180 --> 00:00:08,790
Create a dashboard, add an empty panel up here time series select table.

3
00:00:08,830 --> 00:00:11,930
OK, so it's a table for the data source.

4
00:00:11,940 --> 00:00:14,070
Let's change that to being.

5
00:00:15,310 --> 00:00:16,690
Random walk table.

6
00:00:17,140 --> 00:00:22,630
OK, so that gives us a few extra columns that we can look at can bring that across.

7
00:00:23,780 --> 00:00:24,850
This is still random.

8
00:00:25,270 --> 00:00:26,590
Each time you refresh it.

9
00:00:26,740 --> 00:00:32,710
OK, so may just resizing the column there has actually created some overrides for us, so you can either

10
00:00:32,710 --> 00:00:37,060
leave them or delete them if you wanted to, and it would go back to the way it was.

11
00:00:38,530 --> 00:00:41,080
Individual column weights will comes through with an override.

12
00:00:41,200 --> 00:00:43,270
Anyway, we'll look at overrides more in a moment.

13
00:00:43,660 --> 00:00:48,730
So panel options, of course, we can change the title my table and I can set a description.

14
00:00:48,880 --> 00:00:50,470
That's the title we wanted.

15
00:00:50,600 --> 00:00:52,180
It's a transparent background.

16
00:00:52,780 --> 00:00:55,930
OK, the table show header goes no hitter.

17
00:00:55,930 --> 00:00:58,180
Now we'll put that back on because it makes more sense.

18
00:00:58,240 --> 00:01:04,470
Column width The minimum column width 150 said that to be 100, it makes them all a little bit less

19
00:01:04,480 --> 00:01:04,870
there.

20
00:01:04,870 --> 00:01:11,320
There is no override added there because it's affecting the table as a whole column with auto, we can

21
00:01:11,320 --> 00:01:14,470
align left, center or right.

22
00:01:14,590 --> 00:01:15,880
I'll keep that auto.

23
00:01:17,350 --> 00:01:18,370
Column filters.

24
00:01:18,610 --> 00:01:27,070
OK, so that's this at the top that allows you to order by a value ascending or descending or even select

25
00:01:27,070 --> 00:01:29,230
a particular bunch of values.

26
00:01:29,260 --> 00:01:29,770
OK?

27
00:01:29,830 --> 00:01:33,160
That I'm going to clear the filter, OK, I'm going to narrow for now.

28
00:01:33,760 --> 00:01:37,690
Come back to that OK, table standard options unit.

29
00:01:37,960 --> 00:01:40,120
We can say anything we like.

30
00:01:40,300 --> 00:01:41,100
OK, minutes.

31
00:01:41,110 --> 00:01:43,750
They're all the numeric values are arc minutes.

32
00:01:44,380 --> 00:01:48,430
I'm going to leave that as a non decimal color scheme from thresholds.

33
00:01:48,590 --> 00:01:49,510
Look at that in the moment.

34
00:01:50,800 --> 00:01:56,320
Thresholds, we can use those threshold collars to change the style of the table, so going back to

35
00:01:56,320 --> 00:02:00,640
table cell display mode, auto color text.

36
00:02:00,760 --> 00:02:07,930
OK, so that text is colored from the threshold color, background gradient or solid gradient gauge

37
00:02:08,530 --> 00:02:16,180
LCD gauge, a basic gauge or adjacent view, just a data as it appears when it's entered into the system.

38
00:02:16,180 --> 00:02:19,570
As Jason, when to put it on colored background gradient.

39
00:02:19,660 --> 00:02:23,950
OK, so now we can modify the thresholds, although threshold.

40
00:02:24,250 --> 00:02:25,540
OK, so OK.

41
00:02:25,540 --> 00:02:30,270
So the date behind the scene is actually a long number, which is like an integer, but very large.

42
00:02:30,280 --> 00:02:35,260
So when you convert that date to a low number, it's actually in the millions and it's way above eighty

43
00:02:35,260 --> 00:02:35,560
three.

44
00:02:35,570 --> 00:02:37,570
So that's what's showing up as yellow there.

45
00:02:37,750 --> 00:02:40,270
But anyway, we'll come on to managing individual columns anyway.

46
00:02:40,270 --> 00:02:47,020
So if I want to see different colors amongst the I, the mean and the Max, for example, I can choose

47
00:02:47,170 --> 00:02:48,070
everything.

48
00:02:48,100 --> 00:02:50,050
Eighty four and above will be red.

49
00:02:50,140 --> 00:02:57,730
So everything under eighty four is green or green could change at 83, for example, and for yellow,

50
00:02:57,820 --> 00:03:00,810
everything 84 and above is yellow.

51
00:03:00,820 --> 00:03:04,840
If I have a number below 83, that will reorder there.

52
00:03:04,850 --> 00:03:07,460
So if I said eighty two, it's put it down there.

53
00:03:07,480 --> 00:03:12,070
So 83 82, okay, so we go one yellow so they can play around with that.

54
00:03:12,970 --> 00:03:16,990
Take so value mappings, for example, like we've seen earlier.

55
00:03:17,140 --> 00:03:25,630
We can add value mapping for anything such as a range between eighty three point one and eighty three

56
00:03:25,630 --> 00:03:26,500
point three.

57
00:03:26,510 --> 00:03:30,670
It is broken and we can set a column date.

58
00:03:30,760 --> 00:03:31,990
Okay, so we've got one broken.

59
00:03:31,990 --> 00:03:33,040
They're broken.

60
00:03:33,040 --> 00:03:34,340
They're just an example.

61
00:03:34,360 --> 00:03:36,670
I'm going to delete that update.

62
00:03:37,030 --> 00:03:37,410
OK.

63
00:03:37,630 --> 00:03:38,170
And.

64
00:03:39,310 --> 00:03:40,150
Dot links.

65
00:03:40,300 --> 00:03:45,560
We can add a link, for example, or info, and we can link to a web page.

66
00:03:45,580 --> 00:03:52,330
For example, my grandfather documentation page, if I want, I can add a query string so something

67
00:03:52,390 --> 00:03:55,090
equals I can use any of these options.

68
00:03:55,300 --> 00:03:55,960
Numeric.

69
00:03:56,500 --> 00:03:57,850
Open a new tap save.

70
00:03:58,000 --> 00:03:59,440
So now these numbers are links.

71
00:03:59,540 --> 00:04:02,530
If I click on any of those, say 86 there.

72
00:04:02,590 --> 00:04:06,250
It opens a new browser and the query string has something else.

73
00:04:06,370 --> 00:04:08,740
That's the actual number behind the.

74
00:04:08,740 --> 00:04:15,550
So even though it says 86 there, that's been rounded automatically to a decimal place using the decimals

75
00:04:15,550 --> 00:04:15,820
there.

76
00:04:15,850 --> 00:04:18,269
So I could say I'm going to have 10 decimal places.

77
00:04:18,310 --> 00:04:23,740
For example, when you see eighty five point nine six, eighty five point nine, six, etc., all letters

78
00:04:23,740 --> 00:04:24,070
all do.

79
00:04:25,180 --> 00:04:31,750
OK, so let's apply that for now, and that's a table on our dashboard, although it does look a little

80
00:04:31,750 --> 00:04:37,750
bit messy, we can improve on that and we can make these effects apply to individual columns only.

81
00:04:37,780 --> 00:04:39,070
So let's go back into that.

82
00:04:39,070 --> 00:04:39,910
I'm pressing a.

83
00:04:40,480 --> 00:04:49,270
OK, so let's put it back to the way it was before color background auto and I'll remove the data link.

84
00:04:50,860 --> 00:04:57,000
I'll keep the thresholds for now, let's add an individual override, say, for Column I.

85
00:04:57,210 --> 00:05:01,980
OK, so fields with name choose I add an override property.

86
00:05:03,550 --> 00:05:06,980
So display mode being color background.

87
00:05:07,000 --> 00:05:09,790
OK, so the column is now highlighted red.

88
00:05:10,510 --> 00:05:12,400
I'm going to do the same thing for the info column.

89
00:05:12,640 --> 00:05:21,130
OK, so you override to add a filter override fields with name, choose info override property.

90
00:05:21,280 --> 00:05:22,510
So display mode.

91
00:05:23,450 --> 00:05:25,090
Color, background gradient.

92
00:05:25,250 --> 00:05:25,700
Excellent.

93
00:05:25,730 --> 00:05:30,740
Now, actually, I'll make this one an LCD, so let's go back to override one.

94
00:05:31,310 --> 00:05:32,450
You know, he's an LCD.

95
00:05:32,540 --> 00:05:39,050
OK, so that looks quite interesting now with the info I can show down being read, for example, so

96
00:05:39,050 --> 00:05:43,970
I'll get back to override two and I'll add an override property being.

97
00:05:45,720 --> 00:05:46,860
A value mapping.

98
00:05:47,280 --> 00:05:53,130
Let's look at the value mappings, the condition value down.

99
00:05:53,850 --> 00:05:57,450
Let's set the color as red update.

100
00:05:57,630 --> 00:06:00,100
OK, so when it sits down, it's now red.

101
00:06:00,120 --> 00:06:01,780
Otherwise, its default green.

102
00:06:02,220 --> 00:06:02,820
Excellent.

103
00:06:02,850 --> 00:06:07,370
Now with min and max, I want men and Macs to be center aligned.

104
00:06:07,410 --> 00:06:10,260
So I'll add another field override this time.

105
00:06:10,260 --> 00:06:13,590
All use of field names with matching rejects.

106
00:06:13,960 --> 00:06:21,700
OK, so the regular expression for that will be a min or max that character in the middle there.

107
00:06:21,720 --> 00:06:27,570
That is a pipe and you'll find that in your keyboard, on my keyboard that is next to the Z key and

108
00:06:27,570 --> 00:06:28,320
you press shift.

109
00:06:28,470 --> 00:06:29,610
That's a pipe character.

110
00:06:29,650 --> 00:06:33,390
OK, so that's my override for min and Max using a rejects.

111
00:06:33,480 --> 00:06:37,740
I'll add the Override Property Column Alignment Center.

112
00:06:37,760 --> 00:06:43,680
OK, so just mean and Macs are now centers, so you have the ability to do all kinds of overrides on

113
00:06:43,680 --> 00:06:44,760
individual columns.

114
00:06:45,060 --> 00:06:47,160
OK, so let's apply that and we can see that.

115
00:06:47,160 --> 00:06:49,330
So that's already quite interesting.

116
00:06:49,410 --> 00:06:52,590
Looking table that's a table visualization.

117
00:06:52,770 --> 00:06:53,520
Very versatile.

118
00:06:53,910 --> 00:06:54,300
Excellent.