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