Post reply

Matrix Group on values in separate table

  • May 10, 2011 at 2:58 am

    #389488

    Does anyone know if it is possible to build a matrix report where the group by column values are pulled from a separate table?

    I have a list of incidents I am reporting on and they have a type code. I don't want the table columns restricted to those which have occurred in the listed set of incidents. I want them to always refer to the values in a separate lookup table.

    I.E

    Building IncidentType1 IncidentType2 ..

    1 34(count) 23(count)

    2 21(count) 45(count)

    I want IncidentType1 and IncidentType2 columns to always be present.

    Thanks

    Matt

  • May 11, 2011 at 10:40 am

    #1323228

    Separate table, no. The way to handle this is to pull that separate table into your dataset query.

  • May 12, 2011 at 1:32 am

    #1323504

    Thanks for the reply. I like that approach, ie including all the possible incident types, say with a left join in the query. What I can't get my head around however, is how to maintain consistent counts, if some of the rows aren't incidents at all but rows from the left join and purely standing data.

    I have got round the problem now by doing all the counts in a query, but it seems silly not to be able to use the aggregation functionality of the reports themselves. :ermm:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply