Alarm count

[mosemont]

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  ;)

[blom0344]

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

[mosemont]

Thanks for reply.
But what should the query contain? i'm trying to add a Count by column :-(

[blom0344]

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