Waffle Chart

Waffle charts are also called square pie charts and display progress towards the goal. Vitara Waffle chart will work in the following modes: block (Percentage to total), list (Percentage to total), grid (Percentage metric value).

Inputs

Metrics: 1 metric

Attributes: 1 attribute.

Use as Filter Option - Available

The screenshot below showcases all the three modes of waffle chart.

waffle inputs

Markers

We can choose from different types of markers available in the ‘Marker’ tab of the waffle chart. The size of the marker is also customizable.

Threshold

In the business point of view, certain part of the chart needs to be highlighted to draw more attention from the desicion makers. For example, highlight the stores where total sales is greater than a specific value or highlight the top 10 products whose sales is high during last year’s winter. Thresholds are very useful objects in these use cases.

Thresholds will display some conditional formatting in a chart to highlight certain data points depending on predefined criteria.The criteria are attribute or metric qualifications. If a qualification’s expression evaluates to TRUE, the report displays the threshold. We can also include markers in thresholds.

To apply thresholds in vitara charts, hover the cursor on the chart. Vitara chart will display an ‘Edit’ button. When you click on this ‘Edit’ button the properties window will pop out. Select the thresholds tab to open threshold editor. In the window you can add a new threshold or delete any existing threshold or modify the existing threshold.

Note: From 4.9.3 version we can apply thresholds using attributes. The source drop down box in the threshold editor window will list all the attributes and metrics in the chart. we can select an attribute as source and define a threshold condition. The target of the threshold depends on the series of the chart. This means, if the chart series is created using metrics then target drop down box will display the metrics.

threshold add

In the threshold, the editor window apply source, target, threshold condition and the other related information to set a threshold on the chart.

threshold condition

Apply all the inputs and click on ‘Apply’ button.

threshold condition

Unfilled Color

From version 5.0, the Waffle Chart now has an unfilled Color option that changes the waffle chart’s default colour (grey unused part of grid). This feature is enabled via the appearance tab.

waffle

waffle

Background Image

The steps to set a background image for all Vitara charts are explained in backgroundImage.