An expression column, or formula column, is a column whose data is generated from a script (expression) by processing existing data in the table. The expression can use either SQL or JavaScript syntax, and can reference any other columns within the Data Table.
To add an expression column to a table, follow these steps:
1. Click the 'Expression' button (labeled 'fx') located in the title row of the Data Table. This opens the 'Expression' dialog box.
2. Enter a name for the new column in the dialog box, and click 'OK'.
This adds the formula column to the right side of the table, and opens the Formula Editor.
3. In the Formula Editor, click the 'SQL' box to toggle between SQL and JavaScript syntax and select the appropriate data type from the 'Return Data Type' menu.
4. Enter the desired formula expression in the bottom text field. (JavaScript expression columns can make full use of the built-in scripting functions in the script library.)
5. Click 'OK' to exit the Formula Editor. The data in the new column will reflect the results of the specified expression.
More Articles About Dashboards
Co-located Multi-charts - The ability to position multiple charts of various types in a shared location and quickly sort through them by clicking on the corresponding tab thereby reducing the complexity of the data visualization dashboard and enhancing the propensity for accurate interpretation...
Critical Logistics Business Intelligence - When you look at logistics, it is absolutely critical right now. There is an expectation that has been built in consumers' minds in particular and business customers as well that they are going to be able to track a shipment in real time and know where it is. Well, if they don't know where it is they start to worry. They start to get anxious. The other issue is you start seeing that with expanded global trade, knowing where something is in the world is very critical for profitability. You've got to get it through customs etcetera, and you're also seeing that things with the supply chain management...
How-to: Top N Reports - After grouping we can further sort the table based on the section summarization. A Top N report will contain only the top 'n' sections (for example the top 3 results). This type of report is normally called a 'Top N' report. Top N table can only be generated on a table with grouping. Although it is possible to implement Top N filtering programmatically, the recommended way is to use the Report Designer GUI...
Non License Price Benefits for Lower TCO - InetSoft offers several non license priced benefits: No consulting services required to set up. No specialized BI experts need to be added to permanent staff; a basic database admin will do. Faster roll out time - due to an easier to use data modeler and dashboard reporting authoring tool. Little or no end-user training. Our system uses point-and-click usage models for interactive dashboards and reports. Maximum self-service and lower DBA support requirements...
Strategic Dashboard for CMOs - The marketing division has another example. Chief Marketing Officers (CMOs) sometimes lack the time to monitor statistics like traffic or CTR for specific campaigns. But in order to get the finest marketing outcomes a company can have and, therefore, make a profit, they do need to take a deeper look at a more strategic level of marketing activities and even work in tandem with sales. This marketing dashboard presents these crucial strategic KPIs in a simple, clear, and useful manner...
Why Web Service Data Sources Remain Relevant - Here are some key points: Reporting Services: Developers often utilize XML and web service data sources as sources for Reporting Services (SSRS). These data sources allow reports to retrieve information from external services or APIs. For example, in InetSoft or SSRS, you can configure a web service data source to fetch data from a publicly accessible service, such as a RESTful API or a SOAP-based web service...