Welcome to another edition of “What’s New in Looker?”, a blog post aimed at making you say things like, “Whoa, I had no idea I could do that with Looker!”
This post focuses on new product features of dashboards, Looks, and Explores (we’ll leave the coding to the developers.)
Today I’d like to re-introduce you to an old friend: the table chart.
No, your eyes do not deceive you. You can now add header and text formatting, data bars, and more right within Looker. Exporting your data to customize tables is so last year.
Let’s experiment with these new features, shall we?
Change the text color, background color, formatting (such as bolding and italics), and alignment of the text in any of your data series from the Series option menu.
Give it a try with the table linked below. See if you can make the Brand column text bold by opening the Edit menu, selecting the Series tab, opening the toggle for Products Brand, and clicking the B icon.
Add data bars for a little visual spice that will make your numbers easier to compare.
The Total Number of Orders column is a great candidate for this feature. Add data bars in the Series tab by opening the Order Items Order Count series and clicking the Bars toggle.
This table chart is coming along nicely. Put the last polish on by adding a background color to the header row. You can do this in the Formatting tab by clicking the paint bucket icon in the Header options and choosing a color. Give it a shot.
The final result will look something like this:
Compare this with our original, plain table.
Just those three modifications made a dramatic improvement to the table’s readability. But I promised you could do more than that with these new table charts, so let’s keep going.
Get a different perspective on your table charts with your newfound ability to transpose. This changes the orientation of the data by swapping the positions of your columns and rows.
Try it out for yourself. Click the Transpose toggle in the Plot tab to see in action.
Your result will look similar to this:
If you find that you now have some column names that aren’t fully displayed, you can manually adjust their width by dragging the edges.
That’s right: adding subtotals to your table charts is now a table-calculation-free process. Hooray! Just click the Subtotals checkbox at the bottom of your visualization and then hit the Run button. The option appears when you have two or more dimensions. In this case, my dimensions are State and Zip.
Subtotals account for all but the rightmost dimension. To change what gets included in your subtotals, move your columns by clicking and dragging them around.
That’s all for today. If you’re hungry for more information about table charts, check out our documentation page to see everything you can do with them.
Until next time,
Content Strategist, Customer Experience
Welcome to “What’s New in Looker?”, a blog post aimed at making you say things like, “Whoa, I had no idea I could do that with Looker!”
This post focuses on new product features of dashboards, Looks, and Explores. We’ll leave the coding to the developers.
I have two great things to share with you today.
Get notified of important changes in your data as soon as they happen with Conditional Alerts. Set the alert conditions yourself or subscribe to an alert someone else made. Either way, you’ll be in the know.
For example, as a customer success manager, you can elect to be notified when your customer’s month-over-month product usage drops by 25%.
If you manage an inventory, you can receive notifications when your average shipping time rises above a certain threshold so that you can investigate what’s causing the holdup.
To set up an alert, hover your cursor over the dashboard tile you want to make the alert for. Click the bell icon in the upper right corner.
Fill out the dialog box that pops up according to your preferences.
In this example, if the “Average Days to Process” value changes to something above 3.4, I’ll get an alert in my inbox every day at 5 a.m. until it falls below 3.4 again.
Click Create Alert to finish.
If you want to subscribe to an alert someone else has created... do it! Tiles with existing alerts display a number over the bell icon. Click it to open the alert pop-up.
Click Follow on the window that appears next. You’ll get on the recipient list like a nice fall breeze goes through an open front door... effortlessly.
Which data changes are most important to you and your team? Think over your favorite dashboards and consider creating an alert using this new Looker product feature today.
Apply conditional formatting to a single value visualization, and you’ll know how your metric is performing at a glance.
In the example below, the number will display in red if the customer health score is below 50. If it’s above 70 (that is, worthy of a celebration dance), the metric will display in green.
To apply conditional formatting to a single value visualization, edit the tile.
Select the Formatting tab and click the Enable Conditional Formatting toggle.
Set your rules. In this example, if the number of open orders is more than 1000, the value will appear in orange.
And that’s it!
If you want to get creative, you can even use conditional alerts and conditional formatting in tandem. You can set up the value to go through a series of color changes, and send an alert when it hits the final color threshold.
It will be like a pressure gauge on a hot water heater with a warning alarm — except for your data!
Have any feedback or questions? Get in touch via the Community discussion on Exploring.
Until next time,
Content Strategist, Customer Experience