AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Looker calculations subtract dates4/23/2024 ![]() ![]() ![]() We all have a hypothetical of what will happen next month for our subscribers & MRR, but using a parameter you can influence how that changes your actual MRR projections. View the Journey Calculator – you define the inputs for the funnel & the output is a beautiful funnel to define what you are trying to accomplish. View the text stripper – You can input anything you would like on the left-hand side, then it runs a formula using that input field. The following are real examples I’ve used parameters for. Use that user defined field in functions & formulas.You can set a default value for them on report load.Create a place for a user to input information.Parameters is definitely a more advanced Looker Studio feature. That might have been quite a lot, but I hope it made some semblance of sense! Parameters – Start Touching The Dataĭimension Group (Names), Metrics Report (numbers), Then Parameters Touch (User Input) This just created a new Metric within the data source! that will count the number of unique regions We want to utilize the function of “Count_Distinct()” Count_distinct(regions) Take a look at the Looker Studio Functions List We will need to count the number of regions per country. Let’s say you want to have a table which was answering the question of “How many users do we have per Country and how many Regions within those countries are contributing users?” The most powerful part of Looker Studio is the ease of applying formulas to create new fields. You can see that the Dimension of Country is grouping all of the metrics into its Group.ĭownload The FREE Cheat Sheet Applying Formulas to Dimensions Let’s say you wanted to know the number of users by country? Like the following image In the above examples you will see that the dimension is indeed text which math cannot be applied to but groups other metrics together. 24 Ways to improve your fitness in 2022.Dimension Examplesĩ9% of the time a dimension is text field which groups metrics together. You will spend most of your time working with dimensions as they are how you assign a “group” to the values you want to see. YOU NOW HAVE A NEW METRIC! Dimensions Are “Groups of Data” If you count the number of metrics using a count_distinct formula. □ Dimensions turn into metrics once you apply a formula to them. I want to take a moment and say “That’s OK!” you will slowly add common functions to your tool kit, as you need them.** THE MOST IMPORTANT THING TO NOTE ABOUT METRICS **You might be looking at your data right now and seeing these functions as a wild leap from where you currently are. Sum being the most widely used within the metrics The functions within Looker Studio are about the same as within Google Sheets. Running Calculation – Running Max (see below). ![]() You want to know the highest the value ever got?.You wanted to know the “Percent of Total” users broken down by a different dimension.Metrics – Auto CalculationsĪt the time of writing this (Hello from the past□□) there are Comparison Calculations & Running Calculations which you can apply to your metrics. Hint: A lot of Metric formulas carry over from Google Sheets Metric Examples:Īll of these are Metrics as you can add them together & are numeric. You can add, subtract, multiply and divide with metrics right within the Looker Studio platform. The easiest way to think of Looker Studio Metrics is that Metrics you can do math with. Now we will hop into each of those with Gusto □□. Parameters are Purple – They allow user input & influence other data The Quick & Dirty of Metrics, Dimensions & Parameters:ĭimensions are Green – They group metrics together Regardless of your data source: Facebook, Google, Amazon, Big Query, or the latest NFT platform you will only have three types of data metrics, dimensions, & parameters. ![]()
0 Comments
Read More
Leave a Reply. |