Forum Discussion

ChristineK's avatar
ChristineK
Qrew Captain
5 months ago

Absolutely maddening reporting requirements, I think I'm almost there though - help!

Hi all! A daunting task I've put off forever is here. I need to build some dimensional reporting.  Here's what I need to do: Extrapolate the following: Total individual clients served within a qua...
reports
Jeff_Richey's avatar
Jeff_Richey
Qrew Cadet
5 months ago

Hi Christine,

Have you attempted to use filters in the summary report to exclude records with null values? Your screenshot does not include how your filters are configured.

  • ChristineK's avatar
    ChristineK
    Qrew Captain
    5 months ago

    Thanks, Jeff!

    I had been thinking it'd be lovely if that's possible on the summary table level somehow, on the summarized row itself because each will be different, but I suspect it's not.

    I ultimately will need to bring in the following, and "null" across any of these (all different areas) need to just be filtered out so that null isn't a distinct count:

    • These 4 fields right from the Interactions table
    • 11 fields from rom grandparent Client table:
      • Client age group
      • Race
      • Gender
      • If "other" on gender, the brief detail needs to come down where i can get that detail
      • Special classifications (Several fields: Deaf/HOH, Homeless, Immigrants, LGBTQ, Veterans, Cognitive Disabilities, Limited English Proficiency)
    • 26 Victimization Type fields from the parent "Cases" table, including two fields with a detail