Total for last hour

[RGascoigne]

Hi Cognos Guru's,

I am creating a dashboard and want to show total Quantity achieved in the last hour.  I can't find a way to show do I get data from the last hour when refreshing the dashboard?  Any suggestions?

Thanks,

Rob

[New_Guy]

Hi,
Do you have a time or date column in the dashboard object? if you have a column with a time then you can add filter on that column as [Time and date column] = _add_hours(current_timestamp,-1). Try it and let us know if this hepls. You might have to tweak it as per the formats you have with your data.
Good luck
New guy

[RGascoigne]

I have [DATE_TIME_STAMP]

Put the below in

[DATE_TIME_STAMP] = _add_hours (current_time , -1)

Tired in Detail filters and summery filters.

This returned  a few error when Validating.

UDA-QOS-0006 Error
UDA-SQL-0460 A general exception has occurred during local processing
UDA-EE-0094 The operation "equal" is invalid for the following combination of data types of data types: "timestamp2" and "timeTZ"

[Invisi]

I have something similar with date types. Which database do you have for your underlying data warehouse?

[New_Guy]

Hi,
We have to use between for this situation. [Date Time Column] between current_timestamp and _add_hours (current_timestamp , -1). Can you post a screen shot of your time column? In some cases you have to create data items for current and current - 1 hr and then you can use them in the filter condition.
Good luck
New guy