In response to customer requests, we’ve re-enabled and will support subscribers who wish to edit their actions scripts directly. This will be great news to a large portion of our user base and will greatly simplify the work involved for those people who want to build sophisticated dashboarding solutions.
Up until August 25 2014, prior versions would hide the underlying script that was driving the data refreshes. Our belief was that by hiding this, the product would seem less complicated.
Over the past year, we’ve come to believe that our user base would prefer to see the script, and be able to work with it directly.
For those who are unfamiliar with our scripting engine, an example script is shown below.
When you open one of our spreadsheets, you will see that each cell is just plain text that can be edited.
The text cells are read by NEXT Analytics software when a refresh-data request is made and executed one by one.
You can use this simple approach to take advantage of the power of Excel. For example, you can use built-in Excel form controls to power the values of these scripts. This lets you, for example, create a drop down of certain parameter values on your dashboard worksheet. You might want to prompt people for Segments, or profiles, date ranges, or even filters or sort orders. You can build your own custom user interactions.
We’ve supplied a short PDF document which answers one of the most popular requests: How to change a range of time in one of the Sample dashboards. You can download the PDF file here.
How to Change a range of time in one of the Sample dashboards: