About Wiktor_Jurek

Wiktor_Jurek · 03-15-2024

EDIT: I've figured out how I could do this using operations within Dataform. Article here.Hi everyone,I have a data asset that needs to be computed every day (hencewhy I'm using dataform - it's a great tool), but I've come across a limitation. The co...

Wiktor_Jurek · 07-31-2023

Hey All,Jamboard will stop receiving automatic updates next year, so we're gearing towards replacing our office Jamboard with the much improved Board 65 by Avocor. One thing that surprised me when watching the demos is that the B65 still uses the Jam...

Wiktor_Jurek · 07-11-2022

EDIT: It's been confirmed by the devs that when using SQL-based table sources, it is impossible to choose what image storage provider you want to use outside of GCP or Amazon buckets. This means you are locked into the cloud provider your account is ...

Wiktor_Jurek · 01-19-2022

Hi, I have three tables, and I’m trying to create a view “My Jobs” Jobs Employees Tasks I have an issue creating a slice that only shows jobs that an employee is a part of. A job should only be shown in the view/slice if: In the related tasks for tha...

Wiktor_Jurek · 11-08-2021

Hey folks, I have two tables: employees, and tasks. I basically want to have a view that summarises the capacities of each employee, by week, based on the tasks that they have assigned to them. This is very easily done using a pivot table in sheets H...

Wiktor_Jurek

Unfortunately, you have to re-create the table. This is a limitation.

Wiktor_Jurek

I've not come up with a macro for it, but a workaround is using an operation within a .sqlx file. I've written an article about how this could be achieved. Feedback welcome!

Wiktor_Jurek

I know that this is something that comes up quite often - especially around migrating two separate Google Workspace domains into a single one. I've compiled a wee writeup here about what kind of strategies you could use to do this.

Wiktor_Jurek · 03-22-2024

It's standard pivot functionality just as you would use in a spreadsheet. This is how dbt have implemented it.It's changing a tall data table into a wide data table based upon a dimension column and an aggregation of metrics columns. The EXECUTE IMME...

Wiktor_Jurek · 03-15-2024

Hey, not to flame, but your response seems very GPT-like. Let's deconstruct your suggestions:"Predefined Pivots for Predictable Columns"This suggestion isn't sustainable due to the dynamic nature of one of the columns. The pivot needs to be dynamic. ...

My Stats

kmal14's Bio

Badges Wiktor_Jurek Earned

Recent Activity

Pivot data in Dataform with EXECUTE IMMEDIATE statements

What happened to play.space?

Change default object store to Sharepoint

Problem creating slice from referenced tables

Pivot table aggregation using AppSheet

Re: Updating selected range for a BigQuery Table connected to a Google Spreadsheet

Re: Pivot Macro for Dataform

Re: How to merge 2 Google Workspace but 2 domain still separate

Re: Pivot Macro for Dataform

Re: Using Dataform with EXECUTE IMMEDIATE statemetsn