-
Re: Converting a duration time text field into a number
Try an Add Formula tile and the TIME_TO_SEC function: name: duration_sec expression: TIME_TO_SEC(`duration`) This should work as long as all your string values are in that hours:minutes format.1 -
Re: Group By Tile to JOIN Tile Produces Unexpected Result. Using an Output Tile as an Input Fixes It
Previews operate on a limited number of rows from their inputs, by default just 10k rows: This can cause Group By aggregates to look incomplete, Joins to miss when they should hit, and Filters to pro…3 -
Re: Time to Number value
If your goal is to get a result that is a time string like your input, I believe you want something like CAST(SEC_TO_TIME(SUM(TIME_TO_SEC(`TALK TIME`))) AS CHAR) If you only want the hours (as a floa…1 -
Re: unpivoting data
It's a recent addition and not yet mentioned in the docs, but Magic's GROUP_CONCAT does support the DISTINCT keyword now. A Group By tile with grouping column Account and the formula aggregates GROUP…1 -
Re: write_dataframe fails to write output of pd.pivot_table having Nulls
write_dataframe is failing here due to column names, not values. Each item in pivot_df.columns is expected to be a non-null non-empty string. Either pivot_table is returning a DataFrame with null col…1
