Home / Tech Tip / Web Intelligence XI R2: Calculations Interacting with Alerter Output

Web Intelligence XI R2: Calculations Interacting with Alerter Output

Question: I have a need to show dates, in a column, that fall into a certain date range (1-5 days). In the second column, show dates that fall into a second date range (6-10 days). At the bottom of each column, display a count of the dates that fall into each of the criteria. How can I accomplish this?

Answer: 

Step 1

Create a variable to the report that will contain the number of days from the initial “Case Create Date” to the current date.

Step 2

Create Alerters, so that only the correct data is shown in each of the columns.

  • The first Sub-Alerter will display the Case Create Date.
  • The second Sub-Alerter will display a blank (=””)

Step 3

Create your count at the bottom of each column.

  • =Count([Days Between])Where ([Days Between] Between(1;5))
  • =Count([Days Between])Where ([Days Between] Between(6;10))
  • =Count([Days Between])

Finished Report

About ckruger

Check Also

Let’s Speak BO Webinar: Design and Development Techniques for Mobilizing SAP Dashboards October 17, 2017

Webinar: Design and Development Techniques for Mobilizing SAP Dashboards

Join us in a fantastic and informative session with expert developer and Dashboards Consultant, Roxanne …

Leave a Reply

Your email address will not be published. Required fields are marked *