Eduardo
Ido (Ploomber)
Laura Gutierrez Funderburk
05/03/2023, 6:02 PMJess Mankewitz (they/she)
05/26/2023, 5:07 PMDwayne McMurchy
09/08/2023, 2:31 AMEduardo
Eduardo
Jochem
11/22/2023, 3:35 PMDwayne McMurchy
11/24/2023, 5:28 PM%sqlcmd explorer
Binder link is broken. Page reference: https://jupysql.ploomber.io/en/latest/user-guide/table_explorer.htmlDwayne McMurchy
11/26/2023, 3:00 AM%sql PIVOT Cities ON Year USING SUM(Population);
but using the DuckDB API does? Pivot duckdb example is from here.
ThxDwayne McMurchy
11/30/2023, 5:26 PMLaura Gutierrez Funderburk
12/01/2023, 5:09 PMEduardo
Butho Moyo
01/25/2024, 5:45 AMCY = Max(myCalendar["FY"])
.
My fiscal year runs from July to June of the preceding year. In the table myCalendar, FY is defined as
FY = "FY" &
if('myCalendar'[Month_Num]<7,'myCalendar'[Year]-1 &"-"& 'myCalendar'[Year],'myCalendar'[Year] &"-"& 'myCalendar'[Year]+1)
This gives me a text output, for example,FY2023-2024
and that is exactly what I want.
However, I am trying to define a measure, LY, that gives me the last fiscal year, for example,FY2022-2023
. I tried using the sameperiodlastyear function, but it didn't work. Any ideas would be appreciated.Laura Gutierrez Funderburk
01/30/2024, 12:52 AMLaura Gutierrez Funderburk
01/31/2024, 6:01 PMLaura Gutierrez Funderburk
02/05/2024, 10:23 PMLaura Gutierrez Funderburk
02/05/2024, 10:28 PMLaura Gutierrez Funderburk
02/12/2024, 7:07 AMLaura Gutierrez Funderburk
02/12/2024, 7:28 AMMarcelo Ramires
03/26/2024, 1:37 AMarky
05/27/2024, 7:27 AM137 on gnu/Linux
Marcin Gierdalski
06/10/2024, 10:20 PMploomber build
until it works as intended. How should I go about running it in isolation as a proper notebook in VSC or jupyter, and still having benefits of the information in upstream = [ 'get', ...]
preamble and perhaps in pipeline.yaml
and env.yaml
? I could add some shim code to inject desired inputs into upstream
, only to excise it later, when not needed anymore, but I'm hoping you guys could suggest a tried and proved pattern...Parash Shah
06/16/2024, 4:26 PMParash Shah
06/16/2024, 4:26 PMgordon
06/22/2024, 11:11 AMPhoebus Giannopoulos
06/22/2024, 6:36 PMPhoebus Giannopoulos
06/22/2024, 6:37 PM