Blog | Forms, Reports, Apps. Build and deploy rapidly. Use offline, online, on-premises.

Sunday, March 8, 2015Print Subscribe

The “map” chart type displays a map using the Google Maps API. It accepts values in the form of addresses and renders them as pins on the map. This chart type can be useful for displaying values associated with regions or locations. However, it may be more beneficial to use Maps presentation style to allow for data interaction or Geo Chart Type instead.

The map below shows the location of customers by country.

Data Field	Tag
Country	pivot1-row1-map

The data for the map is displayed below.

Clicking on a data point will reveal the value.

The type of map can be specified with the “maptype” property. The default value is “hybrid”. The other options are “normal”, “terrain”, or “satellite”. The example below shows the “terrain” map type.

Data Field	Tag
Country	pivot1-row1-map pivot1-maptype:"terrain"

The switcher for map type is disabled by default. The switcher can be enabled by adding the “usemaptypecontrol” keyword. It will appear in the top-right corner.

Data Field	Tag
Country	pivot1-row1-map pivot1-usemaptypecontrol

By default, the user cannot use the scroll wheel to zoom. This functionality can be enabled by adding the “enablescrollwheel” keyword.

Data Field	Tag
Country	pivot1-row1-map pivot1-enablescrollwheel

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

Sunday, March 8, 2015Print Subscribe

Line Chart Type

The “line” chart type shows a line that plots a value as it changes over the horizontal axis. A typical use case might be plotting a value over time.

To use “line” chart type, add the keyword “line” to any “pivot-” tag, and make sure that it is separated with hyphens (-).

Data Field	Tag
OrderDate	pivot1-row1-date-line

The chart is using the “date” keyword, which directs the server to attempt several combinations of date groupings. The best fit group is selected and displayed to the user. An equivalent tag combination on OrderDate data field would be “pivot1-row1-year-line pivot1-row2-month”.

The data for the chart can be seen here.

Clicking or hovering over a data point will reveal the value.

When multiple columns or values are specified, more than one line will be drawn with a different color. It is clear that Davolio’s performance in Q1 of 1997 had declined.

Data Field	Tag
OrderDate	pivot1-row1-year-line pivot1-row2-quarter
EmployeeID	pivot1-col1

The data displays the multiple columns of data below.

By default, lines will be drawn straight. The lines can be curved by specifying the keyword “curve”.

Data Field	Tag
OrderDate	pivot1-row1-year-line pivot1-row2-quarter pivot1-curve
EmployeeID	pivot1-col1

The line chart can also be drawn vertically. Specify “vertical” for the orientation property and the chart axes will be flipped.

Data Field	Tag
OrderDate	pivot1-row1-year-line pivot1-row2-quarter pivot1-orientation:"vertical"
EmployeeID	pivot1-col1

One can enable zooming and panning on the chart by specifying the “explorer” keyword.

Data Field	Tag
OrderDate	pivot1-row1-year-line pivot1-row2-quarter pivot1-explorer
EmployeeID	pivot1-col1

Using the scroll wheel will change the scale of the vertical axis.

Clicking and dragging will pan the chart.

Right-clicking on the chart area will reset the chart. Note that the “explorer” functionality may cause interference with the user scrolling through the page – use only when necessary.

Labels: Application Factory, ASP.NET, Charts, Features, Touch UI, Tutorials, Web Application Generator

Saturday, March 7, 2015Print Subscribe

Pie Chart Type

The “pie” chart type is rendered as a circle. Each data point is displayed as a slice out of the circle. This chart type is useful to show the size of values relative to one another. One example may be the number of orders made by each employee – the largest slice of the pie is taken by the employee who made the most orders.

To use “column” chart type, add the keyword “column” to any “pivot-” tag, and make sure that it is separated with hyphens (-).

Data Field	Tag
EmployeeID	pivot1-row1-pie

The data for the chart can be seen below.

If the slice is large enough, the percentage value is displayed. Hovering over or clicking on a slice will reveal the data.

If there are too many slices, the chart may become unreadable to the users. Use “topX”, sort the row values, and enable “Other” row to ensure that only the largest X number of slices are displayed, and the rest are collapsed.

Data Field	Tag
EmployeeID	pivot1-row1-pie-top5-other-sortbyvalue

The sorted top five rows and “Other” row can be seen in the data below.

The pie can also be rendered as a 3D pie by using the “pie3d” chart type instead.

Data Field	Tag
EmployeeID	pivot1-row1-pie3d

The chart can also be rendered with a hole in the center by specifying the “donut” chart type.

Data Field	Tag
EmployeeID	pivot1-row1-donut

Labels: Application Builder, ASP.NET, Charts, Features, Touch UI, Tutorials, Web Application Generator