Data Visualization and Reporting


A key component of building apps within the Vizion Platform is integrated data visualization with dashboards and reporting. In this section, you'll learn how to construct effective visualizations and reports that cater to the needs of end business users, turning complex data sets into clear, actionable insights.

What are the most needed answers?  Where is my stuff? If checked out, who has it? What is the value of assets at each location?

Dashboards

Dashboards offer users immediate access to vital information through real-time data visualization. When designing dashboards, identify and focus on the most significant business questions. Then, you can tailor your dashboard to effectively address key topics, creating strategic assets for informed decision-making.

See the User Guide section on Dashboards: https://onevizion.atlassian.net/wiki/spaces/USER/pages/276792806

Case Study: Dashboards

For the Equipment Checkout app, we will build a dashboard - “Checked Out Dashboard”, which shows checked out Assets, highlighting past due items and Assignees.

Before creating a Dashboard, let’s review what a completed Dashboard looks like from an End User perspective. The below video demonstrates the user experience and some features of the Dashboard page.

 

Steps to Create a Dashboard

Steps to Create a Dashboard

1

From your desired Trackor page, configure a View and Filter that returns the data (columns and Trackor records) you would like to utilize in your Dashboard visualizations.

In this example, we will select from the Transaction Trackor Page.

Create a Dashboard Video

 

 

Tip: Create a Global View and Filter and name them specifically for the Dashboard. This will make it easier to revisit the original Dashboard Dataset.

2

Once your View and Filter have been configured, click on the ellipsis to display the Dropdown options.

Click on Create Dashboard.

3

A new window appears. Enter a Dashboard Name and Description.

Take note of the system generated SQL which is based on your View and Filter selections.

Press OK to close the window and create the Dashboard.

4

Navigate to the Dashboards page. It is from this page where you will open your new Dashboard and configure your Charts and Graphs.

From the Menu, navigate to Dev Center > Build Applications > Dashboards.

 

 

5

Note: From the Dashboards page, if your system already has an existing Dashboard, the last visited will be the landing page.

Click on the carrot to reveal a dropdown and select your newly created Dashboard.

Ex: “Check Out Dashboard”

 

You are now ready to start configuring the Dashboard.

Configure a Dashboard

Configure a Dashboard

1

From your Dashboard page, press Edit on the default created Dashlet. From here you can make configuration changes to display details based on the original dataset.

 

2

Enter a Dashlet name.

3

Set X & Y Axis Field selections. The Graph will update as selections are made.

4

Select the Chart Type and Chart Options such as “Show Values”.

5

Optional: Select a color for the chart values.

6

Press OK to complete.

7

To add an additional Dashlet, press the Add button.

Follow the same steps as depicted above and, in the video, to create additional Dashlets.

8

To create a Table instead of a Chart, follow the same general steps to create a Dashlet. In the 'Options” window, select “Table” instead of the default “Chart” option.

Demonstrated at 1:28min in video above.

9

After your Dashlets have been configured, you can click, hold and drag Dashlet windows to arrange and display in matter that works best.

Demonstrated at 3:00 min in video above.

 

10

There is an option to set up Drill-Down relations. This allows end users to click and select on a chart and cause other related Dashlets to filter and display details related to the selected item.

Selections for Drill-Downs can be set up from the Options window of each Dashlet.

Demonstrated at 3:28min in video above.

11

Clear Drill-Down filters by pressing Reset Drill-Down located at the top of each Dashlet.

 

12

Your Dashboard has now been configured.

Next: Create a Menu Item for your new Dashboard page and assign to your Menu.

 

Create a Menu Item for the Dashboard

  • Item Type = “Dashboard”

  • Dashboard Name = “Your new Dashboard”

  • Note: In the below screenshot, a “Dashboard” Sub-Group Menu Item has been created along with the “Check Out Dashboard” Menu Item assigned within it.

To review details on creating Menu Items and assigning them to the Menu, please reference our earlier training segment: https://onevizion.atlassian.net/wiki/spaces/USER/pages/3068395521/Structure#Build-Menu

 

Reports

In the Vizion Platform, reports are essential tools for comprehensively analyzing and presenting data in an accessible format. Reports are created in Excel, CSV, or Word/PDF formats and downloaded from the Vizion Platform. There are many of the same benefits of Dashboards, with the addition of data extraction into Excel, automated scheduling, ability to save to an E-File field, and email delivery.

For complete information on Reports, review the User Manual: https://onevizion.atlassian.net/wiki/spaces/USER/pages/3119120385

Case Study: Reports

For the Equipment Checkout App, we will use the Report Wizard and a View to create a report about Transactions. When it runs, users will be required to select what Transaction status should be included in the results.

Before creating a Report, let’s review what the End User experience is when running a report. The below video demonstrates the outcome of the report we are creating.

Create Report with Wizard

Create Report with Wizard

1

Navigate to Dev Center > Build Applications > Reports. This will take you to the Report Administration page.

 

2

Since this is a new system, start by adding a Report Group. There must be one to add a Report.

Click the ellipsis in the Command Bar, then Admin Report Group.

3

In the new window, click Add.

Name the Report Group. Click OK.

You will see the Report Group in the list. Click Close to navigate back to the Reports page.

4

Click Report Wizard in the Command Bar. You may need to click the ellipsis menu to find this option. This will open the Report Wizard Applet. Optional: pin the Report Wizard selection to the Command Bar.

5

In the applet, for Action 1, select Create new report and click Next>.

6

Action 2 sets report parameters and options. Enter the information detailed in Report Wizard and click Next>.

7

The screen will advance to Action 3 where you choose columns which will be included in your report and sort by the appropriate column. You may also choose a permanent filter and up to 10 parameters that are adjustable each time the report is run.

8

Start by opening the View and Filter. Here you will see all Global and Local Views and Filters from the Trackor Type that was selected in the previous step as primary.

9

Select a view. This will set the columns that are included in the report output. If you need to, you can make changes directly in this window. For ease of change and reproductivity, it is best to make and save changes to the View on the Trackor Type page.

 

10

Select a filter. Use this option with caution. A filter applied here will be permanent and apply every time that the report is run.

11

Select Report Parameters. Report Parameters can be adjusted each time you run the report in order to limit the returned output.

  • In the sidebar, locate ‘Report Parameters’ with boxes numbered 1-10.' Click the ellipsis next to the first empty box to open the field selector.

  • To narrow down the options, select the relevant App (Trackor Type) and Data Tab at the top; you can use the quick search to narrow down the list. Choose the field and click OK to add it as a Report Parameter.

  • You will see the field name in both boxes next to the 1 under Report Parameters.

    • Optionally, rename the field in the second box. This will be the visible name when running the report.

  • Check 'Required?' if you want users to make at least one selection for this parameter.

  • Repeat the process for additional parameters as needed.

 

 

12

After everything is ready click the Show Grid button, which will update the Grid on the right. Make sure that the data shown is what you need for your report, then you may go to next step.

13

Click Next> to continue.

 

14

Action 4 is the system generated SQL code. You can click Format SQL to arrange the code into a more readable arrangement. You do not need to do or change anything here and can just click Finish to create the report.

15

The Wizard window will close and bring you back to the Admin Reports page. Search for the report you just created. You have successfully created a report!

 

Create a Menu Item for the Report

To review details on creating Menu Items and assigning them to the Menu, please reference our earlier training segment:

Continue Training

https://onevizion.atlassian.net/wiki/spaces/USER/pages/3068395866