Defining data for a dashboard object

Follow the steps below to specify the data;

  1. First select the Query data set that you wish to base your dashboard object;
  2. Select the calendar you wish to be used to derive any date groupings (such as year, period, week etc).  
  3. If you wish to, press the filter button to apply a filter to your data set (applying filters will be described in more detail below).
  4. Next, decide how you want to group your data, and select the appropriate option;
     The three options are
    1. On Change of:
       Create a record for each distinct combination of the group values selected.
    2. For All Records:
       Creates a single record regardless of the group values selected.
  5. Add the group columns () you require (some object types, such as single series charts, will only allow a single group column).
  6. Next, select which summary columns () you require (some object types, such as single series charts, will only allow a single summary column). 
  7. For each summary column, select the summary operation you wish to be applied. Distinct count is the number of distinct values in the column for the group selected. Some summary columns will be calculations, rather than values that exist in the dataset. For these columns, the only summary operation