PPaT Wiki
Ngā tuhinga whakamāramaPathwayHuinga kōreroPae rangitakiWhakapā mai
Week streakFOUNDATION0 badges
Reo: Te reo Māori
  • English
  • Nederlands
  • Français
  • Deutsch
  • Lea faka-Tonga
  • Te reo Māori
  • မြန်မာ (Burmese)
Pātai atu ki te hapori

Your PaT Pathway

0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  • Hanganga Kamupene: ngā kōwae mō tētahi pae, whenua rānei
  • Hanganga Kamupene: te tāpiri kaiwhakamahi hou
  • Hanganga o te Kamupene: ngā tari, ngā taitara tūranga me ngā tūranga mahi
  • Me pēhea te waihanga kaupapa mō te tomokanga whakangungu PaT Lite
  • Me pēhea te whakarite i tō Mahere SD
  • Me pēhea te whakatika i tētahi whakairinga kei te Papa Pānui
  • Ngā Hononga: te hono i PaT ki Microsoft 365
  • Ngā Ine LMS – Ki te kore e taea e koe te ine, kāore e taea e koe te whakahaere
  • Ngā Puka - Te Whakaurunga API
  • Ngā Urupare LMS: ngā whakatauranga me ngā kōrero a ngā ākonga
  • Ngohe Pūnaha: ngā pikinga take, ngā takiuru, ngā īmēra me ētahi atu
  • PaT He Tirohanga Whānui ki te Tātauira Wāhanga Pakihi
  • SD Ngā Rerengamahi - Ngā Tautuhinga Rerengamahi
  • SD Ngā Rerengamahi - Tuku Maha
  • Te āta whakarite i ngā arotake anō me ngā whakamōhiotanga piki taumata
  • Te Hanganga o te Kamupene: ngā kamupene kiritaki
  • Te Hanganga o te Kamupene: ngā kāwai tukanga
  • Te tūtohi hanganga whakahaere
  • Whakahaere kaiwhakamahi
  • Whirihoranga Pūnaha: ngā tautuhinga kamupene
  • Aroturuki i te whai wāhi
  • Īmēra ki BFF
  • Kōrerorero ki SD
  • Mai i te īmēra ki te kōrerorero, ā, hoki ki te īmēra – mō ngā tāngata kāore e whakamahi ana i PaT
  • Mai i te kōrerorero ki te īmēra, ā, hoki anō ki te kōrerorero
  • Mai i te kōrerorero ki te mahi, ki te kaupapa
  • Me pēhea PaT e whakahaere ai i ngā kaiwhakamahi hohe-kore
  • Me pēhea te wetewete i tētahi kōwae ako mō tētahi kaimahi
  • Ngā Āhuatanga Kōrerorero Matapihi-ake
  • Ngā Āpitihanga C2E
  • Ngā Arotake Māramatanga
  • Ngā arotake taunaki: te whakaoti i tētahi
  • Ngā Ata Tohu Mōhiohio
  • Ngā Hīkoi Haumaru
  • Ngā Kōrerorero Kua Tāmaua
  • Ngā kōrerorero rōraina
  • Ngā Mahi a te Kaipupuri SD
  • Ngā mahi auau: te waihanga me te whakatika
  • Ngā rūma ataata: te hono mai a ngā manuhiri me te tono kia tuhi
  • Ngā tauira hauora me te haumaru
  • Ngā Tūmahi Maha
  • Ngā whakamahinga rerekē o ngā puka
  • Nuku i ngā Pane Wāhanga
  • PaT AI
  • Pātū Puka
  • SD Ngā Whakautu Puka: te kimi me te kaweake i ngā whakautu puka
  • Tāpirihia he Atahanga hei Ata o te Pane Wāhanga
  • Te āhua o ngā kōrerorero a SD me ngā Mema o SD me ngā Kaiwhakamahi o Waho
  • Te Hanganga o te LMS
  • Te Pono ki ngā Mahi: he aha tēnei, ā, he aha i heke ai
  • Te tāpiri raraunga ora ki tētahi SD (ngā kauwhata me ngā ripakaute)
  • Te tautapa i tētahi SD ki tētahi mātua hou
  • Te whakahaere hui mā ngā SDs
  • Te whakamahi i ngā SDs hei taupānga pūrongo, hei taupānga hoki mō ngā meneti hui
  • Te whakarōpū me te tiki anō i ngā SDs
  • Te Whakatūunga i ngā SDs me te Whakahōu i ngā Atahanga
  • Te whakauru i ngā SDs ki roto i ngā SDs
  • Tiritiria, tuhia hoki tō mata
  • Tirohanga pakitara Tūmahi SD
  • Tonoa ngā Tāngata kia Hono Mai
  • Whakamahara kōrerorero
  • Whakangungu motuhake mā te kiritaki: te āhua o te whakahaere
  • Whakarōpūtanga Huānga o SD
  • Arokite, tikiake, ka tohaina ngā kōnae
  • He raruraru ki te manatoko-ā-taumata-rua o Outlook
  • Hopukina, Whakahaerehia hoki ngā aituā
  • Hurihia te kōrerorero hei tūmahi
  • Hurihia tētahi Tuhipoka hei Tūmahi
  • Kei Waho i te Tari: te whakakā, me te maramataka kei tō Pātū Tūmahi
  • Kōkuhutia ngā hononga
  • Kupu Whakataki mō te PaT mā te Tauhou – Ngā Kōrerorero me ngā SDs
  • Me pēhea te whakamahi i te tomokanga whakangungu PaT Lite
  • Me pēhea te whakarerekē i te rahi o tō pūtirotiro kia pai ai te tirohanga ki PaT
  • Me pēhea te whakauru i a Outlook ki tō PaT
  • Ngā āhuatanga whaihua o te whārangi matua o SD
  • Ngā Ākonga o te Kōwae – Waea Pūkoro
  • Ngā Kōrerorero ā-Rōpū
  • Ngā Kōwae Ako - Papamahi
  • Ngā Pane Wāhanga
  • Ngā Pānui Mahi
  • Ngā pānui mō ngā whakahou: he kōrerorero nā Sys Bot ina rerekē ngā pitopito tuku a PaT
  • Ngā tikanga haumaru mō ngā kaiwhakamahi maha i runga i te pūrere
  • Ngā Toronga Chrome Hirahira
  • Ngā tuhipoka
  • Ngā Tuhipoka Tere
  • Ngā waea ataata i te taupānga pūkoro
  • PaT He tirohanga whānui ki te Kōrerorero
  • PaT te āhua o te ratonga: te whārangi āhua, ngā matohi āhua me ngā pānui āhua
  • PaT Wiki: te rapu ara
  • PaT Wiki: te rapu, te whakautu a te AI me te tuku whakatauranga
  • Pātaka Tuhinga: ngā hononga tiritahi, ō kōpaki me ngā mea tino pai ki a koe
  • Pātū Tūmahi
  • Pūnaha Whakahaere Tūmahi
  • Rapu Whānui
  • SD Ngā Huānga
  • SD Tirohanga whānui
  • Taku Kōtaha
  • Tāpiri mema me te whakarite whakaaetanga
  • Taupānga Pūkoro PaT – Tirohanga Whānui
  • Te ahunga whakamua ā-rama waka
  • Te ata hono i runga i tō papamahi PaT
  • Te Hopu me te Whakahaere i ngā Mōrearea
  • Te pānui i tētahi SD ki tētahi atu reo
  • Te Pātū Kōrerorero
  • Te takiuru ki PaT me te tautuhi anō i tō kupuhipa
  • Te takiuru mā te MFA: te taahiraa tuarua
  • Te tiki āwhina: te Papamahi Āwhina PaT
  • Te Whakahaere Tūmahi
  • Te Whakawhiti Kōrero ā-Pūtaketanga
  • Tiri Urupare
  • Tukuatu ngā āpitihanga kōnae
  • Waihangaia he Tūmahi
  • Waihangatia he SD hou
  • Whakaputa i tētahi Tuku ki te Papa Pānui
  • Whakarāpopototanga AI: he whakarāpopototanga tere o tētahi SD
  • Wiki a te kamupene: te rapu i ngā kōwae ake a tō kamupene
  • Aratau Whakamātau Puka
  • Calculated fields and calculated columns
  • Charts: options for lines, bars, axes and single values
  • Data sources: stage filters, dynamic dates and page values
  • Form Builder: layout at each screen size
  • Form Builder: tools and shortcuts
  • 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
  • Hangaia he pūnaha pūrongo
  • Kaihanga puka: ngā momo āpure
  • Kaiwhakahaere Kōwae: te kimi me te whakahaere kōwae
  • Kaiwhakahaere Playbook: kua rite tō oma ātārangi mō te arotake
  • Kaiwhakahaere Playbook: ngā tīkiti kei muri i ia kāwai Kounga me te Utu
  • Kaiwhakahaere Tohu Whakamutunga: te kimi tohu whakamutunga me te hanga i tāu ake UDF
  • Kaiwhakatika Playbook: te tāpiri i tētahi hipanga rapu i te pae tomokanga
  • Kaiwhakatika pukapuka mahi: te tāpiri i tētahi hipanga hei whakakore i tētahi ota
  • Me pēhea te hanga arotake taunakitanga mō ngā kōwae ako
  • Me pēhea te tāpiri i tētahi SD ki te LMS
  • Me pēhea te tuku i ngā huānga puka ki tētahi SD
  • Me pēhea te waihanga aromatawai mārama mō ngā kōwae ako
  • Me pēhea te waihanga kōwae i te Kaiwhakaputa Kōwae
  • Me pēhea te waihanga patapātai kōwae
  • Me pēhea te whakahohe i ngā tauira puka kia whakamahia e te katoa
  • Me pēhea te whakakā a ngā kaiwhakahaere i te OOF mō ā rātou kaimahi
  • Me pēhea te whakamahi i te PAR SD
  • Ngā āpure e hiahiatia ana, te whakamana me ngā ipu
  • Ngā āpure puka: ngā uara taunoa, te aratau pānui-anake me ētahi atu tautuhinga
  • Ngā Āwhina Tātauira SD
  • Ngā Kōwhiringa Ihirangi mō te Kaiwhakaputa Kōwae
  • Ngā pātene puka, ngā PDF me ngā mea ka tupu i muri i te tukunga
  • Ngā Puka – Tango Raraunga (te kaihanga puka AI)
  • Ngā Puka SD
  • Ngā Puka Tōtika
  • Ngā Tautuhinga Haumarutanga SD
  • PaT SD He tirohanga whānui ki ngā tauira
  • PaT SD Tirohanga whānui ki te Mahere
  • PaT SD Whakaaturanga Mahere
  • Pūnaha Rautaki
  • Pūrongo Hauora me te Haumaru (H&S) Wā Tūturu
  • Rich text, file uploads and speech to text
  • SD Papatohu: te hanga papatohu
  • Stacked views, flip cards, tabs and stages
  • Te Aratohu AI: te tirotiro i ētahi atu tīkiti he ōrite te tau
  • Te Whakahaere Kōrerorero – He Tohutohu Mātauranga
  • Te Whakahaere Matatau i te Tātauira Rautaki Pakihi
  • Te whakamahi i ngā SDs hei Tuhinga LMS
  • Te whakamahi i te Chat to SD kia neke atu i te kaiwhakahaere pai ki te kaiwhakahaere tino pai
  • Te Whakarite Whakamōhiotanga Whakaoti Kōwae
  • Te whakawhāiti i te tere
  • Te whirihora i tētahi UDF: ngā tātari, te whakarōpū me ngā taipitopito pito-mutunga
  • Te whirihora i tētahi UDF: ngā tīwae me ngā tīwae tātai
  • Whakahōputu Herekore
  • Whakakake aunoa
  • Whakangungu mō ia kiritaki ake: te whakarite
  • PaT Lite: Ngā āhuatanga matua o PaT me mārama koe
  • He aha a PaT, ā, he aha te take nui
  • PaT Lite: Kōrerorero hei Tūmahi
  • PaT Lite: He kupu whakataki ki ngā Strategy Documents
  • PaT Lite: Te Whakaaro Matua – Ngā Paerewa me te Whakatinanatanga Rautaki
  • PaT Lite: He taputapu atamai e whakaaro tahi ana me koe
  • PaT Lite: Ko te Ahurea te Anamata o te Pakihi
  • Haumarutanga
  • Ngā whakaurunga
0/46
Foundation
0/43
Practitioner
0/37
Advanced
0/20
Super User
  1. Tuhinga āwhina
  2. Arā Atu Anō
  3. Charts: options for lines, bars, axes and single values

Kāore anō tēnei whārangi kia whakamāoritia, nō reira kei te whakaaturia ki te reo Pākehā.

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

E tirohia ana tō takiuru PaT…

How To

Kei tēnei whārangi
  • 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…

O muaCalculated fields and calculated columnsO muri Data sources: stage filters, dynamic dates and page values

Kei tēnei whārangi

  • 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

He tuhinga, he pātengi raraunga mātauranga, he tautoko ā-hapori hoki mō People and Tasks.

Tuhinga

  • Te tīmatanga
  • Ngā ariā matua
  • Ngā tuituitanga
  • Tohutoro API Ākuanei

Tautoko

  • Pātengi raraunga mātauranga
  • Ngā pitopito kōrero tuku
  • Huinga ā-hapori
  • Whakapā mai
  • Tūnga ratonga

Kamupene

  • PaT
  • Tuhinga rangitaki
  • Ngā Ture
  • Tūmataitinga

© People and Tasks. Kua rāhuitia ngā motika katoa.