DE 2.0 Dashboard filters

Comments

5 comments

  • Avatar
    Alexandra Dunne

    Hi Jasmin Bird,

    I spoke to the team and they mentioned the filter should allow you to add two different groups. Could you provide us with some screenshots so we can understand the issue better? 

    Thank you,

    Alex

    0
    Comment actions Permalink
  • Avatar
    Jasmin Bird

    Hi Alex,

    I am able to add 2 different groups however we use our Groups for location areas and programs. In DE 1.0 I would choose to filter by 2 groups, one for location and one for program, so I could see all the clients who lives in the town AND had services funded through CHSP. However now it will only show me client who have either filter. It means I'm get say 300 results instead of 20. I've added a screen shot of the filter.

    0
    Comment actions Permalink
  • Avatar
    Alexandra Dunne

    Thanks Jasmin, 

    I've passed this along to the team and I hope to have an answer for you soon.

    Alex

    0
    Comment actions Permalink
  • Avatar
    Will Hallahan

    We restructured our data because DE 2.0 makes reporting on Form Context fields easy.  We created different Form Context fields for the different group types eg:

    • record type (facility or individual)
    • facility type (RACF, TCP, prison etc)
    • geographic region (metro-wide, South, North etc)
    • funding source (Base contract or other etc)
    • etc.

    We had the same problem as you before, when we used Groups fields to record these metrics on setting up a new client.  The only way to get it sorted before our data restructure was to use 'Merge Query' in DE 2.0.  We would filter on the geography (eg East) to create a primary table, then create a secondary query to pull out the other elements (eg facility type).  This worked, but it was complicated, and I never quite trusted it as a solution.

     

    Good luck

     

    Will

    MPaCCS

    0
    Comment actions Permalink
  • Avatar
    Will Hallahan

    PS I don't think Looker permits an 'AND' operand in a query (might be wrong), and you can't add the same field twice to the filter panel (which would have the same effect as 'AND').

     

    W

    0
    Comment actions Permalink

Please sign in to leave a comment.