Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Business Intelligence with Looker Cookbook

You're reading from   Business Intelligence with Looker Cookbook Create BI solutions and data applications to explore and share insights in real time

Arrow left icon
Product type Paperback
Published in May 2024
Publisher Packt
ISBN-13 9781800560956
Length 256 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Khrystyna Grynko Khrystyna Grynko
Author Profile Icon Khrystyna Grynko
Khrystyna Grynko
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Chapter 1: Getting Started with Looker 2. Chapter 2: Configuring Views and Models in a LookML Project FREE CHAPTER 3. Chapter 3: Working with Data in Explores 4. Chapter 4: Customizing and Serving Dashboards 5. Chapter 5: Making Dashboards Interactive through Dynamic Elements 6. Chapter 6: Troubleshooting Looker 7. Chapter 7: Integrating Looker with Other Applications 8. Chapter 8: Organizing the Looker Environment 9. Chapter 9: Administering and Monitoring Looker 10. Chapter 10: Preparing to Develop Looker Applications 11. Index 12. Other Books You May Enjoy

Custom fields

If the existing dimensions and measures are not enough for Explore users (Standard users/Creators), they can easily create their custom fields.

Note that custom fields offer temporary, Explore-specific calculations with limited reusability, while LookML provides permanent, model-wide definitions for reusable and governed metrics.

There are multiple ways to create custom fields , and we will go through them in this section. We’ll continue working in the Orders and Users Explore.

If necessary, you can always prevent users from creating custom fields in Explores (creating custom fields requires the "create_custom_fields" permission assigned by your Looker admin).

How to do it...

To create a custom field, let’s do the following:

  1. Click on the Custom Field section on the left of the Explore environment.
  2. Click +Add, and you will see three available options – Custom Dimension, Custom Measure, and Table Calculation. Custom...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime