PPaT Wiki
Ngaahi fakamatalaPathwayFōlomuTohi fakamatalaFetuʻutaki
Week streakFOUNDATION0 badges
Lea: Lea faka-Tonga
  • English
  • Nederlands
  • Français
  • Deutsch
  • Lea faka-Tonga
  • Te reo Māori
  • မြန်မာ (Burmese)
Fehuʻi ki he komiunitī

Your PaT Pathway

0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  • Fakamatala Fakalūkufua ʻo e Temipileiti ʻo e ʻIuniti Pisinisi PaT
  • Fakamatala mei he kau ako ki he LMS: ngaahi fakafuofua mo e ngaahi fakamatala
  • Fokotuʻutuʻu ʻo e Kautaha: ngaahi faʻahinga ngāue
  • Fokotuʻutuʻu ʻo e Kautahá: ngaahi kautaha kasitomā
  • Fokotuʻutuʻu ʻo e Kautaha: ngaahi kōlomu ki ha feituʻu ngāue pe ko ha fonua
  • Fokotuʻutuʻu ʻo e Kautahá: tānaki ha tokotaha ngāue foʻou
  • Fokotuʻutuʻu ʻo e Sisitimi: ngaahi fokotuʻutuʻu ʻa e kautahá
  • Founga Fakatuʻutuʻu ʻo e Kautahá: ngaahi potungāué, ngaahi hingoa ʻo e ngāué mo e ngaahi fatongiá
  • Founga hono faʻu ha polokalama ako ki he portal ako PaT Lite
  • Founga hono fakatonutonu ha pōpoaki kuo ʻosi tuku ʻi he Papa Pōpoaki
  • Founga hono fokotuʻu hoʻo SD Map
  • Ko e saati ʻo e fokotuʻutuʻu fakapōpula ʻo e kautahá
  • Ko hono fakafiemālieʻi ʻo e ngaahi fakapapauʻi foʻoú mo e ngaahi fakalalahi
  • Ngaahi Fehokotakiʻanga: fakafehokotaki ʻa e PaT ki he Microsoft 365
  • Ngaahi Fika Fakafuofua ʻo e LMS - Kapau ʻoku ʻikai te ke lava ʻo fua ia, ʻe ʻikai te ke lava ʻo puleʻi ia
  • Ngaahi Foomu - Fakafehokotaki API
  • Ngāue ʻa e Sīstemí: ngaahi fakatokanga hake, hū ki loto, ngaahi ʻīmeili mo e ngaahi meʻa lahi ange
  • Puleʻi ʻo e kau ngāueʻaki
  • SD Ngaahi Founga Ngāue - Fakahu Tuʻo Lahi
  • SD Ngaahi ngāue fakahokohoko - Ngaahi fokotuʻutuʻu ʻo e ngāue fakahokohoko
  • Ako fakatautaha ki he kasitomā: founga ʻoku ngāue aí
  • Faitotonu ʻi hono Fakakakato ʻo e Ngāue: ko e hā ia pea ko e hā ʻoku holo ai
  • Fakaafeʻi ʻa e Kau Māʻuí
  • Fakafekauʻaki ʻo e SDs ʻi he SDs
  • Fakahokohoko mo kumi ʻo e SDs
  • Fakahū ʻa e fakamatala ʻoku fakafoʻou hokohoko ki ha SD (ngaahi kiʻi saati mo e ngaahi tēpile lauʻileʻā)
  • Fakamanatu ki he pōtalanoa
  • Fepōtalanoaʻaki ki he ʻīmeili pea toe foki ki he fepōtalanoaʻaki
  • Fepōtalanoaʻaki ki he ngāue pea ki he poloseki
  • Fokotuʻutuʻu ʻo e LMS
  • Founga ʻoku tokangaʻi ai ʻe he PaT ʻa e Kau Ngāue ʻOku ʻIkai Kei Ngāue
  • Founga ke fakaava ai ha kōosi ako ki ha tokotaha ngāue
  • Hiki ʻo e Ngaahi Hingoa ʻo e Konga
  • ʻĀ Fakafōmú
  • ʻAi e SDs ʻi he Dock pea Fakahoungaʻi e Ngaahi ʻĪmisi
  • ʻĪmeili ki he BFF
  • Ko e anga hono ngāue ʻa e ngaahi pōtalanoa SD mo e kau Mēmipa SD mo e Kau Ngāueʻaki mei Tuʻa
  • Ko e Meʻa ke Fakaava Atu ʻa e Talanoa Fepōtalanoaʻaki
  • Ko e Ngaahi Fakaʻilonga Fakapipiki C2E
  • Ko Hono Fakahoko ʻo e Ngaahi Fakataha ʻaki ʻa e SDs
  • Ko hono ngāueʻaki ʻo e SDs ko ha polokalama lipooti pe lekooti fakataha
  • Meili ki he pōtalanoa ki he meili – ki he kau ngāueʻaki ʻoku ʻikai ko e kau ngāueʻaki ʻo e PaT
  • Muimuiʻi ʻa e kau kau mai
  • Ngaahi Fakaʻaongaʻi Kehekehe ʻo e Fōmú
  • Ngaahi fakaʻilonga fakamatala
  • Ngaahi fetalanoaʻaki ʻi loto
  • Ngaahi Fetalanoaʻaki kuo Fakapipiki
  • Ngaahi loki vitiō: kau ʻaʻahi ʻoku nau kau mai mo kole ke hiki
  • Ngaahi Lue Malu
  • Ngaahi Ngāue Fakataha
  • Ngaahi Ngāue ʻa e Tokotaha ʻOmi ʻo e SD
  • Ngaahi ngāue ʻoku toutou fakahoko: fokotuʻu mo fakatonutonu
  • Ngaahi sīpinga foomu ki he moʻui lelei mo e malu
  • Ngaahi sivi fakamoʻoni: fakakakato ha taha
  • Ngaahi Siviʻi ʻo e Mahino
  • Ngaahi Tali ki he Foomu SD: kumi mo hiki atu ʻa e ngaahi tali ki he foomu
  • PaT AI
  • SD Ko e vakai ki he holisi ʻo e Ngāue
  • SD Vahevahe ʻo e Ngaahi ʻElemēniti
  • Talanoa ki he SD
  • Tānaki ha ʻĪmisi ke Ngāueʻaki ko e Fakaʻilonga ʻi he ʻUluʻi Konga
  • Vaheʻi ha SD ki ha mātuʻa foʻou
  • Vahevahe mo lekooti hoʻo sioʻata
  • Akoʻi ʻo e Mōtiula - Komipiuta tēpile
  • Akoʻi ʻo e Mōtiule - Telefoni toʻotoʻo
  • Faʻu ha SD foʻou
  • Fakahū ha ngaahi fehokotakiʻanga
  • Fakanounou AI: ko ha fakanounou vave ʻo ha SD
  • Fakatupu ha Ngāue
  • Fetuʻutaki ʻoku fekauʻaki mo e ngāué
  • Founga hono ngāueʻaki ʻo e uepisaiti akoʻi PaT Lite
  • Founga ke fakahū ai ʻa Outlook ʻi loto ʻi hoʻo PaT
  • Founga ke liliu ai e lahi ʻo hoʻo palakipoe ʻinitaneti ke sio lelei taha ki he PaT
  • Funga Talanoa
  • Hiki hake ʻa e ngaahi faile fakapipiki
  • Hū ki he PaT pea toe fokotuʻu hoʻo lea fufuú
  • Hū ki loto ʻo ngāueʻaki ʻa e MFA: ko e sitepu hono ua
  • ʻIkai ʻi he Ngāue: fakamoʻui ia, mo e tohimāhina ʻi ho Holisi Ngāue
  • Ko e fakaʻilonga ʻo e fakafehokotaki ʻi hoʻo desktop PaT
  • Ko e fakalakalaka ʻoku fakaʻilongaʻi ʻaki e lanu ʻo e maama fakamafola-meʻa-fononga
  • Ko e ngaahi tā vitiō ʻi he polokalama telefoni toʻotoʻo
  • Ko e tuʻunga ʻo e ngāue ʻa e PaT: ko e peesi ʻo e tuʻunga, ngaahi fakatokanga ki he tuʻunga mo e ngaahi fanongonongo ki he tuʻunga
  • Ko Hoku Fakamatala Fakataautaha
  • Kumi Fakalūkufua
  • Kumi tokoni: ko e Helpdesk ʻo e PaT
  • Lau ha SD ʻi ha lea fakafonua ʻe taha
  • Lekooti mo Puleʻi ʻa e Ngaahi Fakatuʻutāmaki
  • Lekooti mo Puleʻi ʻa e Ngaahi Meʻa Fakatuʻutāmaki
  • Liliu ha Fakahāhā ki ha Ngāue
  • Liliu ʻa e pōtalanoa ki ha ngāue
  • Ngaahi Extension Chrome Mahuʻinga
  • Ngaahi fakatokanga ki he ngaahi fakamatala ʻo e tukuange: ko ha talanoa Sys Bot ʻi he taimi ʻoku liliu ai ʻa e ngaahi fakamatala ʻo e tukuange ʻa PaT
  • Ngaahi Fakatokangaʻi
  • Ngaahi Fakatokangaʻi Meʻa Vave
  • Ngaahi Fanongonongo ʻo e Ngāue
  • Ngaahi founga maluʻi ki ha kau ngāue tokolahi ʻi ha meʻangāue pē ʻe taha
  • Ngaahi Hingoa ʻo e Konga
  • Ngaahi Konga SD
  • Ngaahi Talanoa Fakakulupu
  • Pā Tatā ʻo e Ngaahi Ngāue
  • Palopalema ʻi he 2FA ʻa Outlook
  • PaT foʻou PaT – Ngaahi talanoa mo e SDs
  • PaT Mobile App – Fakamatala fakalukufua
  • PaT Vakai Fakalūkufua ki he Chat
  • PaT Wiki: fekumi, tali ʻa e AI mo hono fakafuofuaʻi
  • PaT Wiki: kumi ho hala ʻi loto
  • Puleʻi ʻo e Ngāue
  • SD Ngaahi meʻa ʻaonga ʻi he peesi tefito
  • SD Vakai Fakalūkufua
  • Sisitēme ki hono Puleʻi ʻo e Ngaahi Ngāue
  • Tānaki ha kau mēmipa pea fokotuʻu honau ngofua
  • Tauhiʻanga Tohi: ngaahi fehokotakiʻanga vahevahe, hoʻo ngaahi kōpaki mo e ngaahi meʻa ʻoku ke saiʻia taha aí
  • Tuku ha Fakamatala ʻi he Papa Fanongonongo
  • Vahevahe ʻa e Fakamatala
  • Vakaiʻi kimuʻa, hiki ki lalo pea vahevahe ʻa e ngaahi faile
  • Wiki ʻo e kautahá: kumi ʻi he ngaahi module ʻa hoʻo kautaha
  • Ako makehe maʻá e kau kasitomā: hono fokotuʻutuʻu
  • Akoʻi lelei ʻa e Fakaʻilonga Palani ʻo e Founga Fakapisinisi
  • Calculated fields and calculated columns
  • Charts: options for lines, bars, axes and single values
  • Data sources: stage filters, dynamic dates and page values
  • Fakaheka hake fakahangatonu
  • Fakahinohino ki he AI: vakaiʻi pe ʻoku ʻi ai ha ngaahi tikite kehe ʻoku tatau honau fika
  • Fakaʻētita ʻo e Playbook: tānaki ha sitepu kumi ʻi he portal
  • Fakangatangata ʻo e lahi
  • Fokotuʻu ha founga lipooti
  • Fokotuʻutuʻu Fakasioʻatā
  • Fokotuʻutuʻu foomu: ngaahi faʻahinga ʻo e ngaahi konga
  • Fokotuʻutuʻu ha UDF: ngaahi kōlomu mo e ngaahi kōlomu fikaʻi
  • Fokotuʻutuʻu ʻo e Fakatokanga ki hono Fakakakato ʻo e Mōʻule
  • Foomu - Toʻo ʻa e Fakamatala (ko e meʻangāue AI ki hono faʻu ʻo e foomu)
  • Foomu ʻo e SD
  • Form Builder: layout at each screen size
  • Form Builder: tools and shortcuts
  • Founga hono faʻu ʻo e ngaahi ʻeke sivi ʻo e kōsí
  • Founga hono faʻu ʻo e ngaahi sivi fakamoʻoni ʻo e kōsí
  • Founga hono faʻu ʻo e ngaahi sivi mahinoʻi ʻo e ngaahi kōsí
  • Founga hono fakahū ha SD ki he LMS
  • Founga hono ngāueʻaki ʻo e PAR SD
  • Founga hono tuku ʻo e ngaahi konga foomu ki he SD
  • Founga ʻe lava ai ʻe he kau pule ʻo fakamoʻui ʻa e OOF maʻá e kau ngāue ʻoku nau puleʻí
  • Founga ke fakamoʻui ai ʻa e ngaahi sīpinga foomu ke ngāueʻaki ʻe he tokotaha kotoa pē
  • Founga ke fokotuʻu ai ha ngaahi mōtula ʻi he Module Publisher
  • Grids linked to a reporting SD: history charts and review comments
  • Grids: columns, formats and filters
  • Grids: conditional formatting
  • Grids: flatten and transpose data
  • Grids: rows, default values and editing rules
  • ʻĒtita ʻo e Playbook: tānaki ha sitepu ke kaniseli ha ʻota
  • Ko hono fokotuʻutuʻu ʻo ha UDF: ngaahi filita, fakakulupu mo e ngaahi fakaikiiki ʻo e endpoint
  • Lipooti Hangatonu ʻo e Moʻui Lelei mo e Maluʻi (H&S)
  • Mōtē Siviʻi ʻo e Foomu
  • Ngaahi Fili ki he Meʻa ʻi Lotó ʻa e Pulusi ʻo e Mōjulí
  • Ngaahi foʻi patoni ʻo e foomu, ngaahi PDF pea mo e meʻa ʻoku hoko hili hono ʻave
  • Ngaahi Fōmú ʻoku Tuʻumaʻu
  • Ngaahi konga ke fakafonu: ngaahi tuʻunga ʻoku fokotuʻu ʻi muʻa, lau pē mo e ngaahi fokotuʻutuʻu kehe
  • Ngaahi malaʻe ʻoku fiemaʻu, vakaiʻi ʻo e tali mo e ngaahi koniteina
  • Ngāueʻaki ʻa e Chat to SD ke ke liliu mei ha pule lelei ki ha pule lelei ange
  • Ngāueʻaki ʻo e SDs ko e Tohi LMS
  • PaT SD Fakahāhā ʻo e Mape
  • PaT SD Mape Fakakātoa
  • PaT SD Vakaiʻi Fakalukufua ki he Ngaahi Temipileiti
  • Playbook Admin: ʻi he taimi ʻoku mateuteu ai hoʻo shadow run ke vakaiʻi
  • Puleʻi ʻo e Endpoint: kumi ʻa e ngaahi endpoint pea faʻu hoʻo UDF pē ʻaʻau
  • Puleʻi ʻo e Module: kumi mo puleʻi ʻa e ngaahi module
  • Puleʻi ʻo e Ngaahi Fetalanoaʻaki – Ngaahi Faleʻi ʻaonga
  • Puleʻi ʻo e Playbook: ko e ngaahi tikite ʻoku ʻi mui ʻi he faʻahinga kotoa pē ʻo e Tuʻunga Lelei mo e Fakamolé
  • Rich text, file uploads and speech to text
  • SD Dashboard: langa ha dashboard
  • SD Ngaahi Fakamaʻu Maluʻi
  • SD Ngaahi Ngāue Tokoni ki he Sīpinga
  • Sīsitemi ʻo e Palani Fakataumuʻa
  • Stacked views, flip cards, tabs and stages
  • PaT Lite: Ko e ngaahi konga mahuʻinga ʻo e PaT ʻoku fiemaʻu ke mahino kiate koe
  • Ko e hā ʻa e PaT pea ko e hā hono mahuʻinga
  • PaT Lite: Talanoa ke Ngāue
  • PaT Lite: Fakafeʻiloaki ʻo e Strategy Documents
  • PaT Lite: Ko e Fakakaukauʻanga Tefito — Ngaahi Tuʻunga mo e Fakahoko ʻo e Ngaahi Founga Ngāue
  • PaT Lite: Ko e ngaahi meʻangāue poto ʻoku fakakaukau fakataha mo koe
  • PaT Lite: Ko e kahaʻu ʻo e pisinisi ko e anga fakafonua
  • maluʻi
  • Ngaahi fakafetuʻutaki
0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  1. Ngaahi fakamatala fakahinohino
  2. Fakalakalaka
  3. Charts: options for lines, bars, axes and single values

ʻOku teʻeki ke liliu ʻa e peesi ko ʻení, ko ia ʻoku hā ia ʻi he lea faka-Pilitāniá.

Charts: options for lines, bars, axes and single values

Summary This lesson is for the people who build dashboards in PaT, and for anyone who reads them. It covers the newer chart options: separating overlapping lines, changing how a line chart draws its…

Check yourself

ʻOku vakaiʻi hoʻo hu ki he PaT…

How To

ʻI he peesi ko ʻení
  • Opening a chart's options
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Line charts: separating overlapping lines
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Line charts: line width, dots, fill and end values
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Giving both Y axes the same scale
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Setting the axis label fonts
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Making form submission dates bold on the X axis
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Sorting bars, and rounded corners on stacked bars
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Reading the Chart Data Notes
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Seeing where a chart's data comes from
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Drilling down by group from a table
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Showing a single value as a card
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Step 11
  • Adding a trend line and a change figure to a card
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Purpose / Intent of the Module
  • Header One

Summary This lesson is for the people who build dashboards in PaT, and for anyone who reads them. It covers the newer chart options: separating overlapping lines, changing how a line chart draws its lines, giving both Y axes the same scale, setting the font and size of the axis labels, showing form submission dates in bold on the X axis, sorting stacked bars, the Chart Data Notes, the Source Details window, drilling down by group from a table, and showing a single value as a card, with a trend line and a change figure. To add a chart and connect it to its data first, see the lesson SD Dashboard: building a dashboard.

