Summary

A brief statement or account of the main points. We can add summary to the table:

  1. Click on Add Summary button, one table will open
  2. Select the Chart Type from the drop down, we have options: Summary Fillgauge, Summary Ibox, Summary Message, Summary Circle
  3. Set properties as required
  4. then, click on Save button
_images/summary01.png
  1. Click on Preview button to see the preview
_images/summary02.png

Summary Fillgauge

_images/summary02.png

Edit properties:

  1. Calculated Formula: Apllied only when aggregate is Calculated field ex:value1/(Value1-Value2) like

([pocount]/([pocount]+[netpr]))*100

_images/summaryfillgaugeCF.png

  1. Width: We can set width of the chart

  2. Height: We can set height of the chart

  3. Measure: In Measure we have all the fields available in the table and we can select any one from the drop down for which we want the summary.

  4. Aggregate: We hve aggregate function like Sum, Count, AVG, Calculated Field, MIN, MAX, MEDIAN, DISTINCT and RATIO to get measure.

  5. Dimension description: Select field to display name of dimension in tooltip

  6. Number Format: Number Format is, in which format we want to display the number like .0F/,f

    ,f

_images/summaryfillgaugeNF.png

  1. Date Format: Format of date in data Ex: %m/%d/%Y (07/23/2016), %m/%d/%y (07/23/16), %Y-%m-%d (2016-07-23), %Y-%m (2016-07), Jan-16 (%b-%y)

  2. Prefix: We can add some prefix like

    $

_images/summaryfillgaugedoller.png

  1. Suffix: We can add some suffix like

    %

_images/summaryfillgaugesuffix.png
  1. Field Name: Field Name is mandatory field, this is where we need to select any field for which we want the summary.
  2. Divider: Field value to get the percentage(number format should be %)
  3. Enable Click: If we will make Enable Click Yes then the chart will be clickable and the data will reflect according to click.

14. Filter By: We can specify any field by which we want to filter the data. A10

  1. Detail: Text on waves
_images/summaryfillgaugedetail.png
  1. Desc Color: We can change the color of description
  2. Field Type: Specify field type (Number/Date/String)
  3. Min Value: We can set any minimum value
  4. Max Value: We can set any maximum value
  5. Desc Size
  6. Circle Fill Gap: We can increase and decrease the circle gap like 0.2
_images/summaryfillgaugecirclefillgap.png
  1. Circle Thick Ness: We can edit circle’s thickness
_images/summaryfillgaugecirclethikness.png
  1. Circle Color: We can change the circle color
_images/summaryfillgaugecirclecolor.png
  1. Wave Risetime: We can increase and decrease the wave risetime
  2. Wave Count: We can set the number of waves
_images/summaryfillgaugewavecount.png
  1. Wave Height: We can increase and decrease the wave height
_images/summaryfillgaugewaveheight.png
  1. Widget Color
  2. Wave Height Scaling
  3. Wave Rise
  4. Wave Animate Time: We can increase and decrease the wave animate time
  5. Wave Offset
  6. Wave Color: We can change the wave color
_images/summaryfillgaugewavecolor.png
  1. Text Vert Position: We can set text’s vertical position
_images/summaryfillgaugeTVP.png
  1. Text Wave Color
  2. Text Color: We can change the text color
_images/summaryfillgaugetextcolor.png
  1. Text Size
_images/summaryfillgaugetextsize.png
  1. Detail Vert Position: We can change detail text verical position
_images/summaryfillgaugeDVP.png
  1. Detail Color: We can change the color of detail text
_images/summaryfillgaugedetailcolor.png
  1. Detail Size: We can change the size of the detail text
_images/summarydetailsize.png
  1. Wave Animate
  2. Value Type: We have 3 types of value type percentage, value percentage and value

Summary Ibox

_images/summaryibox.png

Edit properties:

  1. Calculated Formula: Apllied only when aggregate is Calculated field ex:value1/(Value1-Value2)
  2. Width: We can set the width of the chart
  3. Height: We can set the height of the chart
  4. Measure: In Measure we have all the fields available in the table and we can select any one from the drop down for which we want the summary.
  5. Aggregate: We hve aggregate function like Sum, Count, AVG, Calculated Field, MIN, MAX, MEDIAN, DISTINCT and RATIO to get measure.
  6. Dimension description: Select field to display name of dimension in tooltip
_images/summaryiboxDD.png
  1. Number Format: Number Format is, in which format we want to display our number like ,f
_images/summaryiboxNFf.png

.0F

_images/summaryiboxNF0F.png
  1. Date Format: Format of date in data Ex: %m/%d/%Y (07/23/2016), %m/%d/%y (07/23/16), %Y-%m-%d (2016-07-23), %Y-%m (2016-07), Jan-16 (%b-%y)
  2. Prefix: To add some prefix like ‘$’
_images/summaryiboxdolor.png
  1. Suffix: To add some suffix like ‘%’
_images/summaryiboxpercentage.png
  1. Filter:N From We have two options Top and Bottom. If we will select Top it will show 20 from the top of table and if we will select Bottom it will show 20 from the Bottom of table
  2. Filter-N: Default N- value: Here we have to pass some numeric value, It will return the number of rows whatever number we have passed.
  3. Field Name: It is a mandatory field, this is where we need to select any field for which we want the summary
  4. Divider
  5. Count
  6. Enable Click: If we will make Enable click yes then we are able to click and able to see some specific data
