Data Analysis Learning Resources

Embedded Looker: Looker - Clarity Human Services Integration

Standalone vs Embedded Looker

In order to provide a cost effective alternative to a standalone Looker license, Bitfocus offers a Clarity Human Services embedded version that can be made available to more users at a reduced cost. The following is a summary of what is available with both types of licenses.

 

Standalone

Embedded

Viewing pre-saved content ✔️ ✔️
Ad-hoc data pulls ✔️

✔️

Create looks from all data models ✔️

✔️
(except Coordinated Entry Model)

Create dashboards ✔️
Content management creating new folders, moving, copying, making public, deleting content) ✔️
Scheduling / Send content delivery ✔️  ❌
Access to Looker API ✔️

Accessing Embedded Looker

To access "Embedded Looker" you must have Data Analysis enabled in your access role. See Rights Glossary for Access Roles for information about the different Data Analysis rights. 

To access "Embedded Looker," click the Launchpad and navigate to REPORTS > EXPLORE

Next, choose a Data Model.


Search and select the fields you want to include in the Look from the left column. When a field is selected it will be highlighted in the left column and appear in the DATA section of the screen.

 

 

Filters can be added to refine data sets by clicking Filter next to the field and selecting the appropriate filter in the Filters section. Pivoting fields by selecting the Pivot button next to the field can be useful to make data easier to understand. 

When the Look is complete, click Save Look. 

Moving Between Embedded and Standalone Looker

When you access Looker through Clarity Human Services, you are using a different Looker license. If you go back and forth between Clarity Human Services and Looker, you will notice problems running Looks in Looker.

  • Log out and then log back into Looker to restore access. 
  • If there is a problem in Clarity Human Services, navigate away from the Report area and then navigate back in to restore functionality.

Sharing Looks in Embedded Looker

To enable a Look in Embedded Looker that was saved in Standalone Looker: 

    1. In Standalone Looker, share the Look to your community's Looker Shared Space or agency space. (The agency spaces are identified by the Project ID number.) 
      Important: Do not change the name of the Shared Space.

    2. Update Clarity Human Services with the latest reports from Looker:
      1. Click the Launchpad.
      2. Navigate  to SETUP > SETTINGS > Data Analysis.
      3. Click the REFRESH DATA ANALYSIS link. 
    3. Enable the report: 
      1. Click the Launchpad.
      2. Navigate to SETUP > SETTINGS > Data Analysis > [Agency Name] Reports. You'll see the complete listing of reports in the Looker Shared Space. Note: Users will only see folders for the agencies they have access to.
      3. Turn on the toggle for the report.
      4. Click SAVE CHANGES.

    Note: As users save Looks through Clarity Human Services, the saved Look will automatically be enabled. 


    Built In Reports

    Built In Reports (LookML Dashboards) will need to be enabled using the same method above. The LookML Dashboards can be found in the Built In Reports folder and need to be toggled on to be accessible from embedded Looker.  To learn more about Clarity Human Services' Dashboard Library, please review our dashboard articles


    Hyperlinks in Embedded Dashboards

    Dashboards may include hyperlinks to other dashboards. To make this work:

    • Save dashboards to link to the embedded folder, as shown above
    • From Clarity, run the dashboard to link and copy the URL
    • Use the Clarity embedded dashboard URL for the link in the main dashboard

    Removing Looks in Embedded Looker

    To remove a Look or dashboard:

    • Standalone Looker Users
      • Sign into agency folder in Stand Alone Looker.
        • Select the ellipses (three dots) and "Move to Trash."
      • Sign in to Clarity.
        • Select the Launchpad > SETUP > SETTINGS > Data Analysis.
        • Turn off the toggle for the deleted Look. 
      • Select the Launchpad > SETUP > SETTINGS > Data Analysis
        • Click the REFRESH DATA ANALYSIS link.
      • Note: Every 30 days Looker will remove Looks from trash.
    • Embedded Communities Only
      • Send in a Help Desk ticket to delete the Look.
      • In Clarity, select the Launchpad > SETUP > SETTINGS > Data Analysis
        • Click the REFRESH DATA ANALYSIS link.
      • Note: Every 30 days Looker will remove Looks from trash.

    Updated: 05/13/2024