Opening a chart's options

Step 1

The person who builds the dashboard sets these options in SD Dashboard. Open the SD, click its Advanced tab, then in the menu on the left, under PaT BI, click SD Dashboard.

Step 2

On the canvas, click the chart's edit button (the pencil, at its top right). The Edit form field window opens, and its title names the chart, for example Edit form field Line Chart.

Step 3

The options in this lesson are on the General tab, below the X Axis Column and the grid of the chart's data. Each row of that grid is one series (one line, or one set of bars), with columns such as Y Axis, Data Reference, Color and Order.

Step 4

To keep your changes, click the green Save and Close button at the bottom right of the window. Its label ends with the same name as the window's title, such as Save and Close Line Chart. The red Close, at the top right, leaves the chart as it was.

Line charts: separating overlapping lines

Step 1

On a Line Chart, Separate Overlapping Lines is on the General tab, just below Link Y-Axis. It is on by default, also for line charts made before the option existed.

Step 2

When it is on, lines with the same or very close values are drawn a few pixels apart, so every line stays visible.

Step 3

Only lines that overlap somewhere are moved, and a moved line moves along its whole length. Lines on the left Y axis and lines on the right Y axis are compared separately.

Step 4

The values do not change. Pointing at a line still shows its real values, and a small gap between two lines does not mean their values differ.

