Here’s an example of adding a calculat! field with basic arithmetic calculations. Let’s say you ne! to analyze how the ratio of new to existing users has chang! compar! to the previous year.
- Click the “Create new field” button – a console will appear on the screen where you can enter the name, field type and formula. Name the field “New user rate”. To calculate, the number of new users must be divid! by the number of all users.
- Click Apply. You will get an additional column with a new parameter
To see the data as a percentage, change the calculat! field’s data type to Percentage Click Apply
To compare metrics with the previous gambling database period or year, open the Date Range for Comparison section in the right pane and select one of the options: Previous Period, Fix! Dates, or Previous Year, depending on your analysis goals.
After this, new columns will appear in the table, displaying changes in each indicator compar! to the select! period.
Using the lower text function
When analyzing campaign data, you may what are the seller benefits of lazcoin encounter a problem with different spellings of campaign names – some are written in lower case, others in upper case.
To make the names consistent, you can create an additional parameter using calculat! fields, using the lower function, which converts all names to lower case.
Instead of “Campaign” you can substitute any value that ne!s to be convert! to lowercase.
To avoid duplicate values, remove the “Campaign” parameter in the settings panel and leave only the add! “Campaigns in lowercase” parameter.
Regular expressions in calculat! field functions
For professionals who actively use europe email regular expressions in their work with data, the ability to use them in Looker Studio will be a valuable tool.
The functionality is bas! on several support! functions:
- regexp_extract — allows you to extract from a field a part of the value that matches a specifi! regular expression;
- regexp_match – returns true if the field value matches the specifi! regular expression, and false if it does not;
- regexp_replace – replaces all values corresponding to the specifi! field with the one specifi! in the function;
- regexp_contains – similar to regexp_match, but the difference is that regexp_match by default matches the entire value, while regexp_contains can search for part of the value.
Let me look at an example. It is necessary to analyze what users search for on the site using the internal search. First, you should filter the data by the parameters contain! in the URL of the internal search results pages (in our example, search=). The filter can be add! in the right panel of the table settings, in the “Data” section. The filter settings will look like this.