Connect Dream Factory
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.