Form Pivot Plugin

Basic analysis of values for a form used by the topics in a Web.

FormPivotPlugin Global Settings

Plugin settings are stored as preferences variables. To reference a plugin setting write %_%, for example, Link =ExternalSite:Page text to external sites based on aliases defined in a rules topic=

• One line description, shown in the TextFormattingRules topic:
  • Set SHORTDESCRIPTION = Statistics of values in TWikiForms

• Set DEBUG to 1 to get debug messages in data/debug.txt. Default: 0
  • Set DEBUG = 0

Syntax rules

%FORMPIVOT{form="..." [fields="..."] [type="grid|count"]}%

If fields not specified, all fields in the form are used.

If type is "count":

• For each field, gives a break down of occurance of values in sortable tables.

If type is "grid":

• There should be two fields, each square in the grid produced will be the count of those topics containing the two values e.g. Bug and High Priority

Known Issues

This is a fairly simple initial implementation and probably doesn't yet deserve the designiation of pivot.

Plugin Installation Instructions

• Download the ZIP file from the Plugin web (see below)
• Unzip FormPivotPlugin.zip in your twiki installation directory. Content:

• Test if the plugin is correctly installed:
  • Extract test topics from attachment formpivot-example.zip
  • See Sandbox.TestFormPivot? for the two types of pivot (assuming you extracting to the Test Web).

Plugin Info

Related Topics: TWikiPreferences, TWikiPlugins

-- TWiki:Main.JohnTalintyre - 15 Apr 2002

• : Simple example of using FormPivotPlugin