Creating O4W Dashboards
I. Creating a dashboard and graphs from the CUSTOMERS and PRODUCT tables
- From the O4W Main Menu select O4W Dashboard.
* From the O4W Dashboard Menu select Create/Modify.
* Enter the name of your Dashboard and click the Next button.
* From the Layout Tab we will now define general characteristics about the dashboard.
* From the Configuration Tab we will define the total number of graphs for this dashboard, then number of rows and columns for the dashboard and the refresh time for the dashboard.
* From the Panels Tab we will define some characteristics for each graph.
* From the Charts Tab we will define how each graph is to present data. The Sales by Product Chart will be a Pie Chart and the Customer Ranking Chart will be a Bar Graph.
The full Select statement should read:
SELECT CUSTOMERS WITH SALES_YTD > “0” BY-DSND SALES_YTD
* From the Data Tab we will define the dictionaries to utilize for the x and y coordinates for each graph.
* From the Completion Tab click the Save button to save the Dashboard.
* Once saved, we can now run our Sales Dashboard.
* Our Sales Dashboard will display.
* Same graphing data using Google Charts.