Modules

Pivot, Graph, and Gantt views in Studio

Turn on Pivot, Graph, and Gantt views for a custom module in Studio, and read the notes each view shows when it is drawn from part of the list.

A custom module built in Studio lists its records as a Table, a Grid, a Board, or a Calendar. It can also offer three more views: Pivot, Graph, and Gantt. They appear in the View switch on the module's list once you turn them on. Each one only displays records. It draws what the list already shows, and the list's search and filters apply to it.

In Studio, open the module's list and use the view settings. Each view has Turn the view on, and then Update the view and Turn off. Like every Studio change, it is reviewed and applied before your team sees it. The Studio preview does not draw these views, so apply the change, then open the module to see them.

Pivot

A pivot counts, adds up, or averages the records by one field, and by another across the top, with totals.

  • Rows is the field the records are grouped by.
  • Columns is a second field across the top, or One column of figures.
  • Measure is Number of records, Total of a field, or Average of a field. For a total or an average, choose a number or money field.

When there are many columns, the smaller ones are folded into Other, and the page says so. Totals are not shown when the figures cover only part of the list.

Graph

A graph draws a bar, line, or pie chart of the records by one field, in ink only with no color.

  • Chart is Bar, Line, or Pie.
  • Group by is the field the records are grouped by.
  • Measure works as it does in a pivot.

Show as a table lists the same figures, and Show the chart returns to the drawing. Smaller groups are folded into Other. In a pie, a group with nothing to show is left out, and the page says how many.

Gantt

A Gantt draws a bar for each record from its start date to its end date, with a line for today.

  • Start date and End date choose the two date fields.
  • Group by groups the bars, or choose No groups.

Bars are read only. A date changes on the record's own page, where its rules run. A record with no start date, no end date, or an end before its start is not drawn, and the page says how many records were left out. If no record has both dates, the page says so instead of showing an empty chart.

When a view is drawn from part of the list

A large list is not always read in full. A note under the view tells you when that is so, for example that the figures come from the first records of a larger set, or that a Gantt draws the records that start inside a window of dates. Search or filter to look at a narrower set.

Troubleshooting

A view is missing from the View switch

It shows once it has been turned on and the change has been applied.

A pivot has no totals

The figures cover only part of the list. Search or filter to narrow it.