Configuring Display Unit Mapping
Display Unit Mapping-Formatter
To display
chart labels/tooltip values/axis labels and such applicable values wherein the
display unit is displayed, the formatter -Display Unit Mapping is available in
the page level Format pane options. (To Navigate: Click Format >> Click
Display Unit Mapping). Refer Number
Format for setting Display Units and respective other formatters.
These
mapped values are applicable on all the charts configured on that page.
Separate page- wise configurations are needed for display unit mapping. The mapped
values against respective Display Unit are applicable for all charts wherever
these Display Units are referenced to.
Figure 1: Display Unit Mapping Formatter Options
The display
unit options- Thousand, Lakhs, Millions, Crores, Billions, Trillions are
display with their default mapped values- K, L, M, C, B, T.
The mapped
values are available in Input Box which is editable and hence these values can be
set as per requirements.
Customize Display Unit Mapping
To use
custom values for the Display Units, the required value is mapped against the display
unit. For example, below are the chart visuals displayed for the default mapped
values, for same charts available on Page 1 and Page 2 of dashboard as in below
Figure 2: Default Display Unit Mapping and
Chart Values:
Figure 2: Default Display
Unit Mapping and Chart Values
The data
labels and axis labels are displayed with currently mapped default values of Billions
and Crores with B and C respectively. For both Page 1 and Page 2 the display
units displayed are same.
In Pie
chart the data labels are displayed with display unit set as Crores and hence
values are displayed like- 23.85C, 21.67C, etc.
Similarly,
for line chart the data labels, set as by default are displayed with Billions
and Crores with values -1.36B, 18.09C, etc. Same is applied for axis labels
with values showing as 50C, 1B, etc.
Mapping Display Units
To map the
Display Units, follow below steps:
1. Navigate to the Dashboard Page where
display units need to be mapped.
2. Click Format
3. Click Display Unit Mapping formatter
4. Enter the mapped values against the
respective display units
5. Observe on the charts
For Page 1,
in Display Unit Mapping formatter, the mapped value against Billions is set as
Blank (No value/empty value) and for Crores it is set as ‘Cr’ as below:
Figure 3: Display Unit
Mapping with required mapping values
On charts the changes get reflected immediately
as -Display Unit with Billions and Crores displayed previously as B and C
respectively are displayed as ‘Empty Unit/No Unit’ and ‘Cr’ respectively.
The charts display for Page 1 after mapping
Display Units as below:
Figure 4: Changes on Chart
as per Display Unit Mapping (Page 1)
For Page 2,
in Display Unit Mapping formatter, the mapped value against Billions is set as ‘Bn
₹’ and for Crores it is set as ‘ Cr’
as below:
Figure 5: Changes on Chart
as per Display Unit Mapping (Page 2)
As can be seen from above Figure, the mapped
changes for display units are reflected on the charts.
For tooltip also, same changes are applicable
and the tooltip on hover displays as below:
Figure 6: Changes on Tooltip as per Display Unit Mapping (Page
2 Chart)
|
|
Notes: |
· The changes are page specific and the display units as mapped in Display Unit Mapping formatter are applicable for all charts available on the page. · Display Unit Mapping changes are applicable on all modes of dashboard. · Display Unit Mapping changes are applicable with other formatters including – Number Style Formatting (Set Display Unit, Set Decimal Places, Prefix, Suffix). · Display Unit Mapping is applicable for all Number Style configurations- Data Labels, Tooltip, Axis Labels, Total/SubTotal/Grand Totals. · The import/export, save as carry forward this configuration with the dashboard. · The chart set with Display Unit Mapping and in at a glance view shows default mapped values of display units irrespective of the configuration done at page level. |
Related Articles
Mapping Variables
In Rubiscape, you can create, train, test, and publish models for further use in workbooks or workflows. For this, we configure a model using a dataset. When you publish a trained model, it appears in the model section under Model Studio or Machine ...Mapping Variables
In Rubiscape, you can create, train, test, and publish models for further use in workbooks or workflows. For this, we configure a model using a dataset. When you publish a trained model, it appears in the model section under Model Studio or Machine ...Understanding Project Display Pane
The project display pane displays the projects created in the selected workspace. You can perform the list of actions as mentioned below. Visit the respective section for more information. Import Project Edit Project Export Project Delete Project To ...Decimal Place Formatter
Formatting a Table You can format the tables that appear in various charts. Tables can be plotted standalone like Table and Cross Table, or they accompany other charts (like Sparkline Chart in which they accompany a Line, Area, or Column Chart). The ...Axis Label (Y-axis)
Axis Label is the parameter that represents the variable plotted on the Y-axis. The table given below describes different fields present on Axis Label formatting in Y-axis. Field Description Remark Text It allows you to modify the parameters of the ...