# Blog

Labels
Archive
Blog
Tuesday, March 10, 2015PrintSubscribe
Calculation of Chart Values

If a chart does not have a value field specified, the chart will take a count of records that fall into the row and column group. For example, if the EmployeeID data field in the Orders controller is specified as a row field, then the count of Orders will be used as the value.

 Data Field Tag EmployeeID pivot1-row1-bar

The chart data shows that the count of Orders is used as the value.

In order to use a different value for the chart, a value field must be specified. Tag the data field that you wish to use with the correct pivot ID and assign it “val” plus the order for the data field. The example below will use Freight field as a value.

 Data Field Tag EmployeeID pivot1-row1-bar Freight pivot1-val1

Notice that the values are the same! That is because the value mode of Freight is the default “count”. You must specify a value mode to manipulate the number. The example below will use the sum of Freight by using the keyword “sum”.

 Data Field Tag EmployeeID pivot1-row1-bar Freight pivot1-val1-sum

The correct sum can be seen in the chart and data.

The table below shows a list of the available value modes.

 Keyword Description count The default mode. Will count every record. sum Will summate the value in every record in the row/column group. min The smallest value in the group. max The largest value in the group. avg The sum divided by the count.
Tuesday, March 10, 2015PrintSubscribe
Sorting Rows and Columns in Charts

Suppose that you have a chart on the Orders page that shows the number of orders made by up to 10 customers. By default, the rows are sorted in ascending alphabetical order of the customer’s name.

 Data Field Tag CustomerID pivot1-row1-column-top10

The chart with alphabetically sorted customers is shown below.

The chart data shows that the first ten customers were included in the chart.

The customers can also be sorted in descending alphabetical order by using the keyword “sort” or “sortdesc”.

 Data Field Tag CustomerID pivot1-row1-column-top10-sort

The new chart shows the first 10 customers in descending order.

The chart data will show customers sorted in descending alphabetical order.

Sometimes it may be necessary to sort the rows by a column value. Use “sortbyvalue” or “sortdescbyvalue” to sort in descending order of the row value.

 Data Field Tag CustomerID pivot1-row1-column-top10-sortbyvalue

The chart now shows the top 10 customers that make orders.

The data shows that the rows have been sorted by the “Count of Orders” column.

In a similar fashion, the bottom 10 customers making orders can be displayed by using “sortascbyvalue” keyword.

 Data Field Tag CustomerID pivot1-row1-column-top10-sortascbyvalue

The chart now shows the least active customers.

The chart data will reveal the correct ascending order.

Column fields can be sorted with the same keywords. For example, the chart below shows the top 5 employees making orders over the Order Date. It appears “Peacock” made the most orders in this time period.

 Data Field Tag EmployeeID pivot1-col1-top5-sortbyvalue OrderDate pivot1-row1-date-areastacked

The data can be seen here:

Tuesday, March 10, 2015PrintSubscribe
Maximizing Charts

Several sample charts are displayed below. Note that the axis values, legend, title, and any labels are placed outside of the chart. The chart itself floats in the center of the cell in the view.

It is possible to expand each chart so that they fill the entire available area. All elements of the chart will be place inside the axes in order to full utilize all available screen size. The legend will be placed at the top of the graph, axis labels are placed inside the axes, and the title is also located inside the graph area.

In order to specify a chart to use this expanded mode, add the keyword “maximize” for every pivot defined in the view.

 Data Field Tag CustomerID pivot3-col1-top5-sortdescbyvalue pivot3-maximize EmployeeID pivot2-row1-bar pivot2-maximize OrderDate pivot1-row1-date-line pivot3-row1-date-all-columnstacked pivot4-row1-date pivot1-maximize ShipVia pivot4-col1-areastacked pivot4-maximize

The charts will now maximize the available space.