-
Re: Python Tile fillna on integer column keep return 0 unless I change the column to text
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
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
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
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 -
Re: Max Slice before 'Other' Pie Chart but applies to Line Chart?
If you add a RANK() beast mode then you can filter your card on RANK < = 7 RANK() OVER (PARTITION BY `date` ORDER BY `pie value` DESC)2