We often see businesses filter unwanted data rows from BI reports. Changing trends in data analysis and inclination for responsive tables elevated the need for dynamic columns among business analysts. Dynamic columns change the number of columns, by eliminating or simply hiding columns at runtime from the table visualization while keeping only the relevant ones in the analysis report.
You can make columns dynamic using expressions or parameters in a Wyn Report. But changing the number of columns at runtime may disturb the report layout.
Wyn Enterprise 5.0 Report Designer adds an "Auto Width" property to the Table columns making them responsive and be able to fit nicely within the designed Table or Page width.
Here, we'll see how the property can be used for a simple sales report.
Display Product Sales Data Using a Table
Suppose you need to present product sales data using a Table in the report. The report must show KPIs such as Sales Quantity, Sales Amount, Profit Margin, YoY growth, etc. along with other information such as Product Name, Sales Region, etc.
Each column in the Table is a different KPI having its own calculated measure.
The report may appear in the designer as shown below:
Let's say the report is intended for multiple users in the organization. And each set of users is interested in one or the other KPI.
For example, higher management may be interested to see the profit margins and YoY return.
Such a report is expected to appear in preview as shown below:
Mid-level managers may be interested to see the actual sales information such as COGS, sales amount, etc.
For them, the report is expected to preview as shown below:
Such dynamism can be achieved using parameters and expressions on the table column's visibility property. However, you may observe that table width varies for different users due to hidden columns at runtime.
In absence of the new Auto Width property, you may need to create one table for each set of users, select the desired columns, and set width for shown columns. Then use parameters and expressions to determine the visibility of the Table Data region for a particular set of users.
The new Auto width property ensures that a single table fits the page width for a variable number of columns. This property allows the remaining columns to adjust and occupy the empty space left by the hidden columns.
It offers two options:
- None: This is the default value and does not allow columns to grow at runtime.
- Proportional: Select this option to change a column's width relative to table width and fill the whole table rather than shifting columns to adjust the space left by the hidden column in the table.
You may select all or a few columns to grow and occupy the space and maintain the table width. The choice for the columns depends entirely on your business need. It could be the static columns or the dynamic ones.
To use the property you just need to select the column that you want to grow.
When you select the column, you will find the new "Auto Width" property under the Layout section as shown below:
Set the Auto Width property of the selected column to "Proportional" and that's it.
When you preview such report, table width appears uniform for any number of hidden columns as shown below:
Image showing columns as may be needed by regional managers
Image showing columns as may be needed by higher management.
Better Data Insights = Better Decisions
Let us show you how Wyn Enterprise can provide greater insights into your data.
Learn how to make data insights more attainable, actionable, and valuable. ↓
Paarisha Rana