Using Scripting in a Dashboard Report

Scripting in a dashboard report give users full control of InetSoft's dashboard software for the highest level of customization available. View the example below to learn more about the Style Intelligence solution.

This section discusses several basic date functions.

The ateDiff()' function is used to find the difference between two dates in days/months/years.
dateDiff('d', fromDate, toDate); // days
dateDiff('m', fromDate, toDate); // months
dateDiff('yyyy', fromDate, toDate); // years

For example, if we have a table bound to a query which contains the date field 'Birth Date', we can create a formula field (in the data binding dialog) that calculates the age of this Birth Date in years by subtracting the birthday from the current date. The script of this formula field is shown below.
dateDiff('yyyy', field['Birth Date'], CALC.today())
The 'dateAdd()' function is used to find a date which is n number of days/months/years before/after another date.
// 1 day before today
dateAdd('d', -1, CALC.today());

// 5 months after today
dateAdd('m', 5, CALC.today());

// 3 years before Order Date
dateAdd('yyyy', -3, field['Order Date']);
For example, wish to run a query in script; this query takes in two date parameters namely 'StartDate' and 'EndDate'. We want the query to always fetch data which is 15 days before the today and 15 days after today.
var sd = dateAdd('d', -15, CALC.today());
var ed = dateAdd('d', 15, CALC.today());
var q = runQuery('Order Bookings',
        [['StartDate', sd],['EndDate', ed]]);

Read what InetSoft customers and partners have said about their selection of Style Scope for their solution for dashboard reporting.

More Articles About Dashboarding

9 KPIs for Web App Performance Monitoring - App performance metrics enable you to determine how far the application goes to help your business and the potential improvements you can make. Tracking the right KPIs is the key to the success of the monitoring initiative. The right ones provide a comprehensive report and actionable insights to improve your application. Here is a list of KPIs you must monitor: 1. Load Speed Load speed measures the time your app takes to get ready to interact with the user. Low load speeds are problematic because they lead to an increase in bounce rates. 2. CPU Usage CPU usage affects an app's responsiveness, with high spikes indicating a performance bug that degrades its responsiveness. 3. Memory Usage High memory usage translates into high resource consumption in the server. If the application has inadequate virtual memory, it tends to spend more time on thrashing...

Creating Privilege Report Groups - InetSoft's reporting software allows administrators to easily create report groups that govern the privileges that are allowed to specified users. View the information below to learn more about the Style Intelligence solution. A group is a collection of users, such as a project team, a department, or a geographical location. You can create and edit groups in Enterprise Manager only when using the 'Default Security Provider'. To create a new group, follow the steps below: From the main Users tab, click the 'New Group' link below the navi­gation tree. This creates a group with the default name 'groupN' (group0, group1, etc.). Type in the 'Name' field to change the name of the group. Drag and drop users and/or groups into the 'Members' box. This adds the individual users and users within the groups to the new group. (A user/group can be added to multiple groups.) Drag and drop roles into the 'Roles' box. All of the users in this group will be assigned the specified roles. Click 'Apply' to save your changes. To edit a group, expand the 'Users' node on the tree, and click on the desired group...

Insurance Carriers Use Artificial Intelligence - Insurance carriers are increasingly leveraging artificial intelligence (AI) to enhance various aspects of their operations, from customer service and claims processing to risk assessment and fraud detection. Here's a detailed look at how AI is transforming the insurance industry: 1. Claims Processing and Management AI streamlines claims processing by automating many of the routine tasks involved, such as data entry and verification. Machine learning algorithms can quickly analyze claims data to identify patterns and anomalies, speeding up the approval process and reducing the potential for human error. Automated Claim Verification: AI systems can automatically verify the authenticity of claims by cross-referencing data from multiple sources, such as photos, videos, and sensor data. Fraud Detection: AI can identify suspicious claims through pattern recognition and anomaly detection, flagging them for further investigation. This reduces the occurrence of fraudulent claims, saving insurance companies significant amounts of money...

Evaluate InetSoft's Drag and Drop Dashboard Builder - Are you looking for a good drag and drop dashboard builder? InetSoft's pioneering dashboard application produces great-looking web-based dashboard with an easy-to-use drag and drop designer. Get cloud-flexibility for your deployment. Minimize costs with a small-footprint solution. Maximize self-service for all types of users. No dedicated BI developer required. View a demo and try interactive examples...

Serve More Customers by Improving Planning - One big misconception that people have about business intelligence is that only big corporations can use and benefit from it. This couldn't be further from the truth. Eat, a UK-based coffee chain, is a great example here. The company wanted to give their employees the insights into the most popular products, the busiest times, and other important data so they could understand their customers better. What they did was a simple but effective solution. By giving the serving personnel Windows tablets that had business intelligence and analytics tools, they made it possible for them to see which products were selling the most and which stores in the chain were the busiest. As a result, the staff had more information about how to prepare in a way that allowed them to provide better services. The management also benefited from the data by using it to improve planning on a store-level...

What Does Data Protection Entail? - Data protection refers to the practices and processes that ensure the security of data from unauthorized access, corruption, or loss. It is a critical aspect of information management that aims to protect the integrity, confidentiality, and availability of data, especially sensitive data such as personal or proprietary business information. Data protection encompasses a variety of operations, including but not limited to...