You might use pages to drill-down in your data, starting with an overall summary sheet and then going into more specific details in subsequent sheets. They’re useful and simple to implement in Data Studio. Pages allow you to display multiple dashboard reports in a single Data Studio report. In this post I’m going to dive a little deeper into the tool and look at 6 techniques to master for creating dashboard reports using this tool: 6 advanced tips for working with Google Data Studio I wrote an introduction to the tool earlier this year, so that’s a good place to start if you want to find out more about it. It’s only in beta version at the moment and new features and customization options get added pretty rapidly, so it will be interesting to see where Google take this product. Here are two example reports for a mid-size website (~500k pageviews a month).Īnd second, a social media referral dashboard: It’s a great option for small/medium businesses already using Google tools, who want to build bespoke dashboards for that 40,000ft view of their business. It’s a really smart reporting tool for quickly creating powerful, stunning dashboards from multiple Google data sources. This solution has the advantage of being easy to read, flexible, and relatively easy to adjust as needed.Google launched a new business intelligence tool called Data Studio in May 2016. WHEN Subtotal > Medium Order THEN Subtotal * Medium Order Discountįor this solution, we've created separate fields to hold values for large and medium sized orders and corresponding discounts. WHEN Subtotal > Large Order THEN Subtotal * Large Order Discount It keeps the main logic in a single field, while breaking out some of the dependent logic into separate fields: This solution blends the 2 approaches described above. For example, say you had 10 product tiers with different order quantity thresholds? Or say you wanted to use the same discounts for a different product line? In these cases, it might be easier or more efficient to use separate fields for those thresholds and discounts. But you also might have to do a lot of repetitive typing, and a complex formula may be harder to extend or maintain. On the other hand, centralizing all the logic into one field can make simple formulas easier to understand and edit. One drawback to creating formulas with lots of discrete calculated fields is that it may not be obvious what each one does, so you'll need to edit them individually to see how they are calculated or make changes. For example, using a separate field for the discount rate lets you use that field in other calculations or display it in your reports. Separate fields can also be useful in more contexts. There are pros and cons to each approach:īreaking down complex formulas into separate fields can make your formulas easier to read and write, and less error-prone. WHEN Price * Qty Sold > 100 THEN (Price * Qty Sold) *. WHEN Price * Qty Sold > 499 THEN (Price * Qty Sold) *. For example, you could combine steps 3 - 5 of this tutorial into one field: The solution above breaks the problem up into individual chunks and create discrete fields to handle each chunk, as you've done with the Subtotal, Discount, and Total fields.Īnother approach is to perform all of the calculations in a single calculated field. On the right, drag each calculated field you created from the Available Fields list to the dimension and metrics section of the Data panel, as shown below:.You can now add your new calculated fields to charts: On the right close the manage data sources panel.After saving the Department field, on the left, return to the data source editor by clicking ALL FIELDS.apply a discount to orders over a certain amount.calculate the total value of each order.In this exercise, you'll use calculated fields to: Here's a simple example: SKUĬalculated fields in Looker Studio can help you manipulate and extend this data. You might measure sales data, such product codes (SKU), item names, price, and quantity sold. Suppose you manage an online pet supply store. Learn different approaches to implementing calculated fields.Create a conditional expression to evaluate your data and return different results.Learn how to create a simple arithmetic calculated field.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |