Chart for Event Occurrences in WebI
I have a requirement to show a graph of occurrences for Events that occur throughout the day. So possibly along the X-axis as the date / time of day and then the Y-axis showing that the Event occurred. (Even a plot or bubble chart showing when each Event occurred).
The business wants to identify if these Events are occurring at random intervals throughout the time of day or in close groups during specific times.
Here's my core sample data set:
My dilemma is that all of the WebI Charts are looking for measures, but this is a date/time dimension which is stored on the record when the Event occurs. I've tried converting the time to a Measure in the Universe, but Webi still ignores it and will not let me use it as a value in the Charts. (I converted my Event Time to a Measure of Data Type 'DateTime' w/ Projection Function 'None'.)
I'm using WebI Version 4.1 SP6 Patch 2
Any suggestions would be much appreciated!
Thank You & Regards, A. Cook
Didier MAZOUE replied
In that case, the best is to create a crosstab (rather than a chart) to display all events.
You need to create a variable to create a measure for each couple (date, event) like this:
- "Value": =1 ForEach ([Date];[Event])
You also need to create a variable special character to mimic a chart in the crosstab like this:
- "Value_Chart": =If (Value = 1) Then "█"
More information about the usage of mini-charts inn tables in this document: http://scn.sap.com/docs/DOC-71192
If you also want to save place you can turn the labels of the event (or date) vertically.
More information about that trick in that document: http://scn.sap.com/docs/DOC-71667
Now your report will look like this:
I attached the Webi document (to be renamed).