-
Single column dynamic pivot - syntax error
Grateful for any guidance. I'm seeing the syntax error below and I can't figure out why. New to MySQL Transforms as my previously relied upon python scripts are to be deprecated. Objective To take a single column of dates and turn them into column headers. Once pivoted, row value(s) are irrelevant (they'll be overwritten…
-
Complex Pivot
How can I use Magic ETL to convert a table from to without using scripting? I have to remove all scripting tiles from my ETLs. I'm assuming some combination of RANK & WINDOW, PIVOT and GROUP BY, but am running out of talent.
-
Is it possible to use a value other than Category in the Outline view of a Gantt chart?
I want to display the rows per Program and Feature (i.e., the category), as in the outline view of a Gantt chart, but colour-code by pipeline status. Gannt automatically uses the category field to colour code, even when custom colours are specified. Is there a setting to override category colours with custom colours?
-
Daily Dataset Update via Python fails on first run each day
I am using the Domo Dimensions Calendar as an input to a Python script that updates an dataset of the next 365 days as columns |2023-01-27 | 2023-01-28 | 2023-01-29 | 2023-01-30 | ........ | 2024-01-27 So, when the script runs tomorrow the first column will be 2023-01-28, and so on. It works, to a point. The first daily…
-
"Column referenced but not found" Python error creating date-sensitive columns in ETL
Objective: To take an existing dataset that shows event start and end dates, and a total value and parse that info into a daily value that appears in columns representing all dates between start and end. Method: Using Domo Dimensions Calendar, select only rows from current date to +2 years. Use the result in a Python…
-
How can I create personal cards?
I have a team of people, each with responsibility for some portion of my dataset, taken from a Ticket Management system. I want to create cards and a dashboard that shows each individual on the team a series of data points about their tickets only. What is the best way to achieve this? Is it possible to auto-filter based…
