Exago Logo
Search
Generic filters
Exact matches only
Exago Logo

BI Formulas For Ad Hoc Reporting

by | Reporting

If formula_strip

 

Ad hoc reporting can do much more than display raw data. Formulas take data as input for calculations, security and formatting and give reports real business value. These BI formulas can be as simple as displaying the month of a date element or as complicated as finding the year-over-year rate of change for a particular field or metric. Exago BI provides an intuitive formula editor as well as the ability to create custom formulas. This post, meant for report designers and power users, will describe and illustrate examples of fivefunctions commonly utilized in data analysis.

5 Functions

1) If
The If function allows reports to build in some logic. The If function takes three parameters: a condition followed by two values. If the condition evaluates to True, then the first value is used; if not, the second value is used.

In the example below, the If function checks to make sure the report does not write a blank line if the address does not have a second street: “if({Addresses.Street 2}=”,newline(), newline() & {Addresses.Street 2}& newline())”.

2) Today

Returns the current date when the report is run. Does not take any parameters.

3) NewLine

Jumps to the beginning of the next line in text. Does not take any parameters.

4) DateDiff

Returns the amount of time between two dates. The DateDiff function takes three parameters: a string and two dates. The string tells the eWebReports what unit to measure the difference in. “yyyy” returns years, “d” days, “w” weeks, “m” months, “h” hours, “n” minutes, “s” seconds, “q” quarters.

5) LoadImage

Loads an image from the connection string parameter. This allows you to keep images on a server and load them dynamically instead of keeping them in the report.

Example

The report designer below shows how these five functions can be used to draft a reminder letter. The NewLine and If functions help format the address. Today and DateDiff calculate the number of days left to apply. Finally, LoadImage inserts a picture into our letter.

 

Formulas in Advanced Report Designer

 

To see what these formulas produce, we run the report as a PDF.

 

Report Output

This post highlighted just five out of the many formulas offered by Exago BI. Leveraging these formulas and those that you define will bring ad hoc analysis and real business value to your data.

Happy Reporting.

 

About Exago BI:

For SaaS businesses looking for embedded BI solutions, Exago supports providers and their users by making it easy for business professionals to access and manipulate their data, no matter their technical qualifications. Exago BI integrates seamlessly with web-based SaaS applications to bring ad hoc reporting and analytics to any multi-tenant environment. Our dedication to customizable integration allows us to prioritize usability without compromising on power. Contact us today for more information.

BI Newsletter

Stay up-to-date on all things SaaS and analytics with fresh content each month.

Share This