rco Domo Employee

Comments

  • Thanks for bringing this up Zac. We've updated the in-place Magic ETL documentation for the WEEKOFYEAR() function. The new docs will mention the discrepency with MySQL and recommend that WEEK() always be used over WEEKOFYEAR() in the current version of Magic ETL. We can't immediately change the existing behavior of…
    in WEEKOFYEAR() should be removed from the approved function list or it's behavior should be changed Comment by rco June 2023
  • 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_CONCAT(DISTINCT Category SEPARATOR ', ') and MIN(Date) might be what you're looking for.
    in unpivoting data Comment by rco May 2023
  • Raj, are you in the Filter tile's formula editor there? Filter expressions must be boolean (true/false/null). You may want to use the Add Formula tile to create your quater string, and then perhaps multiple filter tiles with expressions like my_year_quarter = '23-Q2' to separate your data into different sets (if that's…
    in failed to convert value from string to boolean Comment by rco April 2023
  • 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 column names, empty string column names, or non-string column names.
    in write_dataframe fails to write output of pd.pivot_table having Nulls Comment by rco April 2023
  • 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 floating-point number), it would be SUM(TIME_TO_SEC(`TALK TIME`)) / 3600 If you want integer hours, invoke the DIV function…
    in Time to Number value Comment by rco April 2023
  • GROUP_CONCAT, which is identical in behavior but different in syntax to LISTAGG, does support the DISTINCT keyword as of relatively recently: GROUP_CONCAT(DISTINCT customer_name SEPARATOR '/')
    in Distinct List_Agg Comment by rco April 2023
  • I'd Group By docnum to produce the 'First non-null value' of Quoteref and then Join the result of that Group By to the original sales data on docnum. If there's any possibility of multiple distinct Quoteref values within a given docnum and you don't want to lose that information, you could do a formula aggregate instead…
    in Partition BY, filling missing values Comment by rco April 2023
Avatar