Code On Time: Application Builder

Tuesday, March 10, 2015Print Subscribe

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.

Labels: Application Builder, ASP.NET, Charts, Touch UI, Tutorials, User Interface, Web App Generator

Tuesday, March 10, 2015Print Subscribe

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.

Labels: Application Builder, ASP.NET Code Generator, Charts, Code Generator, Designer, Features, Tips and Tricks, Touch UI, Tutorials, User Interface, Web App Generator, Web Application Generator

Tuesday, March 10, 2015Print Subscribe

Enabling Animation In Charts

Charts in web apps created with Code On Time generator do not show any animations by default. The charts simply appear.

It may be desirable to add an animation when the chart is loaded. This animation can be added by specifying the “animation” keyword to the chart tag definition.

Data Field	Tag
EmployeeID	pivot1-col1-top3 pivot1-animation
OrderDate	pivot1-row1-line-curve-date
Freight	pivot1-val1-sum

The new chart will now be animated on load.

Labels: Application Builder, Charts, Touch UI, Tutorials, Web App Generator, Web Application Generator