What’s in this article?
When working with formulas and functions in the formula editor, you can copy and paste elements of your formula. This feature can save time and effort, especially when you need to use an extended formula like in a spark line or bullet chart. You can copy and paste virtually any element of your formula, from a single element like a selection of data to a nested formula.
Tip! Check out this article to learn more about nested formulas.
The formula element is copied and pasted in the new location.
This feature is one of the most important tools in the Widget Editor, and as you start assembling more complex Widgets, you will find this feature has many applications. This list provides a few examples of particularly useful ways to apply this feature.
Bullet charts are assembled by assigning 3 data points in the following order: target value, live value, and comparative value. Unless your data source comes preformatted with these values, you will need to provide these values using a nested formula such as the ARRAY/JOIN method. The following example is taken from the Example – Marketing Traffic Sources Widget in the Widget Developer’s Guide.
In this example, we want to create 3 bullet charts using an identical format but different values. We have already created the first bullet chart formula and want to use this template to create two more bullet charts. Select the nested JOIN function and press CTRL+C.
Next, we will select the first ARRAY function, click the data link in the ARRAY, and then press CTRL+V. A duplicate of the first bullet chart is inserted into the formula.
To create a unique bullet chart, all you need to do is replace the values in the duplicate formula. Once you have your formula created, just copy, paste, and replace the values for your third bullet chart.
© 2004 – 2014 InsideSales.com
InsideSales.com technology is protected by the following United States Patents: 8078605, 8325738, 8352389, 8510382, 8566419.