Period over Period support used to compare measure values for one period of time against the results from a previous or subsequent period of time. PoP widget used to choose two different time periods at a time.
Period Over Period
from the toolbox at left into the design canvas and resize it to your required size.Data Source
button in the configuration panel.CREATE NEW
button to launch a new connection from the connection type panel.Microsoft Excel
Connection type is selected for demonstration) of the listed connection type button shown.NEW DATA SOURCE
configuration panel, fill the connection type and related details. Click the Connect
button.Save
button.Properties
button in the configuration panel, property pane opens. Now, switch to the ASSIGN DATA
tab.Dimensions
into the Columns
section.On binding field to PoP widget, default date ranges calculated based on the bounded field and set as a selected filter.
By default, the PoP widget renders with some default filter value and which can not be discarded. We allow only to reset the filters to default if we made changes. The default date range is calculated based on the days pan between min and max dates of the bounded field.
You can select the Relative/Custom date ranges using the Relative Combobox
or Calendars
. We can select any date ranges irrespective of the bounded field. That field is used to calculate the default date ranges and filtering purposes.
The following relative items are displayed under the Date Range:
The following relative items are displayed under the Compare To:
In both relative items Combobox, the Custom
will be selected automatically if you choose custom range from calendar or enter custom range manually using the Combobox
input section.
IMPORTANT:
Compare To
relative items value calculated dynamically based on the date range selection from Date Range
. You can see how it calculated for each relative item:
Previous Period
:It is calculated based on the number of days between the selected dates(start and end) of Date Range
. For example, consider the Date Range
selected value as 1-Jan-2019 to 10-Jan-2019
. Here, the number of days between the selected dates is 10. So, the Previous Period
value for the selected range is 22-Dec-2018 to 31-Dec-2018
.
Previous Year
:It is a previous year date of the selected date values from the Date Range
. For example, consider the Date Range
selected value as 1-Jan-2019 to 10-Jan-2019
. Here, the year of start and end date value is 2019. So, the Previous Year
value for the selected range is 1-Jan-2018 to 10-Jan-2018
.
Comparison types of charts like Bar
, Column
, Stacked Bar
, Stacked Column
, 100% Stacked Bar
, and 100% Stacked Column
. Distribution types of charts Line
, Spline
, Spline Area
, Area
, Stacked Area
, and 100% Stacked Area
. Proportional types of charts Pie
, Doughnut
, Pyramid
, and Funnel
and Grid
can be slave widgets for Period Over Period
. KPI Card
can be slave for Period Over Period
widget when Actual Value
only configured in card.
Consider you configured Column chart
, Grid
, KPICard
. You can change the Column Chart
, Grid
, KPICard
as a slave for the Period Over Period
widget by using the filter interaction window as shown below.
Once you configured, the Chart
color palette will be changed using the PoP
selection colors(blue and green). The red information icon denotes that the chart virtual column value will not get a display in the design mode.
Similarly, you can see an option to customize legend and palette for the virtual column which will be displayed in the Designer Preview/View Mode.
During interaction from the PoP widget, the chart will display two series. One having values filtered from Date Range
and another one contains filtered values from Compare To
.
The Grid
color palette will be changed using the PoP
selection colors(blue and green). The red information icon denotes that the chart virtual column value will not get a display in the design mode.
You can see a category to customize POP settings and palette for the grid which will be displayed in the Designer Preview/View Mode.
You can customize each column that is to be displayed in the Designer Preview/View Mode using the Customize
option. If you click on the Customize
option, the following window shows:
Please find the response of different type of charts as slave of PoP widgets.
Bar Chart
Line Chart
Area Chart
Spline Chart
Spline Area Chart
Stacked column Chart
Percent Stacked bar chart
Consider you have configured the Proportional Chart
as a slave for the Period Over Period
widget. Like the column, the line chart’s color palette will not be changed. The Red information icon denotes that the comparison of period visualization will not be shown in the design mode.
KPI card
The KPI Card
will be shown with the following information. You can visualize its value in Designer Preview/View Mode
During interaction from the PoP widget, the KPI Card will display two series. One has values filtered from Date Range
which displays as Actual Value
while another one contains filtered values from Compare To
which displays as Target Value
.
Proportion chart
During the interaction of Pop Widget, the proportional chart will display two series. One shows values filtered from Date Range
another one contains filtered values from Compare To
.
Grid
During interaction with the PoP widget, the grid will display two series for each column which are a slave to the POP. One has values filtered from the Date Range
while another one contains filtered values from Compare To
.
You can format the Period Over Period for better illustration of the view that you require, through the settings available in Properties
tab.
This option allows you to change the title for the Period Over Period.
Allows you to provide subtitle for Period Over Period.
Allows you to provide a description about the Period Over Period.
This allows you to define this PoP as a master widget such that its filter action can be made to listen by other widgets in the dashboard.
This allows you to handle the alignment of widget title to either left, center, or right
.
This allows you to apply the text color
to the widget title.
On enabling Auto Font Size, the font size of the title will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Title Auto Font Size is disabled. Value can be between 10 and 44.
On enabling Auto Font Size , the font size of the subtitle will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Subtitle Auto Font Size is disabled. Value can be between 10 and 32.
This allows you to toggle the visibility of the border
surrounding the widget.
This allows you to apply the specified radius
to the widget corners if the Show Border is enabled. Value can be between 0 and 10.
This allows you to set the background color to the period over period widget.
This property allows you to specify the transparency for the background color
.
This allows you to toggle the visibility of the shadow
surrounding the widget.
This allows you to enable or disable the widget title
of the period over period widget.
This allows you to enable or disable comment
for the dashboard widget. For more details, refer to this link.