Dashboard Chart Factory

We will be introducing a chart factory wizard with the Dashboard Designer. With this chart wizard, it will be a breeze to create different chart objects from a tabular output.

Here is a brief flow of how the task can be accomplished.

1. Connect to the Database or Excel file
2. InfoCaptor presents a wizard that allows you to build a blank dashboard or build a query on existing dashboard
3. Once you have the dashboard created you launch the query builder, drag all the tables you need, join them accordingly and create a valid SQL query.
4. The above SQL query is now your starting point
5. You create a tabular portlet or Qlet
6. From this Qlet you add all the needed parameters
7. It is necessary to decide all your parameters because it updates the table query accordingly which will form the basis of all the Charts
8. Once you are ready, click on the Qlet title and launch the chart factory.
9. Pick a chart type
10. Pick the columns
11. Pick the aggregations
12. Click on create chart
13. This presents you with the chart editor and shows you how the chart SQL looks like. You can rename the chart title or change other properties you may wish at this point (you can leave it as it is and update them later)
14. Click Apply
15. You have your chart created.

Stay tuned for detailed steps with screenshots and videos

Read More