Step 5

To draw every line exactly on its values, switch Separate Overlapping Lines off, then click the green Save and Close button.

Line charts: line width, dots, fill and end values

Step 1

A Line Chart has six more settings for its lines on the General tab, just below Separate Overlapping Lines. Each one leaves the chart as before until you set it. A Multi Axis Line Chart and a Mixed Type Chart do not have them.

Step 2

Line width (1 to 4 px) sets how thick the lines are drawn. Type a number of pixels from 1 to 4, such as 2.5. Left empty, the lines keep their usual width.

Step 3

Dots on the lines sets which points get a dot: On every point (as before), On the last point only, or None.

Step 4

Soft fill under the lines shades the area under a line in a pale tint of its colour: None (as before), Under the first line, or Under every line. The fill is not listed in the legend or the tooltip.

Step 5

Switch on Value at the end of each line to put a dot on each line's last point, with its value beside it. Whole numbers show as they are, and other values are rounded to one decimal place.

Step 6

Text after the end value (e.g. %) adds a short text after each end value, for example % to show 63%. It shows only while Value at the end of each line is on.

Step 7

Switch on Short lines in the legend to mark each line in the legend with a short plain line.

Step 8

Click the green Save and Close button. The chart then draws its lines with the settings you chose.

Giving both Y axes the same scale

