Introduction to dashboards

In Flowfinity, you can create dashboards to visualize and explore live or historical data in your Flowfinity database. You can quickly identify trends and exceptions, and even drill-down into datasets for even more detail. Flowfinity dashboards provide operational intelligence to help you manage your business in real-time.

Example

A service manager needs to track work orders by field technicians, and effectively manage job costs. Throughout the day, the manager views a real-time dashboard for an overview of activities as they happen. The dashboard sums up the total time spent on work orders and their total estimated costs, and breaks down the results across regions.

Instructions

  1. Click on the Configure tab.
    Note: If you are using Flowfinity Actions Enterprise Edition, select the appropriate "Site" from the top right drop-down menu
  2. Under the Dashboards section, click the 'Design New Dashboard' link at the bottom of the page
    Flowfinity - Add new users
  3. Enter the dashboard name, description, then click 'Save'
    Flowfinity - Add new users
  4. Next, click 'Add Widget" at the top left of the page. Dashboards are comprised of widgets, which display the live data you will interact with
    Flowfinity - Add new users
  5. Select the "Source app", which will be an application already built in Flowfinity (e.g. Work Orders)
  6. Next, choose the View where the data is coming from (e.g. View All Records).
  7. Choose a Dimension to indicate how the data should be aggregated, or grouped by (e.g. Region).
    Flowfinity - Add new users
  8. Click 'Finish'
  9. To select data that will be graphed in the dashboard, add measures. There are three types of measures available. Count measures count records, field measures use a single field to perform calculations based on existing data, such as summing up numerical fields, and calculated measures use multiple fields to create a new column of data that did not exist in the original dataset.
    1. Right-click anywhere in the chart, and select 'Add count measure' to sum up the number of items in the category (e.g. for this widget, it will count the total number of work orders per region). Click 'Save'
      Flowfinity - Add new users
    2. To add another measure, right-click anywhere in the chart again, and select 'Add field measure'.
    3. Choose the field with the data you want to sum up (e.g. Estimated Duration), and the proper 'Value format' (e.g. Timespan). Click 'Save'
      Flowfinity - Add new users
    4. To add more measures, repeat steps 9b and 9c with new fields and corresponding value formats (E.g. Estimated Cost, Money)
      Flowfinity - Add new users
  10. For additional drill-down options, right-click on the chart, and select 'Manage Dimensions'. Add as many dimensions as you'd like, as this gives you the ability to filter your dashboards into specific data sets once the graphs are created. Click 'Save'
    Flowfinity - Add new users
  11. Your table data is ready! To see how the data looks as a chart, click on the chart icon in the top-right corner
    Flowfinity - Add new users
    Flowfinity - Add new users
  12. To change the chart type, right-click on the column you want to edit (e.g. Count), and choose 'Edit visualization'
  13. Beside Visualization type, select your choice from the drop-down list, e.g. Pie. Click 'Save'. This will automatically create a new Level in the dashboard, because the visualization type (Pie) is different from the others that are displayed in Bar format.
    Flowfinity - Add new users
  14. Right-click in the gray area around the pie chart, and select 'Level properties'
    Flowfinity - Add new users
  15. Specify a level name (e.g. Pie & Numbers)
  16. At the bottom of the window, click on 'Link another measure' and select the field you want to sum up from the drop-down list (e.g. Estimated Duration)
  17. Right beside it, select how you want the data displayed (e.g. Number). Click 'Save'
  18. Repeat steps 16 & 17 with additional fields you want to display (e.g. Estimated Cost)
    Flowfinity - Add new users
    Flowfinity - Add new users
  19. Click the menu icon in the top-left corner, and publish the dashboard
    Flowfinity - Add new users
    You can continue to edit the dashboard until you have all of your data and visualizations set up. Request a demo to learn more.
    Flowfinity - Add new users