From the course: Build a No-Code ETL Pipeline with Google BigQuery

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Calculated fields

Calculated fields - BigQuery Tutorial

From the course: Build a No-Code ETL Pipeline with Google BigQuery

Start my 1-month free trial Buy for my team

Calculated fields

“

- [Instructor] I would like to add another chart over here, but you can see that I've already run out of space. Luckily, there's a way to fix this. So I can go here and select Theme and Layout. Here I get some general options for the whole report regarding the theme of the report, in other words, the general look and the layout. And what I'm interested in here is the canvas size. You can see that I have a certain width and height in pixels, and I can go to the height value and turn it up to 3000. And when I scroll down, you can see that now my canvas has a lot more room. Here I have written the next metric that I would like to visualize, which is the average daily turnover by brand. So what does this mean? Any day, a stock will have a specific price, and it will also have a specific volume. And the volume represents how many units of that stock were traded during that day, how many units of stock changed hands during that day. If you take the price and you multiply by the volume, you…

Contents