ggenovese Coach

• Activity
• Posts4
• Comments138

• Re: Pagination issue with JSON No Code Connector (API PennyLane)

  ggenovese

  March 12
  Hi @Makam - I reviewed the documentation for that API and I see that the "List Ledger Entries" and "List Ledger Entry Lines of a Ledger Entry" endpoints use a page based paginatio…
  1

• Re: Python Tile fillna on integer column keep return 0 unless I change the column to text

  ggenovese

  February 12
  I did some digging around and apparently Pandas has two Integer Data Types: int64: The standard integer type in pandas for 64-bit signed integers. Nullable Integer Type (Int64): This is a special dat…
  1

• Re: Replicate Spreadsheet P&L in Domo

  ggenovese

  January 31
  If you add a row number column in your ETL you can use it to place a blank row between two other rows. For example, if I want a blank between Revenue and Wages I could assign a row number between the…
  2

• Re: How to show a grouped Column with a CASE logic

  ggenovese

  January 30
  Can you give this a try? SUM( CASE WHEN amCollectorPrice > 1 AND nmOrganizer IN ( 'Live Nation 2 s.r.l.' , 'Live Nation 3 s.r.l.' , 'Live Nation 6 s.r.l.' , 'Live Nation Italia s.r.l' ,'Comcerto S…
  1

• Re: beast mode

  ggenovese

  December 2024
  If I am understanding correctly, you should be able to do the following steps using Magic ETL: add a filter for Types IN ('Survey', 'Cutover and Test', 'EPIK','Greenix' ) add a Group By and group by …
  2

Next