Step 1

Link Y-Axis is on the General tab of a Line Chart, Bar Chart, Stacked Bar Chart, Multi Axis Line Chart, Mixed Type Chart and Vertical Combined Chart, below the Y axis Max Value boxes (and the Min Value boxes, where the chart has them).

Step 2

It matters when the chart has a right Y axis, that is when at least one row of the data grid has Right in its Y Axis column.

Step 3

Switch Link Y-Axis on to give the left and right Y axes the same scale, with the same lowest and highest values, so the two sides can be compared at a glance. With the Max Value and Min Value boxes empty, the scale fits the values on both sides.

Step 4

While Link Y-Axis is on, a number you type in a Max Value or Min Value box still counts. If only one side has a number for an end, both axes use it there. For example, with 90 in Left Y Axis Min Value and Right Y Axis Min Value empty, both axes start at 90.

Step 5

If both sides have a number for the same end, both axes use the lower Min Value, or the higher Max Value. A value past a number you set still shows: its axis stretches to reach it.

Step 6

On a Vertical Combined Chart the value axes run along the bottom and the top. Its Left Y Axis boxes set the bottom axis, and its Right Y Axis boxes the top one. Link Y-Axis gives the bottom and top axes the same scale, as it does the left and right ones.

Setting the axis label fonts

