InsideSales.com
InsideSales.com
InsideSales.com Menu

Introduction to Using Formulas

Overview Use formulas to manipulate your data for use in a data visualization.
Key Features Use the formula editing toolbar to refine and manipulate your data
Use Active Insights catalog of functions to format data
Data Formats Excel/CSV/Spreadsheet formats
XML/JSON formats

Overview

You can create formulas using the formula editing toolbar to manipulate, refine, and perform calculations on values taken from a data source. Formula editing provides a powerful tool for preparing your data for use in a data visualization.

Formula Editing Toolbar

Here is an overview of each of the button’s on the formula editing toolbar.

Insert data from the data source.
Insert a literal string or number.
Reference another component.
Insert a variable.
Insert a function.
Insert a parenthesis.
Wrap current value in a function.
Wrap current value in parenthesis.
Insert a node to the left of the current selection.
Insert a node to the right of the current selection.
Undo action.
Redo action.

Operators

You can insert mathematical operators into your expressions by clicking on the ... ellipsis. This will bring up with Operator’s toolbar with the following options:

Functions

Learn more about functions in these articles:

Release Notes

Find our most recent release notes.

Forum

Our InsideSales.com community forum is coming soon.

Advanced Training Guides

Advanced training for the PowerDialer for Salesforce.

Have questions?

We're happy to help. An InsideSales.com expert is just a phone call away.

(866) 593-2807

Mon-Fri 6-7 MST

Back To Top

© 2004–2014 InsideSales.com, Inc. all rights reserved. Use of the InsideSales.com service and this Web site constitutes acceptance of our Terms of Use and Privacy Policy. InsideSales.com technology is protected by the following United States Patents: 8078605, 8325738, 8352389, 8510382, 8566419.