Mingle Reporting - Macros and MQL
Introduction
This section describes how to create your own charts, graphs and tables on Mingle's Overview tab and other Mingle wiki pages using reporting macros and MQL - the Mingle Query Language.
Mingle supports macros that render charts, tables and dashboard panels. You can customize these macros using MQL to generate tables and charts that are specific to your projects.
Mingle Query Language (MQL) is a query language you can use to extract data from your project for use in reporting macros. MQL is similar to SQL, but with a simplified syntax. In a typical MQL expression you will write SQL-like syntax against your card properties and values.
{{
pie-chart
data: SELECT Feature, SUM(Size) WHERE Type=Story
}}
Embedding the above text into any wiki page in your project will render a pie chart that breaks down the size of feature groups across all cards with a type of story. (Assuming that your project has card properties named Size, Feature, and Story.)
Mingle includes several templates that come with examples of graphs, charts and tables that you can adapt to your own project. Mingle administrators can view templates by clicking the Manage templates link after signing in to Mingle.