Search results for query: *

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...

Thank you

Thanks Steve, I have split this into two new measures for simplicity, the first being the last 3 average using: =Average(Previous(previous([measure]))) And I generated another variable: =previous([measure]) + [measure]) But when I create another variable adding the two of them I get results...

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...

Many thanks indeed, that works perfectly. I didnt use the 'Variance' function in the end and just used the 'Previous' function which I wasn't previously aware of.

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...

Point taken... Once Blom0344 pointed out the crosstab columns were not independent (Thanks Blom!) I realised I needed to create a new measure which ranked the original measure in my crosstab. Using the variable editor I added the formula =Rank([measure];[Name];[Date]) I then applied a filter...

I managed to do this by creating a new measure 'rank' using the rank formula. many thanks for your suggestions.

Basically the report is lots of pages. I want just the name columns with the top 3 results for each date, all other results filtered out. Thanks for your help

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...