Tag Archives: WebI

Year to date comparison with previous year.

Everyone will once want to compare values from the beginning of a year until ‘a certain date’ with values from the exact same period but then from the previous year until ‘that certain date a year ago’. I found this youtube video where RimGeurts explains how to do this with BusinessObject Web Intelligence.

Year to date WebI

The screencapture is an excellent ‘how to’ guide to make a year to date (YTD) comparison based on an input date field. In this post I make an addition in case you don’t have a date but a month- or fiscal period code (like ‘201106’, or ‘FP201012’).

Continue reading

How to create a pareto chart in BOBJ WebI

The purpose of the Pareto chart is to highlight the most important among a (typically large) set of factors. In quality control, it often represents the most common sources of defects, the highest occurring type of defect, or the most frequent reasons for customer complaints, and so on. Wilkinson (2006) devised an algorithm for producing statistically-based acceptance limits (similar to confidence intervals) for each bar in the Pareto chart. Continue reading