Custom Report Builder – T03 Heatmap Table Widget

1.1 Widget Setting

1.1.1 Data Tab

1.1.1.1 Preview

1.  Dimensions
   1. A list of dimensions. Users are able to drag the dimension to the Filter or Split area to render out the result for the heatmap table.
2. Measures
   1. A list of metrics. Measures are the values that will be aggregated over the selected data. Users are able to drag the metric to the Measure area to select the metric for the widget.
   2. The naming structure of measure: [Metric Code]_[Count Mode]_[Aggregation Formula] (e.g. FC01_1_Sum)
   3. For metric code definition, please refer to Appendix B - Metrics Definition
   4. The following count mode stand for:
      1. 1 - People,
      2. 11 - Visitor People,
      3. 21 - Staff People,
      4. 12 - Car Vehicle
3. Filter
   1. Users are able to select the dimension to filter (WHERE clauses) the data for the heatmap table. By default, the filter will follow the report granularity to preselect a few dimensions. (e.g. Company level report will auto filter with latest date, company id and company name).  If users drag a non-preselected dimension (e.g. Area), this widget will become data binded and the graph output will follow the selected option of the dimensions.
   2. Filter Configuration:

      Item	Description
      1. Time	Default filter date range based on the widget time interval. Minutes, 15Minutes, Hours - Latest Day Days - Latest Week Weeks - Latest Month Months, Quarter, Year - Latest Year Users are able to select the data range to preview the graph output. If user select relative time, the selected time will not apply to the real data for the heatmap table to display (only for preview display purpose). If user select fixed time, the selected time will apply to the real data for the heatmap table to display. Not Supported Time Shift function.
      2. Data	Users are able to select for the dimension options to preview the heatmap table output. If there are extra filters (not preselect dimensions), this widget will be considered as data binded. For example, if the selected granularity of the report/dashboard is Site, the preselected dimension will be Company and Branch. If users drag a non-preselected dimension (e.g. Area), this widget will become data binded and the heatmap table output will follow the selected option of the dimensions.

4. Split
   1. Users must select two (2) dimension to split (GROUP BY clauses) the data for the heatmap table. The splits for T03 heatmap table widget must have two dimensions, which are Data + Time, Data + Data or Time + Time. (Note: Heatmap Table not supported Quarterly time interval)
   2. The allowed time comparison (Time + Time) are:
      1. Minutes, 15Minutes - Minutes vs Hours
      2. Hours - Minutes vs Hours / Hours vs Days
      3. Days - Hours vs Days / Days vs Weeks / Days vs Months
      4. Weeks - Days vs Weeks / Weeks vs Months
      5. Months - Days vs Months / Weeks vs Months / Months vs Years
      6. Year - Months vs Years
   3. Split Configuration:

      Item	Description
      1. Granularity (Only Supported for Time Dimension)	Time - Time Granularity based on the widget's time interval. Time2 - Users are able to select the granularity for Time, which are minute, hour, day, week, or month.
      2. Sort By	Sort according to the selected option.
      3. Order By	Order by ascending or descending.
      3. Limits	Select the output limit (5, 10, 25, 50 or 100).

5. Measure
   1. Users are only able to select one (1) measure to render the data for the heatmap table.
      
6. Element Type
   1. Preview the result in different element types (only for preview display purpose).
7. Preview Screen 
   1. Users are able to preview the heatmap table output in different element types based on the selected dimensions and measure in filter section, split section and measure section.

1.1.2 Settings Tab

*Required field

1.1.3 Advanced Tab