Support > Repository > Aggregation/Graph > Specify total, number, average, maximum, minimum, product, center, frequency, standard deviation, and variance for each measure
ja | en

You can specify total, number, average, maximum, minimum, product, center, frequency, standard deviation, and variance for each measure.

You can specify various calculation methods for each measure.Figure 1 shows an example of aggregation with alternating sums and averages.

Fig. 1 Aggregation with total and average alternating

Define the items to be specified as measures.(This time it is all numerical type.)

Fig. 3 Model to be counted

Open "Screen> View> Summary View".Activate "Create Screen".

"Page Title" is also used as a button name for transitioning to the tabulation view.When it is blank, the button name becomes "Totalized view 1", so please set the page title as much as possible.

Set the items in the "dimension" column.For this time, we specify two dimensions of "store name" and "data".

Figure 4 Setting the Page Title and Dimension

In Figure 4, press the "major" button and specify which item to use as a measure.(FIG. 5)
Here, total or average is specified for each item.

Figure 5 Setting items to become major

In the numeric type field, you can specify one of the following as the aggregation method.

  • total
  • Number
  • average
  • maximum
  • minimum
  • product
  • Center
    Please read the explanation of the link destination function for details of the center, the most frequent, standard deviation, and variance.Calculation restrictions are imposed, such as standard deviation and variance require two or more values.
  • Most frequent
  • standard deviation
  • Standard deviation of population
  • Dispersion
  • Distribution of population
  • major
    Automatic judgment by type of the item is done.Numbers are total, model references and string types are total or number.