Support > Repository > Aggregation/Graph
ja | en

Wagby has "summary view" which realizes aggregation processing on a certain model.

By using the summary view, you will be able to check the state of the data at various points.

Figure 1 Dimensions, Major, Condition

"Condition" is a search condition."Dimension" is an item that becomes the cut point of aggregation."Major" is the item to be counted. Figure 2 shows the summary view when one dimension is specified.

Figure 2 Example of summary view (one dimension)

Up to two dimensions can be specified in Wagby.

Figure 3 Configuration when two dimensions are specified

In the summary view, a small sum for dimension 1 is displayed.

Figure 4 Small sum image

condition

Search criteria for models.For example, if you specify date information as the search condition from the beginning of the month to the end of the month, it will be "Monthly Aggregation".

Dimension

It will be a cornerstone of aggregation.For example, if you specify "date" for dimension 1 and "correspondent" for dimension 2, it becomes "aggregate by correspondent and daily aggregation".

When a model reference item is specified as a dimension, the data sort order is the sort order specified in the sort rule of the reference model.

major

It is a group of data to be analyzed.Wagby allows you to specify more than one measure. The alignment order of the measures is fixed.Specifically, it is as follows.

  • For string type, numeric type, date type, ascending order of values.
  • For model reference, ascending order of primary key.

Type of item to be counted

Object Type of item that can be specified
condition There are no particular restrictions.
Dimension String
date
Model reference (list box)
Model reference (radio button)
Model reference (search screen)
Reference linkage
major integer
1 byte integer
2 byte integer
4 byte integer
4 byte floating point
8 byte floating point
8 byte integer
String type
Model reference (list box)
Model reference (radio button)
Model reference (checkbox)
Reference model (search screen)

Repeat item/Handling of repeated containers

It is not possible to specify repeating items or repeating container fields for dimensions and measures.

For example, if there are "subtotal" items in the repeating container and you want to display this total in the summary view, prepare separately (outside the repeating container) an item that sums the amounts of the repeated container items, and add that item to the summary view Please add the definition to add.

Treatment of alternative model without table creation

For dimensions and measures,Option model not to create tableYou can not specify.

(1) Aggregate numerical values
Specify a numeric type item in the measure. It is the most common aggregation.
(2) Aggregation of options
You can specify a model reference item in a measure.
(3) Aggregate character strings
You can also specify a string type item in the measure. It is effective when you want to compile the free description field such as questionnaire input.
(4) Specify total, number, average, maximum, minimum, product, center, frequency, standard deviation, and variance for each measure
You can specify total, number, average, maximum, minimum, product, center, frequency, standard deviation, and variance for each measure.
(5) Prepare multiple summary views for one model
Multiple aggregate views can be prepared for one model. Since you can specify dimensions and measures in each case, you can browse the aggregate results at various angles.
(6) Counting results
You can cachorize the results for the specified time. When multiple users view the same summary view, processing can be speeded up by omitting calculation processing.
(7) Graph
You can display the graph at the bottom of the summary view.
(8) Graph - Runtime specification
You can set the type, color and size of the graph for each user.
(9) Categorize dimensions
When values ​​that become dimensions are subdivided, you can use the method of classification to make it easy to see.
(10) Adjustment of appearance
You can specify font size, label characters, etc. in batch or individually.

Items that become dimensions and measures are "Save to databasePlease say that.In case of non-saving, performance is affected because values ​​are acquired one by one.