Step 1

On a Line Chart, Bar Chart, Stacked Bar Chart, Multi Axis Line Chart, Mixed Type Chart and Vertical Combined Chart, the General tab has X Axis Font Family and X Axis Font Size (px), and, below Show Y Axis, Y Axis Font Family and Y Axis Font Size (px).

Step 2

Each Font Family list offers Inherit (page default), Arial, Helvetica, Roboto, Georgia, Times New Roman, Courier New and Monospace. Type each size in pixels.

Step 3

Click the green Save and Close button. The chart draws its X axis labels, and its Y axis labels, in the chosen font and size. A chart with two Y axes uses the Y axis font on both.

Step 4

For a chart with no font chosen, the window shows Inherit (page default) and empty sizes, and the chart looks as it did before. When you open the window again, it shows the fonts you saved.

Step 5

A Pie Chart has no axes, so its window has no axis font settings.

Making form submission dates bold on the X axis

Step 1

Bold X-Axis Labels for Form Submissions is on the General tab of a Line Chart, Bar Chart, Stacked Bar Chart, Multi Axis Line Chart and Mixed Type Chart, just above X Axis Font Family.

Step 2

It works when the chart's data source fills in the missing days, with Fill gaps in days - Add missing days as the Gap Filling Strategy of its date column, in Configure Data Source. Without that, the switch changes nothing.

Step 3

Switch it on, then click the green Save and Close button. On the X axis, each date that came from a form submission is shown in bold, and the days that were added stay in normal type.

Step 4

The dates keep the chart's Date Format, bold or not, for example 03/11/2026 with DD/MM/YYYY.

Sorting bars, and rounded corners on stacked bars

Step 1

On a Stacked Bar Chart, Element Sort Order sets the order of the parts in each bar. It is on the General tab, just below the data grid.

Step 2

By Minimum Value (Default) puts the series with the lowest value first, and By Maximum Value puts the series with the highest value first. Alphabetical (A-Z) sorts the series by name.

Step 3

