Hey everyone,
not entirely sure if this belongs here or to "Framework Manager", but I think this end might be the right one.
I want to compare a value (totalcpu) in an Active Report in a list with the average (of the last 30 days) of that value avgtotalcpu). One requirement for the list is to only show the last 2 days so I have a filter in it saying "[Starttimestamp] >= _add_days(current_date; -30)".
My problem is how to set up the quary subject / data element / whatever "avgtotalcpu" so the filter mentioned above will not "overwrite" the internal filter of "[Starttimestamp] >= _add_days(current_date; -2)" from "avgtotalcpu", any ideas how to solve this problem in Cognos 11?
Kind regards,
Marvin