Difference between revisions of "Configuring Interactive List View Charts"

From SmartWiki
Jump to: navigation, search
Line 44: Line 44:
 
* Populate the Chart Title if needed. This is the title that will appear on the rendered chart.  
 
* Populate the Chart Title if needed. This is the title that will appear on the rendered chart.  
  
* Select the Chart Type you wish to us. Currenty the options are
+
* Select the Chart Type you wish to us. The current options include . . .
 
** Bar  
 
** Bar  
 
** Horizintal Bar
 
** Horizintal Bar
Line 54: Line 54:
 
[[Image:ichart-list-view-selectChart.png|600px|link=]]
 
[[Image:ichart-list-view-selectChart.png|600px|link=]]
  
Preview your Arcadia X section.
+
* Select the List View columns that should appear as X-Axis and Y-Axis.
 +
[[Image:ichart-list-view-selectAxis.png|600px|link=]]
 +
 
 +
'''NOTE:''' If the Aggregation Type is Sum or Average then the Y-Axis has to be a numeric value.
 +
 
 +
* Select the Aggregation type from the available options ...
 +
** Sum: provide a sum of all values in the column selected as the Y-Axis for each grouping defined in the column selected in the X-Axis
 +
** Average: provide an average of all values in the column selected as the Y-Axis for each grouping defined in the column selected in the X-Axis
 +
** Count: provide an overall count of records for each grouping defined in the column selected in the X-Axis
 +
** None: provide a sum of all values in the column selected as the Y-Axis for each grouping defined in the column selected in the X-Axis
 +
 
 +
 
 +
* Select the Default View type. This is how the information will be displayed when the user logins in and accesses the information. The available options are ...
 +
** Chart: will display the chart when user logs in
 +
** Table: will display the tabular data when user logs in
 +
** List View:  will display the basic list view when user logs in
 +
 
 +
* Click Save
 +
 
 +
* Preview your Arcadia X section.
  
 
[[Image:ichart-arcadia-x-preview.png|600px|link=]]
 
[[Image:ichart-arcadia-x-preview.png|600px|link=]]
  
 
[[Category:List Views]]
 
[[Category:List Views]]

Revision as of 14:33, 2 August 2016

Configuring Interactive List View Charts

Visualize your data with interactive charts. Chart by Status,Type or a value of your choice. Toggle between the chart view and the table view. Drill into the charts to see the data further delineated. Go directly into the object from the table view. Print charts or export them in multiple formats.

This feature is available in Arcadia X, it only takes a few seconds to setup and you don’t need to create a report.


Interactive List View Charts.gif

How to configure Interactive List View Charts

  • If your list view does not already exist then create a list view of the data you want to chart (List view of a UTA level 1 is shown below).

Ichart-list-view-column.png


NOTE: If your list view is only going to be used for charts, check Configuration Only. Note this setting hides this list view from the View list. You can still pick this list view when configuring an Arcadia X portal.

Ichart-list-view-properties.png


  • Go to Configuration > Roles & Permissions > User Roles


  • Click the Edit button on the desired role with an Arcadia X portal.

Ichart-role-list.png

  • Create an Action Tab for the chart and choose the Content Type of Sections then Save.

Ichart-actiontab.png

  • Add a Section.

Ichart-section-add.png

  • Choose the Type of Chart. This will expose additional Chart List View, Chart Type, X-Axis and Y-Axis options, as well as the Aggregation type.

Ichart-actiontab-section.png

  • Go to the Chart List view section and select the List View you wish to use as the basis for the Chart.

Ichart-list-view-selectLV.png

  • Populate the Chart Title if needed. This is the title that will appear on the rendered chart.
  • Select the Chart Type you wish to us. The current options include . . .
    • Bar
    • Horizintal Bar
    • Pie
    • Donut
    • 3D Bar
    • 3D Pie
    • 3D Donut

Ichart-list-view-selectChart.png

  • Select the List View columns that should appear as X-Axis and Y-Axis.

Ichart-list-view-selectAxis.png

NOTE: If the Aggregation Type is Sum or Average then the Y-Axis has to be a numeric value.

  • Select the Aggregation type from the available options ...
    • Sum: provide a sum of all values in the column selected as the Y-Axis for each grouping defined in the column selected in the X-Axis
    • Average: provide an average of all values in the column selected as the Y-Axis for each grouping defined in the column selected in the X-Axis
    • Count: provide an overall count of records for each grouping defined in the column selected in the X-Axis
    • None: provide a sum of all values in the column selected as the Y-Axis for each grouping defined in the column selected in the X-Axis


  • Select the Default View type. This is how the information will be displayed when the user logins in and accesses the information. The available options are ...
    • Chart: will display the chart when user logs in
    • Table: will display the tabular data when user logs in
    • List View: will display the basic list view when user logs in
  • Click Save
  • Preview your Arcadia X section.

Ichart-arcadia-x-preview.png