Hi,
new with Cognos.
Trying to create a list with the number of alarms, grouped by severity, that were generated in a period of time.
I'm trying to modify a chart that offers it, to have all numbers in a table, but not able to do it.
Row: Severity
Column: Month/Day
cell: alarm's count
Any suggestion please?
sure it is very easy for all of you ;)
Row AND Column would suggest that you want to build a crosstab , rather then a list. If that is what you are after, then copy the query , drag a crosstab to a report page , associate it with the copied query and drag Severity to the rows, Month/day to the columns and put alarm's count in the body..
Thanks for reply.
But what should the query contain? i'm trying to add a Count by column :-(
I'm not following you.. An aggregate is performed in the context of non-aggregates. If you define a measure count([Alarm]) and bring in severity and time dimension attributes day and month then you will automatically have output of the query as count(alarm) by severity,month,day