InetSoft Product Instructions: Reports Function Reference
This section presents functions for Table and Section operations.
average(column[, group[,condition]])
Calculates the average of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
average of all values in a group
Example
text = average("Quantity", "State", "field['Discount']>0");
concat(column[, group[,condition]])
Concatenates all values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
concatenation of all values in a group
Example
text = concat("Quantity", "State", "field['Discount']>0");
 |
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software. |
correlation(column, column2[, group[,condition]])
Calculates the correlation between two columns. This function is only available to elements within a Section.
Parameters
column column label of the primary column
column2 column label of the column to correlate
group column label of the group to summarize
condition condition on the group to summarize
Return
correlation between the two columns
Example
text = correlation('Quantity','total','State',
"field['Discount']>0");
count(column[, group[,condition]])
Calculates the number of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
number of values in a group
Example
text = count("Quantity", "State", "field['Discount']>0");
 |
Read what InetSoft customers and partners have said about their selection of Style Scope for their solution for dashboard reporting. |
countDistinct(column[, group[,condition]])
Calculates the number of distinct values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
number of distinct values in a group
Example
text = countDistinct("Quantity", "State",
"field['Discount']>0");
covariance(column, column2[, group[,condition]])
Calculate the covariance of two columns. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
column2 second column used in calculating covariance
group column label of the group to summarize
condition condition on the group to summarize
Return
covariance of the two columns
Example
text = covariance('Quantity','Total',"State",
"field['Discount']>0");
max(column[, group[,condition]])
Calculates the maximum of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
maximum of all values in a group
Example
text = max("Quantity", "State", "field['Discount']>0");
median(column[, group[,condition]])
Calculates the median number in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
median number of all values in a group
Example
text = median("Quantity", "State", "field['Discount']>0");
min(column[, group[,condition]])
Calculates the minimum of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
minimum of all values in a group
Example
text = min("Quantity", "State", "field['Discount']>0");
mode(column[, group[,condition]])
Calculates the mode of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
mode of all values in a group
Example
text = mode("Quantity", "State", "field['Discount']>0");
More Articles About Reporting
All Marketing Campaign Metrics - Impressions: The number of times your ad or content is displayed to potential customers. Clicks: The number of times someone clicks on your ad or content. Click-through rate (CTR): The percentage of people who click on your ad or content after seeing it. Cost-per-click (CPC): The average cost you pay for each click on your ad. Cost-per-impression (CPM): The cost you pay for every 1,000 impressions of your ad. Cost-per-action (CPA): The cost you pay for each desired action, such as filling out a form or making a purchase. Conversion rate: The percentage of people who take a desired action, such as making a purchase or filling out a form, after clicking on your ad or content. Return on ad spend (ROAS): The revenue you generate for every dollar spent on advertising...
Chief Nursing Officer Dashboards - The sheer volume of highly confidential data in the healthcare industry makes it prone to theft and medical identity crime. To ensure satisfactory patient experiences and strong public healthcare industry, it is imperative to have KYC (Know Your Customer) systems in place for the verification of patient identities, pre-treatment. We have recently seen the worldwide struggle during this Covid-19 pandemic where the failure to accurately identify patients has resulted in delayed procedures and inaccurate treatments. Several medical facilities still use physical, paper-based setups which are outdated and slow. This leads to inaccurate data transfer, capacity problems, and inefficiency in the care system. The overall system issues often result in wrong medical diagnosis, duplication of medical records, incorrect patient identification and treatment, and insurance fraud...
Loan Originator Analytics - Fintech companies and NBFCs are leveraging cutting-edge predictive data science to revolutionize the lending process. With automated risk analysis and lightning-fast loan disbursements, these innovative organizations can now make informed decisions in record time, resulting in reduced risks for all involved. With modern lending software and apps, borrowers can quickly apply for loans from anywhere. All it takes is a few taps on their phone. The algorithm powering this service uses predictive data analytics to determine if applicants qualify according to pre-set criteria. Once approved, funds are credited almost instantly, so you'll never miss out when times call for swift access to cash. Let's take a look at how predictive analytics is assisting loan firms in making better decisions...
DMV Data Visualization - The State Department of Motor Vehicles (DMV) relies heavily on data visualization for various purposes, including improving operational efficiency, enhancing customer service, ensuring regulatory compliance, and making data-driven decisions. Here are several ways in which the DMV utilizes data visualization: Traffic Management and Planning: By visualizing traffic patterns, congestion hotspots, and accident data, the DMV can collaborate with transportation authorities to optimize road infrastructure, plan new routes, and improve traffic flow. License Plate Recognition and Surveillance: Data visualization tools can help analyze and interpret license plate recognition data, aiding law enforcement agencies in tracking stolen vehicles, identifying traffic violations, and investigating criminal activities. Customer Service Enhancement: DMV offices can use data visualization dashboards to monitor customer wait times, track service efficiency, and identify areas for improvement. Visualizing customer feedback and complaint data enables the DMV to address concerns promptly and enhance overall service quality...
Hear InetSoft Customer KPI Success - "We selected InetSoft's Style Report Professional for a time-tested, dependable publishing engine and a powerful, yet easy-to-use report designer that would save resources associated with internal development of publishing capabilities and client customization requests. We were looking for a Java-based publishing solution that could be easily integrated with our own. We have been pleased with deployment, and the reporting software's part in our ability to help companies of all sizes realize cost reduction and revenue acceleration associated with critical configuration and accurate quoting solutions." - Craig Christiansen, President-Technology at FPX...
Law Enforcement Analyst Reporting - Temporal Analysis: Use the tool to conduct temporal analysis, examining how certain events or activities change over time. Generate timelines or heat maps to visualize temporal patterns and correlations. Geospatial Analysis: Leverage geospatial capabilities to map crime locations, identify hotspots, and analyze spatial relationships. Overlay additional contextual data, such as demographic information or known criminal associates, to enhance understanding. Pattern Recognition: Apply analytical models and algorithms within the custom report tool to identify patterns, anomalies, or trends that may not be immediately apparent. Explore relationships between variables and entities to uncover hidden connections. Case Linkage: Use the custom report tool to link related cases or incidents, helping to establish...
Multiple Source BI - So as use of mobile BI devices gravitates more towards employees out in the field, it's only natural that a significant part of the information needed by those employees is going to be customer related. So what orders does a customer place, what's their invoice history, what's their payment history, what trouble particularly could be raised and so on.It used to be the case that relevant information was poured into a single-data warehouse or data mart. That makes it much more likely overall that employees are going to be able to find the data when they need it. Now instead of building and maintaining that data warehouse or that data marts, data is likely to be...