Data Settings Order (Grid Above) keeps the order of the rows in the data grid. Manual (Use Order Column from Grid Above) follows the numbers in the grid's Order column, lowest first.

Step 4

The first series is drawn at the base of each bar, next to the X axis, and comes first in the legend.

Step 5

On a Bar Chart or a Line Chart, the Order column sets the order by itself: the series are drawn, and listed in the legend, from the lowest Order number up. Each new row of the grid gets the next number.

Step 6

Stacked bars have rounded corners at their outer end: at the top of a stack above zero, and at the bottom of a stack below zero. There is nothing to set, and the rounding stays on the outer part even when the part above it is zero.

Reading the Chart Data Notes

Step 1

While you build the dashboard, a grey box headed Chart Data Notes shows above each chart on the canvas. Its notes say what PaT found in the chart's data, for example which numeric fields it uses for the Y axis.

Step 2

Notes longer than about 40 characters are cut short and end in three dots. View full notes shows under the list whenever a note is cut short.

Step 3

Click View full notes. The Chart Data Notes pop-up opens and shows every note in full.

Step 4

Click Close, or the cross at the top right, to go back. Clicking outside the pop-up also closes it.

Step 5

People viewing the finished dashboard do not see the Chart Data Notes.

Seeing where a chart's data comes from

Step 1

At the top right of a chart, beside its title, click the three dots (More options). The menu includes Export as SVG, Export as PNG and Source Details.

Step 2

Source Details is in the menu when the chart's endpoint sends details of its source. Anyone viewing the dashboard can open it, as well as the person who builds it.

Step 3

Click Source Details. The Data Source Details window opens.

Step 4

Source Name gives the name of the endpoint. To copy the name, click the copy icon beside it.

Step 5

Below it are the endpoint's Description, when it has one, and its Connection Type, such as Form Responses, API, Database or User Defined.

Step 6

Applied Filters lists each filter on the data, with its field, its operator and its value, then a one-line Summary. With no filters, it says No filters applied.

Step 7

If Open in Data Source Manager shows beside Close, at the bottom of the window, click it to look the source up in the Data Source Manager. It opens in a new browser tab.

Step 8

Click Close to go back to the chart.

Step 9

The three dots show only while the chart's title shows. When Hide Title is on in the chart's settings, they are hidden too.

Drilling down by group from a table

Step 1

A Table grid on a dashboard can open a history graph from its cells. To set it up, the person who builds the dashboard clicks the Table grid's edit button (the pencil), opens the Advanced tab and chooses the reporting SD in Reporting SD?.

Step 2

Reporting SD? is for a Table grid whose Data Mode is Endpoint pulled from a data source, with an endpoint whose data comes from Form Responses. It shows on the Advanced tab only for such a grid.

Step 3

People viewing the dashboard can point at a cell's value to see View history for, followed by the column's name. Clicking the value opens a history pop-up titled with the column's name, with a graph of that answer's history.

Step 4

The graph drills down by group when the table's UDF keeps only the latest response for each group, for example one row per site. It then shows the history of the row's group, for example one site, instead of the history of the row's contact.

Step 5

To set a Form Responses UDF up that way, open its Query Builder tab. Under Advance Settings, in Last Response by Fields, switch on Only Latest Response Per Field Combination, then pick the group in Group By Fields.

Step 6

The graph uses the first field in Group By Fields. With the switch off, the graph shows the history of the row's contact. For more on UDFs, see the lesson Configuring a UDF: filters, grouping and endpoint details.

Showing a single value as a card

Step 1

Single Value Display, in the Reporting group of the Controls tab, shows one figure from an endpoint, such as a total, with its label. Drag it onto the canvas, then click its edit button (the pencil).

Step 2

On the General tab, set Data Mode to Endpoint pulled from a data source, then choose the Endpoint. Then pick which of the endpoint's columns holds the figure, and which holds its label.

Step 3

Use First or Last row in endpoint sets which row the figure comes from: First or Last.

Step 4

Display Format sets the look: Simple, Card, Highlight or Inline. Card wraps the figure in a card, Highlight gives it a solid background colour and bold text, and Inline styles it like a pill.

