Dream Factory

How to create dashboards with data from Dream Factory

Dream Factory is a system that turns any database into an API platform, allowing you to connect any of your SQL / NoSQL databases to Numerics and visualize your most important numbers.

Once you’ve hooked up any SQL or NoSQL database with DreamFactory, it instantly creates a comprehensive REST API platform. With the API in place, you simply have to connect Numerics to your DreamFactory account and provide the fields for the widgets in Numerics. Below, each of the types of widgets are listed along with examples of fields that are required to pull your data from your database.

Label from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Postfix: The units for the label.

All fields are case sensitive.

Here is a sample query:

  • Table: Project
  • Fields: name,status
  • Postfix: Business Plan
  • Value Key: status

The above query will display the status along with the postfix.

Number from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Postfix: The units for the number.

All fields are case sensitive.

Here is a sample query:

  • Table: Opportunities
  • Fields: totalAmount
  • Postfix: USD
  • Value Key: totalAmount

The above query will display the total value of opportunities along with the postfix.

Number and difference indicator from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Postfix: The units for the number.

All fields are case sensitive.

Here is a sample query:

  • Table: Calls
  • Fields: duration_minutes
  • Filter: (date_start >= 2016-06-04) AND (date_start <= 2016-06-05)
  • Postfix: USD
  • Value Key: duration_minutes

The above query will display the total call minutes along with percentage change values and the postfix.

Line Graph from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table:Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Postfix: The units for the label.

All fields are case sensitive.

Here is a sample query:

  • Table: Opportunities
  • Fields:name,amount
  • Order: amount ASC
  • Group: name
  • Postfix: USD
  • Value Key: amount

The above query will display the value of opportunities plotted on a line graph.

Named Line Graph from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Value Label Key: The key that holds the label that defines that value in the response from the query.
  • Postfix: The units for the label.

All fields are case sensitive.

Here is a sample query:

  • Table: Opportunities
  • Fields: name,amount
  • Group: name
  • Postfix: USD
  • Value Key: amount
  • Value Label Key: name

The above query will display the opportunities plotted on a line graph with the opportunity name on the x-axis and the amount on the y-axis.

Top List funnel chart from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Value Label Key: The key that holds the label that defines that value in the response from the query.
  • Value Header: The header for the values as required to be displayed on the dashboard.
  • Name Header: The header for the labels as required to be displayed on the dashboard.

All fields are case sensitive.

Here is a sample query:

  • Table: Opportunities
  • Fields: sales_stage,totalAmount
  • Order: totalAmount DESC
  • Group: sales_stage
  • Value Key: totalAmount
  • Value Label Key: sales_stage
  • Value Header: USD
  • Name Header: Sales Stage

The top 5 opportunities based on the sales stage will be chosen to draw the top list. The Value Header and Name Header will be displayed as the heading titles for the two sides of the top list.

Pie Chart from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limite the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Value Label Key: The key that holds the label that defines that value in the response from the query.

All fields are case sensitive.

Here is a sample query:

  • Table: Opportunities
  • Fields: totalAmount,sales_stage
  • Order: totalAmount DESC
  • Group: sales_stage
  • Value Key: totalAmount
  • Value Label Key: sales_stage

In the above query, the top 5 opportunity stages will be chosen to draw the pie slices and the rest will be added to once slice called other.

Day Density chart from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Date Key: The key that holds the date in the response from the query.

All fields are case sensitive.

Here is a sample query:

  • Table: Calls
  • Fields: date_start_cast,duration_minutes
  • Filter: (date_start >= 2016-03-01) AND (date_start <= 2016-03-31)
  • Order: date_start_cast
  • Value Key: duration_minutes
  • Date Key: date_start_cast

The above query will display the call minutes each day in a day density calendar.

Hour Density chart from Dream Factory data:

Design your query using the configuration fields provided to get the data you need from your database. Brief descriptions of each field with a sample query are provided below.

  • Table: Name of the table to perform the operations on.
  • Fields: Comma-delimited list of filed names to retrieve for each record.
  • Filter: SQL-like filter to limited the resources to retrieve.
  • Order: SQL-like order containing field and direction for filter results.
  • Group: Comma-delimited list of the fields used for grouping of filter results.
  • Related Fields: Comma de-limited list of related names to retrieve for each record.
  • Value Key: The key that holds the value in the response from the query.
  • Hour Key: The key that holds the hour in the response from the query.

All fields are case sensitive.

Here is a sample query:

  • Table: Emails
  • Fields: date_entered_cast,total_count
  • Group: date_entered_cast
  • Value Key: total_count
  • Hour Key: date_entered_cast

The above query will display the emails sent each hour in an hour density clock.