Grid
Dernière mise à jour
Cet article vous a-t-il été utile ?
Dernière mise à jour
Cet article vous a-t-il été utile ?
💡 The grid is recommended for displaying specific data and values rather than purely chart visualizations. It is well suited for comparing various values and combining view types. Visual indicators can be added to help interpret the results.
Click on the Grid icon to add a grid to the dashboard.
The settings of the component is then done in this order:
The fields to be displayed are added by drag and drop in the following 2 main areas:
Columns
Sparkline
Data to display in the grid. By default, Biwee will group all the values of a column in a single row if it is possible. For example, if we add a numeric field, it will consider this field as a measure and will total it. But if we want to have the detail of this field, we have to change the type of this column into a dimension.
For example: I want sales for each "product ID" and not the total for "product ID" because it makes no sense.
Then I click on the SUM symbol then on "Dimension" and apply to convert this column.
Sparkline column will only display time data if the sparkline data item is filled in.
Sales analysis by category
The example above shows:
A dimension column: "Category"
A measure column: "Sales Amount"
A delta column: "Sales Amount vs Objective"
A sparkline column: this one has only one value because the sparkline data item is not filled in, "Evolution of sales".
A hyperlink column: "Category"
Field of type date.
Visualization of the sales evolution
In the example above, the sparkline data item has been filled in with the "Sales Date" data field at the "Month-Year" granularity. The "Evolution of sales" column now displays a detail of the sales evolution by month.
The addition of dimension columns increases the granularity of the information. If drill down is enabled, the information of a next dimension in the list box of columns is displayed by clicking on a row of the grid. Otherwise, all dimensions are displayed side by side.
Selection of 2 dimensions columns: "Category" and "Subcategory". The drill down is not activated by default.
The data of the first dimension "Category", are now displayed by default.
Clicking on a row in the grid activates a filter based on the value of the first dimension of that row. You can then access the data of the second dimension displayed according to this filter. Here, having clicked on the line above "Accessories-48.1M", it displays the details of the category according to the dimension "Subcategory".
Adding a Sparkline column adds a Sparkline column to the grid. Multiple columns can be set up with this type. All columns are displayed according to the settings of the data field entered in the Sparkline data item.
Sales and objective evolution by category
Adding a column of one of these types adds an additional column to the grid of the corresponding type. The settings of the column is done according to the type of column selected.
Per category, sales vs objective, store country, store city
You can configure the type of each column by clicking on the icon displayed to the right of the data item.
There are 6 types of columns: dimension, measure, delta, Sparkline, hyperlink and auto.
The latter is the default type for new columns. It will automatically change according to the field chosen in the column.
A dimension column can display data of type "text", "numeric", "date", "boolean" or "object" (such as an image for the latter). It displays all the distinct values of the filed field.
Measures apply aggregation functions on the data, and can be displayed as a value or a bar. The aggregation functions available depend on the type of data dropped in the field.
For numerical data, there are many aggregation functions available, based on mathematical or statistical calculations:
For other types of data, no aggregation functions based on mathematical or statistical calculations are available.
This part allows to choose the display mode of a measurement column, as raw data or as bars.
A delta column aggregates the sum of the actual values, then aggregates the sum of the target values, and finally displays the difference between these two.
This part allows you to define the format of the delta column.
Value type: Allows you to specify the method of calculation of the "real" value to be displayed.
Actual value: value of the "actual" data field.
Absolute variation: difference between "actual" and "target" values.
Percentage change: ratio of values [ ("actual" - "target") / "target" ].
Percentage of target: ratio of values ["actual" / "target" ].
Target value: value of the "target" data field.
Result indication: Allows you to specify the color code used for the delta of the Cards.
Greater is good: The delta is displayed in green if the actual value is greater than the target value. If the target value is higher than the actual value, the delta is displayed in red.
Less is good: The delta is displayed in green if the actual value is below the target value. The delta is displayed in red if the actual value is above the target value.
Warning if greater: The delta is displayed in green if the actual value is higher than the target value. Otherwise, there is no warning coloring.
Warning if less: The delta is displayed in green if the actual value is lower than the target value. Otherwise, there is no warning coloring.
No indication: No color is displayed. The delta is displayed in gray.
💡 It is possible to specify a tolerance threshold with respect to the target. Actual values within this threshold, below or above the target, will not be colored according to the result indication and will be displayed in gray.
Threshold type: Definition of the tolerance threshold as a percentage of the target or as an absolute value.
Threshold value: Specification of the tolerance threshold value, depending on the type chosen.
This part allows to define the format of the displayed values.
Format type: Unit format to be displayed.
Unit: Unit scale.
Precision: Number of digits after the decimal point.
Currency: Currency to display in the case of a monetary unit.
Culture: Country of the currency if selected.
Includ group separator: Split the values by 3 digit dashboard item groups.
A Sparkline column displays a trend line.
It is detailed according to the granularity of the date (year, quarter, month...) entered in the "Argument" data item of the "Sparkline" field.
This part allows you to define the elements to display in the Sparkline.
Show start/end values: If checked, displays the left and right values of the Sparklines of the column.
Sparkline view type: Sparkline display mode.
Line: Displays the Sparkline as a curve.
Area: Displays the Sparkline as a curve with the lower zone colored
Bar: Shows the Sparkline as a histogram. Under this representation, the minimum value is not highlighted.
Win/Loss: Displays the Sparkline as a bar chart with the maximum and minimum values highlighted.
Highlight min/max points: If checked, the minimum value of the Sparkline will be in red, the maximum in green. Otherwise, the Sparkline will not have a color for highlighting the minimum and maximum values.
Highlight start/end points: If checked, the values of the start and end points of the Sparkline, if represented as a line or an area, will be visible. Otherwise they will be hidden.
A hyperlink column allows you to assign hyperlinks to the data in the column. These can be generated from a data field containing links, or from the settings window Setting up a hypertext link column.
URI Pattern: A hypertext link can be generated automatically for each element of the column by this field if it refers to a common root. This is indicated in the form root/{0}
Example: www.wenove.fr/biwee, www.weenove.fr.fr/weenove ; in this case, the common root is www.weenove.fr/ and the elements "biwee" and "weenove".
Conditional coloring can be applied to grid cells using format rules. The format rules available depend on the type of data field they apply to, as well as the type of column.
💡Conditional coloring cannot be applied to Delta or Sparkline columns.
Examples of format rules:
Uniform formatting Top 3
Formatting by ranges icons
Adding bar color ranges
To do this:
Either right click on the field that will be used to define the conditional format rule, click on "add format rule".
Or right click on the chart component, and click on "Edit rules".
The grid can be customized using the interaction and layout tool. Click on the cogwheel visible at the top right of the component to access the tool.
It features 3 tabs:
Interactions
Layout
Filters
This tab allows you to configure the interactions of the grid of this component with the other components of the dashboard.
This tab is used to customize the display of the grid of this component.
Common
This part allows you to configure the title of the component and the columns.
Show title: Hide or show the title. It is displayed by default.
Modify title: Rename the component and columns
Style
This part allows you to change the appearance of the grid.
Horizontal Lines: Displays the horizontal grid lines in the grid.
Vertical Lines: Displays the vertical grid lines in the grid.
Banded Rows: Color every other line.
Layout
This part allows you to format the display of the grid data
Merge Cells: If enabled, merges adjacent cells with identical data.
Column Headers: If disabled, hides the column headers. This setting is enabled by default.
Word Wrap: If the text in a grid cell exceeds the cell width, automatically returns the text to the line.
Column width mode
This part allows you to adjust the width of the grid columns.
AutoFit to Contents: Adjusts the width of the columns so that the whole text is displayed in each column. If all the columns are too wide, a horizontal scroll bar is displayed.
AutoFit to Grid: Adjusts the width of the columns so that all the columns are displayed in the grid. The content of the columns may not be displayed in full if they are too long or if there are too many columns.
Manual: The width of the columns is not changed. The user can do it manually.
This tab allows you to add a simple or combined filter on the data displayed in the grids of this component and has no influence on the other dashboard components.
For more details, see the following pages.
For more details of conditonnal formatting see the .
.
For more details, see the help topic dedicated to .
