Code On Time: User Interface

Saturday, March 7, 2015Print Subscribe

The “geo” chart type will render a map of the Earth. Each value will be a country, region, or city with a number associated with it. Countries with larger numbers will be a darker shade. The scale for the values is shown in the bottom right corner. The example below shows the location of customers by country in the Northwind sample app.

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

Data Field	Tag
Country	pivot1-row1-geo

The data for the chart can be seen below.

Hovering over a data point will reveal the data. An arrow will be rendered on the scale in the bottom right corner.

The label for each row is attempted to be resolved by Google Maps. Please see the Google Maps Terms of Service for more information on their data policy.

Display Mode

The “displaymode” property determines the rendering of data points on the chart. By default, the mode is determined automatically. When using countries, such as in the example above, it will render using “regions”. One alternative mode is to place markers that are relative to the size of the value by specifying “markers”.

To define the display mode, add the keyword “displaymode”, followed by a colon and the value in quotation marks. This keyword must be the last in the tag.

Data Field	Tag
Country	pivot1-row1-geo pivot1-displaymode:"markers"

Hovering over densely packed data points will magnify the region.

Using a display mode of “text” will render the value as a string over the correct location. The size and boldness of the text reflects the size of the value.

Region

The “region” property allows setting the zoom level of the map. By default, the property is set to “world”, to display the full map. The value can be set to a continent using its 3-digit code, a country with the ISO 3166-1 alpha-2 code, or a state in the United States with the ISO 3166-2:US code. If using a state, the resolution property must be set to “provinces” or “metros”.

The example below is set to zoom into the continent of Europe with code “150”.

Data Field	Tag
Country	pivot1-row1-geo pivot1-region:"150"

Resolution

The “resolution” property determines the display of data points on the geo chart. By default, it is set to “countries”. The “provinces” value is supported for some country regions and US state regions. The “metros” value is supported for US country region and US state regions only.

Data Field	Tag
Region	pivot1-row1-geo pivot1-region:"US" pivot1-resolution:"provinces"

An example of the “metros” resolution mode can be seen below. The chart uses “markers” display mode.

Data Field	Tag
City	pivot1-row1-geo pivot1-region:"US" pivot1-displaymode:"markers' pivot1-resolution:"metros"

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

Saturday, March 7, 2015Print Subscribe

Bar Chart Type

The “bar” chart type renders horizontal bars for each row of data. One use case would be to quickly compare records grouped by lookup values. For example, it can be used to show the number of orders made with each employee on the Orders page of the Northwind sample app. The chart reveals that “Peacock” is the most active employee.

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

Data Field	Tag
EmployeeID	pivot1-row1-bar

Here is the data for the above graph:

Hovering over or clicking on a single bar will reveal the data behind that bar.

When multiple values are specified for each row, a bar will be rendered for each value in a different color.

Data Field	Tag
EmployeeID	pivot1-row1-bar
ShipVia	pivot1-col1

Multiple columns of data can be seen in the table below.

Each row can also be displayed as a single bar, with values stacked on that bar, by using the “barstacked” chart type.

Data Field	Tag
EmployeeID	pivot1-row1-barstacked
ShipVia	pivot1-col1

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

Thursday, March 5, 2015Print Subscribe

Area Chart Type

The “area” chart type is useful for showing change in a value over time. For example, it can show how the number of orders in the Northwind database changes by the order date. To use “area” chart type, add the keyword “area” to any “pivot-” tag, and make sure that it is separated with hyphens (-).

Data Field	Tag
OrderDate	pivot1-row1-date-area

The data for the chart can be seen below.

Note that the chart above uses “-date” keyword. This keyword will direct the server to try several pivots with varying date group sizes and select the best fitting chart. An alternative definition to define a chart that looks exactly like the one above would look like the following:

Data Field	Tag
OrderDate	pivot1-row1-year-area pivot1-row2-month

Discrete points can be clicked on to reveal the row, column, and value for that data point.

This chart type is also effective for showing multiple values on the same chart. The example chart below shows the frequency of orders made with each shipper over time. It uses order date for the rows, and the shipper company name (ShipVia) as the columns.

Data Field	Tag
OrderDate	pivot1-row1-year-area pivot1-row2-quarter
ShipVia	pivot1-col1

The data for the graph above can be seen here:

By default, the values are shown independently. You can choose to stack the values cumulatively by using the “areastacked” tag instead.

Data Field	Tag
OrderDate	pivot1-row1-year-areastacked pivot1-row2-quarter
ShipVia	pivot1-col1

Labels: Application Builder, ASP.NET Code Generator, Charts, Features, Touch UI, Tutorials, User Interface