Step 5

Display Type sets how the value is written: Text, Number, Currency, Percentage or Date. Currency adds a dollar sign, and Percentage adds a percent sign.

Step 6

Layout sets what shows: Label and Value, Value Only, Icon Label and Value, or Icon and Value. For an icon, choose it, its size and its colour under Icon Settings.

Step 7

Fill Colour sets the background of a Highlight card, and tints an Inline one. It does not change Simple or Card.

Step 8

If the value is a date, type its format in Date Format for Value (If value is detected as date), for example YYYY-MM-DD. Left empty, it uses DD/MM/YYYY. Date Format for Label (If label is detected as date) does the same for the label. A plain number, such as 1250, is never taken for a date.

Step 9

Figure size makes the figure Normal, Large or Hero (very large). It has no effect when Display Format is Inline.

Step 10

Switch on Icon in a soft circle to show the icon on a pale round background. It needs a Layout that shows an icon.

Step 11

Click the green Save and Close Single Value Display button, at the bottom right of the window, to keep the changes.

Adding a trend line and a change figure to a card

Step 1

A Single Value Display can show a small trend line and a change figure from its endpoint, when its Display Format is Simple, Card or Highlight. Their settings are on the General tab, just below Endpoint value column. Each one is off until you set it.

Step 2

In Trend line column, choose the endpoint's column that holds recent values. The card draws them as a small line under the figure, with a dot on the last value.

Step 3

The Trend line column can hold a list in the row the card shows, oldest first, such as 61,63,,68. An empty entry leaves a gap in the line. If the column holds a single number, the card uses that column down every row instead, one row for each period.

Step 4

Trend line size makes the line Small or Large. Trend line dot colour sets the colour of the dot on the last value.

Step 5

In Change column, choose the column that holds the change since the last period, a number such as 4 or -23. The card shows it with an arrow that points up for a rise and down for a fall. Change unit (e.g. pts) adds a word after the number, such as pts.

Step 6

A change is good when it goes sets which way is good: Up, Down or Neither (always grey). A good change shows in green and a bad one in red. Unless you change it, a rise is good.

Step 7

Show the change places the change As a line under the figure, or As a pill beside the figure.

Step 8

Click the green Save and Close Single Value Display button, at the bottom right of the window, to keep the changes.

Purpose / Intent of the Module

A brief description of what this module is about

Header One

Ready? Back to the quiz

Rate this page

Checking your PaT sign-in…

Ki muʻaCalculated fields and calculated columnsHoko atu Data sources: stage filters, dynamic dates and page values

ʻI he peesi ko ʻení

  • Opening a chart's options
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Line charts: separating overlapping lines
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Line charts: line width, dots, fill and end values
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Giving both Y axes the same scale
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Setting the axis label fonts
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Making form submission dates bold on the X axis
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Sorting bars, and rounded corners on stacked bars
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Reading the Chart Data Notes
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Seeing where a chart's data comes from
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Drilling down by group from a table
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Showing a single value as a card
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Step 9
  • Step 10
  • Step 11
  • Adding a trend line and a change figure to a card
  • Step 1
  • Step 2
  • Step 3
  • Step 4
  • Step 5
  • Step 6
  • Step 7
  • Step 8
  • Purpose / Intent of the Module
  • Header One
PPaT Wiki

Ko e fakamatala, feituʻu tauhi ʻilo mo e tokoni fakakolo ki he People and Tasks.

Fakamatala

  • Kamata
  • Ngaahi fakakaukau tefito
  • Ngaahi fakatahatahaʻanga
  • Fakahinohino ki he API Coming soon

Tokoni

  • Feituʻu tauhi ʻilo
  • Ngaahi fakamatala ʻo e ngaahi liliu
  • Fōlomu fakakolo
  • Fetuʻutaki mai
  • Tuʻunga ʻo e sēvesi

Fekauʻaki mo e kautaha

  • PaT
  • Blog
  • Ngaahi Tuʻutuʻuni
  • Tauhi Fakapulipuli

© People and Tasks. ʻOku ʻatautolu ʻa e ngaahi totonu kotoa pē.