Plot
A Plot draws a chart from either M-Files objects or a SQL data source you have configured. It supports several traces on one chart, a secondary Y axis, and the usual chart types.
CtrlPortals has two charting components, and Plot is the one to use. Plot view, its predecessor, is deprecated: charts already built with it keep working, but new ones belong here.
A visual that reads M-Files queries the vault itself, not a copy, and keeps the result for its Cache lifetime (minutes), 30 by default. The refresh control on a chart clears that cache; an indicator has no refresh control, so its figure can be as old as the cache lifetime. A broad query is still a slow plot, so scope it with filters. A visual that reads SQL is not cached and reads its database each time the plot loads, so it is only as current as that database.
Visual Type still offers Map, but map visuals are no longer rendered: since 3.26.9.28 the plotting library ships without its map support, and a map visual draws nothing. Use bar, pie, line, scatter or indicator.
A user can click a bar or slice to open the rows behind it in a table. That table offers cell editing only when Drill-down: allow editing is on.
Plot Configuration
Configuration for the plot that will be displayed.
Title
The title that is displayed above the plot.
Drill-down: allow editing
Lets users edit cells in the table that opens when a point of a visual is clicked, like the List View's "Allow editing". Off by default: a drill-down is there to look at the numbers behind a point, not to change them. M-Files permissions apply either way. SQL data is never editable. Default: no.
Visuals
The list of visuals that are displayed in the plot. For instance, this could be a single bar chart, multiple bar charts, or a combination of bar and line charts.
Generated from CtrlPortals 3.26.9.53.
Related
Section titled “Related”- Configuration overview
- About CtrlPortals — how modules sit inside segments