<< Click to Display Table of Contents >> Current:  Create Dashboard > Table > Visual Analysis > Year-on-year/ Month-on-month Growth  Industrial Calendar

The user can specify holidays and special dates by configuring industry calendar files. For month-on-month ratio, if the comparison date is a configurable holiday period, you need to go back to the last valid working day.

 

The configuration rules are as follows:

Create /calendar/holidays.txt under the directory bihome. Add weekend field to holidays configuration file to control whether remove Saturday and Sunday or not. Other special dates are added as yyyy-mm-dd. 

 

❖Application example

•Set time base parameter at non-date column and calculate the month-on-month ratio 

1.Create /calendar/holidays.txt under the directory bihome. The contents are as follows:

weekend

2013-04-30

2013-05-01

 

2.Create a new table. Add a dimension column STATE and measure column: Sum_SALES.

 

3.Select month-on-month from the submenu of column Sum _SALES. Select "By Day" and "Growth Rate" at the month-on-month setting menu. Set m1=2017-09-11 in time basis parameter as shown in the figure below.

 

Because 2017-09-10 and 2017-09-09 are Saturday and Sunday respectively, they will be filtered out. The time points of month-on-month calculation are 2017-09-11 and 2017-09-08.

 

 

➢Note:The industrial calendar only affects fullday year-on-year ratio. Other time levels and year-on-year ratio are not affected by the industrial calendar.