I am trying to build a Business Objects report that breaks daily data into 1 hour sections.
I have the measure I want to add to a cross tab but I cannot figure out a good way of splitting time data up into hours throughout the day.
I have tried formatting the date/time object into SHORT_TIME...
I am trying to plot a trend line onto a line graph in Business Objects. I have hunted high and low and I cannot seem to find a BO function that does this.
My data is pretty simple but I cannot figure out how to do this, my data table is in the format below:
Date [Measure]
01/01 0
02/02...
I am trying to add a column to a table which shows the daily variance from the previous day.
My table looks something like this:
Measure
Date1 5
Date2 2
Date3 9
Date4 7
I would like to add another column showing the variance from the previous day like this:
Measure Variance
Date1 5 5...
I have a crosstab in BO and I wish to select the Top 3 values from the measure in the table. I have tried using the rank function but this does not work.
My crosstab looks something like this:
Name A B C D
Date
01/01 10 8 2
02/01 7
03/01 1 9 6 2
I know I need to use the ‘rank’ formula...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.