Create a quick report summary of your data

Step 1: To create “Quick report summary”, click “Dashboards”.

Step 2: Select the “Analysis” option to view all the reports.

Step 3:  Select the “Quick report summary” option from the analysis option.

Note:  You can see the default quick report in your work area. Drag it to wherever you want it to be placed. Also, you can resize it by dragging the bottom right corner.

Step 4: Click “Edit”   menu on the report header to edit your report’s data, appearance and social settings.

Step 5: To link the data to the report, select the desired file from the left file tree and select columns from data.

Step 6:  In “Settings” click the reporting properties which you want to analyse in your report. There are three properties:

  • Key Values
  1. Maximum: The maximum value in the collection.
  2. Minimum: The minimum value in the collection.
  3. Percentile:The value below which a given percentage of observations in a group of observations fall. For example, the 20th percentile is the value (or score) below which 20% of the observations may be found.
  • Central tendency
  1. Arithmetic mean: The sum of all values divided by the number of values. This is usually referred as the ‘mean’ or ‘average’.
  2. Geometric mean: The nth root of the product of n values . The geometric mean multiplies all the values together and takes the nth root of the product. For example the geometric mean of 2,4 = (2×4)^1/2 = 4. The application of the geometric mean is to be able to normalise the range of values being averaged, particularly, if these values from different ranges are being included in the mean score process. For example, to calculate the overall geometric mean of a person’s bio metric, by combing the height (mm), weight (kg) and foot size (cm). To get the integrated score with geometric mean, the relative size of each measurement range is normalised, such that, the same percentage increase in any of the underlying scores has the same effect on the resulting score. For example, a 20% increase in height will have same effect as a 20% increase in weight.
  3. Harmonic mean:The reciprocal of the arithmetic mean. The harmonic mean is influenced by lower values where as the arithmetic mean is heavily influenced by large values (a single large value will heavily skew the arithmetic mean and a single very low value will influence the harmonic mean).
  4. Median:The middle value when all the values are sorted. This is also the 50th percentile.
  5. Mode:The value that appears most often in collection.
  • Distribution
  1. Standard deviation:A measure of the amount of variation or dispersion of a data collection.
  2. CV: The ratio of the standard deviation to the arithmetic mean. A high coefficient of variation indicates a large standard deviation (i.e. variation) relative to the size of the mean.
  3. Mean/Median:It is a simple measure of skewness. If the data is symmetrically distributed, then, the mean and median will be identical. This simple measure indicates the direction of skew (<1 - to the left, >1 to the right)
  4. Pearson’s skew: The mean/median/standard deviation.

Step 7: After selecting the properties, format your report with “Formatting tab” which allows:

  • Title-font: the title font size, type and colour.
  • Title-background: the title background colour.
  • Header font: the header font size, type and colour.
  • Body font: the body font size, type and colour.
  • Alignment: alignment of the text.

Edit the settings of your visualisation for sharing on social media

To edit the information that will accompany the report when sharing on social media (Facebook, Twitter, etc.), select the ‘Social’ tab.

Share your report

Share your dashboard with reports or a specific report using “Share” tab under “Dashboards”.