Blog | Language | Customer Login | +1-925-218-6983
What is Visual KPI? | FREE 30-Day Trial | +1-925-218-6983 Subscribe via RSS Feed


Real-Time Dashboards & Alerts

Smartphones | Tablets | Web Browsers | PC & Mac | More

Visual KPI reads multiple data sources in real-time (big data, historians, databases, manual data, web services and more) and adds context with KPIs, groups/hierarchy, alerts, and geolocation. It gets your critical data in the hands of more users without extensive training and it can be deployed in days, not months. Want to see how we do it?

Mobile Operations Monitoring - Tour
Real-time KPIs on Browser, iPhone, iPad, Android, Windows Phone, tablet
Check out a 2-minute video and see the latest…
What is it?

Visual KPI is mobile dashboard software for any device. It reads existing data sources and delivers KPIs, scorecards, analytics and alerts in real-time.

Who uses it?

Decision makers. Operations. Remote workers. Data Junkies. Anyone who values knowing what's happening right now, regardless of their device.

Why use it?

Mobility is no longer optional. Visual KPI presents problems and opportunities before it's too late. Oh, and there's no six-month project that "might" pay off.

American Electric Power BP Wind Energy con edison operations Exelon Energy Genentech FMI - Freeport McMoRan Corning Pemex Tesoro


OSIsoft PI World Sponsor 

Support FAQ > Using Visual KPI > Can standard Excel expressions/equations be used in the Visual KPI Designer?

Search the FAQ for entries containing:

Microsoft Excel supports hundreds of functions, equations and variable types. Since Visual KPI Designer is built as an add-in to Excel, it is natural to assume that you can use any of the Excel functions when building equations for an Attribute like “Actual” or “High High.” However, since the Visual KPI Designer is the front-end authoring-only tool for Visual KPI, this assumption would be wrong. Here is how it really works when you use a Microsoft Excel function in Visual KPI:

  1. You can use any Excel equation to build complex value results in any cell of Visual KPI Designer, and you will see the results in the cell. You can save the spreadsheet using the Excel Save command and all of your Excel functions are preserved in the cells. 
  2. Once you save the results to the Visual KPI Server (using the Save button in the Document Actions pane) ALL Excel calculations are converted to the VALUE in the cell and saved in Visual KPI as the resulting number, string, date, etc. 
  3. Visual KPI immediately reads back the result and overwrites the equations in the cells with the VALUES that were just stored in the Visual KPI database. 

So how can you make functions and equations in Visual KPI which are executed at run-time by the Visual KPI Server? Easy! Use the built-in equations and functions supported by Visual KPI and be sure to format the cells as an Equation, which is any text contained in angle brackets <> as illustrated below. While Visual KPI does not support ALL of the Excel functions, we support many typical use cases for derived or calculated values in real-world scenarios. Most calculations in Visual KPI are simple math, or relatively short “IF THEN” evaluations and we support these through a built-in standard expression parser. Check out the examples below and see if your needs are met by one of these “patterns.”

Example Equations (for use in any standard attribute, either with or without a data reference in that attribute):

<[Tagname] + 10>
<[Tag1] / [Tag2]>
<[Tagname] * [Actual]/[Max]>

Let us know if you have any questions at

Last updated on February 19, 2013 by Transpara

Free 30-Day Trial

Transpara LLC
4715 W. Culpepper Drive‎
Phoenix, AZ 85087

© 2005-2018 Transpara LLC. All rights reserved.
Privacy Policy | Terms of Use | Copyrights

© 2005-2018 Transpara LLC | Privacy Policy | Terms of Use | | +1-925-218-6983