Browsing Kyvos semantic models in Looker
Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
On the Project page click the inverted triangle option and choose the view that you want to browse.
You are redirected to the Explore page, where you can browse the Kyvos semantic model.
Applying filters on data
On the Explore page, click the Filter tab corresponding to the measure or dimension on which you want to filter data.
Choose the filter condition that you want to apply.
Click Run.
Important
The data shown in an Explore is determined by the dimensions and measures you select from the field picker at the left. A dimension can be thought of as a group or bucket of data. A measure is the information about that bucket of data. In Looker, dimensions appear as blue columns, and measures appear as orange columns in your data table. Also, the worksheets created here are called a Look.
List of Measure and Dimension filters available in Looker
Measure filters:
Equal to
Less than
Greater than
Greater than or equal to
Less than or equal to
In between
Is null
Is not null
Is not between
Is not null
Dimension Filters:
Data Type: DATE
Is in the past
Is on the day
Is in range
Is before
Is on or after
Is in the year
Is null
Is any time
Is not null
Data Type: String
Is equal
Contains
Starts with
End with
Is blank
Is null
Is not equal to
Doesn’t contain
Doesn’t start with
Doesn’t end with
Is not blank
Data Type: Number
Is equal
Is greater than
Is greater than or equal to
Is less than
Less than or equal to
Is between
Is null
Working with Looker Dashboard
A Looker dashboard is a collection of queries displayed as visualizations on a page. Dashboards let you combine key queries and visualizations into a one-page executive view. You can add filters to make the dashboard interactive and rearrange its tiles.
On the Looker home page, click New > Dashboard.
Provide a Name for the Dashboard, and click the Create Dashboard button. By default, the new dashboard is saved to your <user> folder.
Select Add looks to add a look or select New Tile.
Select the Looks that you want to add to your dashboard, and click Update Dashboard.
The dashboard is created. The following figure shows a sample dashboard.
Points to remember
Looker does not support TopN.
The pivot option in the Explore screen does not work with Kyvos.
Space within measure name cannot be used while defining a measure in the view.
Copyright Kyvos, Inc. All rights reserved.