Grouping results in table views

Answered

Comments

4 comments

  • Official comment
    Avatar
    David Sallusti

    Hi Travis,

     

    1. You can add the Client full name, Service Code, Visit distinct count to the report

    Search for visit start date or Month (This example shows the filter using visit start date)

    Use the Matches (Advanced) filtering option and simply use "last month" as seen on picture above.

     

    This will show the results in picture above.

     

    You can also look at this page for other advanced filtering options that may suit your needs.

    https://docs.looker.com/reference/filter-expressions?version=21.8

     

     

     

    Comment actions Permalink
  • Avatar
    David Sallusti

    EXTRA

    If you want to take it a step further, you can then add a PIVOT using Month Name, here is the result:

    Step one - Look for Month Name, select the PIVOT option.

     

    Results:

     

    0
    Comment actions Permalink
  • Avatar
    Will Hallahan

    I did the pivot and it worked!

    0
    Comment actions Permalink
  • Avatar
    Travis Tolhurst

    Thanks, David. :)

    0
    Comment actions Permalink

Please sign in to leave a comment.