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.
Drag and drop the Period Over Period
from toolbox at left into design canvas and resize it to your required size.
Click Data Source
button in configuration panel.
Click CREATE NEW
button to launch a new connection from connection type panel.
In the connection type panel, click any one (Here Microsoft SQL
Connection type is selected for demonstration) of the listed connection type button shown.
In the NEW DATA SOURCE
configuration panel, fill the connection type and related details. Click Connect
button
Drag your preferred table or view from the left pane from data design view, click Save
button.
Click Properties
button in configuration panel, property pane opens. Now, Switch to ASSIGN DATA
tab.
The data tab will be opened with available measures and dimensions from the connected data source
Drag and drop a date field from Dimensions
into Columns
section.
On binding field to PoP widget, default date ranges calculated based on the bounded field and set as selected filter.
By default, PoP widget render with some default filter value and which can’t be discard. We allow only to reset the filters to default if we made changes. The default date range calculated based on the days pan between min and max dates of the bounded field.
You can select the Relative/Custom date ranges using Relative Combobox
or Calendars
. We can select any date ranges irrespective of the bounded field. That field is used to calculated the default date ranges and filtering purpose.
The following relative items displayed under Date Range:
The following relative items displayed under Compare To:
In both relative items Combobox, Custom
will be selected automatically if you choose custom range from calendar or enter custom range manually using 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 Date Range
selected value as 1-Jan-2019 to 10-Jan-2019
. Here, the number of days between the selected dates is 10. So, Previous Period
value for the selected range is 22-Dec-2018 to 31-Dec-2018
.
Previous Year
:
It is a previous year dates of the selected date values from Date Range
. For example, consider Date Range
selected value as 1-Jan-2019 to 10-Jan-2019
. Here, year of start and end date value is 2019. So, 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
, 100% Stacked Column
, Distribution types of charts Line
, Spline
, Spline Area
, Area
, Stacked Area
, 100% Stacked Area
, Proportional types of charts Pie
, Doughnut
, Pyramid
, Funnel
can be slave widget for Period Over Period
.
Consider you configured Column chart
. You can change Column Chart
as slave for Period Over Period
widget by using filter interaction window as shown below.
Once you configured, Chart
color palette will be changed using PoP
selection colors(blue and green). The red information icon denote that chart virtual column value won’t get display in design mode.
Similarly, you can see option to customize legend and palette for virtual column which will be displayed in Designer Preview/View Mode.
During interaction from PoP widget, chart will display two series. One having values filtered from Date Range
and another one contains filtered values from Compare To
.
Please find the response of different type of charts as slave for PoP widgets.
Bar Chart
Line Chart
Area Chart
Spline Chart
Spline Area Chart
Stacked column Chart
Percent Stacked bar chart
Consider you have configured Proportional Chart
as slave for Period Over Period
widget. Like column, line charts color palette will not be changed. The Red information icon denote that comparison of period visualization won’t be shown in design mode.
During interaction of Pop Widget, proportional chart will display two series. One shows values filtered from Date Range
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 change the title for the Period Over Period.
Allows you provide subtitle for Period Over Period.
Allows you provide 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 text color to the widget title.
This allows you to toggle the visibility of border surrounding the widget.
This allows you to apply the specified radius to the widget corners. Value can be between 0 and 10.
This allows you to enable/disable comment for dashboard widget. For more details refer here