Magpi Support

Magpi's reporting and data visualization system allows Magpi Pro and Enterprise users to create beautiful customizable reports without programming, much as you create Magpi forms.  You can read about Magpi Reports here, or watch an intro video here.

Just as you can create a Magpi form by making a list of questions, in Magpi Reports you make a list of "report elements".  We will be adding more report elements over time.  Here is the current "Insert Form Element" menu:

Text – a text element can be used to enter plain text, or else to enter HTML code (if the user knows any HTML).  Although HTML is optional, the benefit is that it can be used to add web links, videos, external images (which can also be added using the "External" element) to modify the size/color/font of the text, etc.

External – an external element is used to add an external image. 

Cross Tab (multiple choice questions: radio button, dropdown , checkbox) - a cross tab (also called a "cross tabulation" or "contingency table"), is a table that shows the frequencies of two variables at once.  Here's an example:

Crosstabs can be shown as a table, or a stacked or grouped bar or column chart.

Frequency (multiple choice questions: radio button, dropdown , checkbox) – a frequency element shows the frequency of responses to a single variable (as opposed to the cross tab, which shows two variables).  Frequencies can be shown as a table, or as a variety of graph types. Here are two examples:

Frequency with Drilldown - for Frequency report elements, which display the responses to a single multiple choice question, it is possible to include a “drilldown” question.  This allows the report viewer to click on a report chart segment and “drill down” to a second variable.

For example, in the frequency donut chart above you might specify “Gender” as the drilldown variable when creating the report element. That would allow you to click on a segment – for example, the segment representing a response of "London" – and then see a second graph showing you the gender responses for those who chose London.

You can see a live example of a drilldown chart in this sample report.  Just view the donut chart titled "Agreement by Respondent City" and try clicking on any of the chart segments.

Note, for any frequency-with-drilldown element, you'll need to pick a "response question", which will appear when first viewing the element, and a "drilldown question", which will appear when clicking on the element.  The response question can be a radio button, or dropdown question, but not a checkbox.

Map Responses (single-select multiple choice "radio button" or "dropdown" questions) – Map Responses takes into account the response to a selected multiple choice question in the data set, and displays the data as either color coded pins on a map, or a heatmap.

Note: if you use Map Responses for a checkbox question (in which the respondent can pick more than one answer), it is not possible to graph on a single map.  For example, if a respondent chose "apples" and "oranges" as some of their favorite fruits, and the map is going to show apples as one color pin, and oranges as a different color, it cannot have a pin that is both colors.  So, for checkbox questions mapped as Map Responses, Magpi treats each option (apples, oranges, etc) as a Yes/No question, and will produce a map for each option, showing the Yes/No responses to that option: one map for apples, one for oranges, etc.

Records by Time – Records by Time displays a column graph with time on the X axis, and the number of data records collected on the Y axis.  Here is an example: