Home Knowledge Base Visualizing Your Data Grid Widget - Flip Rows to Columns

Visualizing Your Data

Visualizing Your Data

FAQ - Visualizing Your Data

Overview
We have added an enhancement to the grid widget that will allow you to flip rows to columns.

Here's what it looks like


How do I enable "Flip rows to columns" ?
Go to a grid widget and click on “Edit”.  Open up the Widget Draw Options and click the “Flip rows to columns” checkbox.  You will notice that the rows are now flipped to columns.


Examples

Before
This is an example of how a grid widget is normally displayed, where the group by is displayed as rows and the metrics are displayed as columns.


After
If the “Flip rows to columns” is enabled for the widget above, then the widget would display like this, where the first group by metric is displayed as columns and the metrics are displayed as rows:

Pro Tips

  • With “Flip rows to columns’, the first group by metric is displayed as columns.
  • With “Flip rows to columns’, the ‘Number of records to display’ fields will control the number of columns (instead of number of rows) to display at the dashboard level.