_images/summaryiboxEC.png
  1. Filter By: We can specify any field by which we want to filter the data.
  2. Detail: Detail is the text on chart, which describe the chart summary
  3. Field Type: We can have 3 types of fields String, Number and Date
  4. Min Value: We can set any minimum value
  5. Max Value: We can set any maximum value
  6. Process Bar Color: We can give any color to process bar
_images/summaryiboxPBC.png
  1. Value Type: We have 3 types of value type percentage, value percentage and value
  • percentage Type:
_images/summaryiboxpercentage.png
  • value percentage Type:
_images/summaryiboxvaluepercentage.png
  • value Type:
_images/summaryiboxvalue.png

Summary Message

_images/summarymessage.png

Edit properties:

  1. Calculated Formula: Apllied only when aggregate is Calculated field ex:value1/(Value1-Value2)
  2. Width: Width of the chart
  3. Height: Height of the chart
  4. Measure: In Measure we have all the fields available in the table and we can select any one from the drop down for which we want the summary.
  5. Aggregate: We hve aggregate function like Sum, Count, AVG, Calculated Field, MIN, MAX, MEDIAN, DISTINCT and RATIO to get measure.
  6. Dimension description: Select field to display name of dimension in tooltip
_images/summarymessage06.png
  1. Number Format: Number Format is, in which format we want to display our number like

.0F

_images/summarymessage070F.png

,f

_images/summarymessage07f.png
  1. Date Format: Format of date in data Ex: %m/%d/%Y (07/23/2016), %m/%d/%y (07/23/16), %Y-%m-%d (2016-07-23), %Y-%m (2016-07), Jan-16 (%b-%y)
  2. Prefix: To add some prefix like ‘$’
_images/summarymessage09.png
  1. Suffix: To add some suffix like ‘%’
_images/summarymessage10.png
  1. Filter:N From We have two options Top and Bottom. If we will select Top it will show 20 from the top of table and if we will select Bottom it will show 20 from the Bottom of table
  2. Filter-N: Default N- value: Here we have to pass some numeric value, It will return the number of rows whatever number we have passed.
  3. Field Name: It is a mandatory field, this is where we need to select any field for which we want the summary
  4. Divider
  5. Count
  6. Filter By: We can specify any field by which we want to filter the data.
  7. Enable Click: If we will make Enable click yes then we are able to click and able to see some specific data
_images/summarymessageenableclick.png
  1. Detail: Detail is the text on chart, which describe the chart summary
  2. Field Type: Specify field type (Number/Date/String)
  3. Widget Color: We can give any color to widget
_images/summarymessageWC.png
  1. Widget Icon: We can add any icon to the summary
  2. Value Type: We have 3 types of value type percentage, value percentage and value
  • percentage:
_images/summarymessagepercentage.png
  • value percentage:
_images/summarymessageVP.png
  • value:
_images/summarymessagevalue.png

Summary Circle

_images/summarycircle.png

Edit properties:

  1. Calculated Formula: Apllied only when aggregate is Calculated field ex:value1/(Value1-Value2)
  2. Width: We can set the width of the chart
  3. Height: We can set the height of the chart
  4. Measure: In Measure we have all the fields available in the table and we can select any one from the drop down for which we want the summary.
  5. Aggregate: We hve aggregate function like Sum, Count, AVG, Calculated Field, MIN, MAX, MEDIAN, DISTINCT and RATIO to get measure.
  6. Dimension description: Select field to display name of dimension in tooltip
  7. Number Format: Number Format is, in which format we want to display our number like ,f
_images/summarycircleNFf.png

.0F

_images/summarycircleNF0F.png
  1. Date Format: Format of date in data Ex: %m/%d/%Y (07/23/2016), %m/%d/%y (07/23/16), %Y-%m-%d (2016-07-23), %Y-%m (2016-07), Jan-16 (%b-%y)
  2. Prefix: To add some prefix like ‘$’
_images/summarycircledolor.png
  1. Suffix: To add some suffix like ‘%’
_images/summarycirclepercentage.png
  1. Filter:N From, We have two options Top and Bottom. If we will select Top it will show 20 from the top of table and if we will select Bottom it will show 20 from the Bottom of table
  2. Filter-N: Default N- value: Here we have to pass some numeric value, It will return the number of rows whatever number we have passed.
  3. Field Name: It is a mandatory field, this is where we need to select any field for which we want the summary
  4. Divider
  5. Count
  6. Enable Click: If we will make Enable click yes then we are able to click and able to see some specific data
_images/summarycircleenableclick.png
  1. Filter By: We can specify any field by which we want to filter the data.
  2. Detail: Detail is detail about the summary. Text on the summary
_images/summarycircledetail.png
  1. Field Type: Specify field type (Number/Date/String)
  2. Font Size: We can change the font size of the text like we have selected ‘Extra Large’ font size-
_images/summarycirclefont.png
  1. Widget Color: We can change the widget color
_images/summarycirclewidgetcolor.png
  1. Widget Icon: We can change the widget icon
_images/summarycirclewidgeticon.png
  1. Value Type: We have 3 types of value type percentage, value percentage and value
  • percentage:
_images/summarycirclepercentage.png
  • value percentage:
_images/summarcircleVP.png
  • value:
_images/summarycirclevalue.png