Best Of
Re: How to show events that happened after a selected one?
Hi @0RNGL4DY,
This straightforward Python method generates the participation sequence, enabling further data visualization or filtering. Here is the output:
This was achieved with the following simple single line Python script:
#Import the domomagic package into the script
from domomagic import *
import pandas as pd
#read data from inputs into a data frame
input1 = read_dataframe('your_dataset_name_or_the_name_of_the_previous_tile')
#write your script here
input1['Participation_Sequence'] = input1.groupby("Person")["Conference Attended"].transform(lambda x: "->".join(x))
#write a data frame so it's available to the next action
write_dataframe(input1)
Re: DOMO SQL - Formula
Yes, you can put CASE statements in the SELECT or in the criteria (WHERE clause).
Re: DOMO SQL - Formula
The NaN means "not a number". LIkely due to a divide by zero issue. Maybe try catching the condition
SELECT *,
CASE
WHEN sum("AD_IMPRESSIONS") IS NULL OR sum("AD_IMPRESSIONS") = 0 THEN NULL
ELSE sum("ESTIMATED_YOUTUBE_AD_REVENUE") / (sum("AD_IMPRESSIONS") / 1000)
END AS "CPM"
Re: Tracking Usage & Measuring Success
@Data_Devon I've found it most useful to focus specific use cases.
For example, we rely heavily on Domo for systematically identifying exceptions that need correcting based on a set of criteria according to data from our other systems. In that case we can measure benefits by measuring the time to resolve exceptions before and after implementing alerts in Domo.
Similarly, you can consider any manual reports that Domo has made obsolete. If you estimate the amount of time it took to compile the report before Domo and multiply by the frequency it was run, that translates into man hour savings.
Re: How to properly replace data when using Upsert for Output?
You could preserve your historical data by making a new DataFlow that uses the problematic output as an input, and then copy its contents to a new DataSet. Then you could bring that copied DataSet in as a secondary input to your original DataFlow and merge the new data with the historical data in any way you choose (Append Rows, Join, etc.).
rco
Re: How to properly replace data when using Upsert for Output?
Upsert works exactly like Append except that any pre-existing rows with the same key value (the value in the specified key column(s)) as a newer row will be removed. It isn't currently possible (in Magic ETL) to remove rows with a given key value entirely, nor is it possible to update the key value of a row.
Reverting to an older version of a DataFlow doesn't affect its outputs at all until it executes. After you execute the reverted DataFlow, if all of the Output DataSet tiles are in "Replace" mode, you're probably back to exactly the state you were in the past (with a few exceptions, like when the DataFlow references the current date or time in its definition). However, when one or more Output DataSet tiles are in Upsert, Partition, or Append mode, you need to take into account what was already in the DataSet to determine what will be in it thereafter. If you want to start over, you should set the Output DataSet tiles to Replace mode for just one execution, and then put them back in the mode you intend going forward.
rco
Re: Export Magic ETL Code for External Version Control
Having an export button would be great, until then as a workaround you can select all the tiles in your Magic ETL and then click "copy to clipboard" this will give you the json of your ETL that you can paste into a file for version control purposes
Re: Export Magic ETL Code for External Version Control
@MasonW you can also use the CLI to export the JSON definition of the dataflow using the 'list-dataflow' command. This could be automated through scripting if needed.
ellibot
Re: Text column as values in Pivot table.
If you could simplify your table to two categorical dimensions, a Heatmap card (the one under Popular cards, not the Heatmap Table) can do what you're asking out of the box:
- Pivots data
- Can be easily and flexibly color coded
- Has Hovertext
Re: Dynamic CAGR formula?
Thanks! I was able to replicate this and it works great. It would be nice if Variables were more dynamic (i.e point the variable to an existing field and it populates the values. My data already has the Fiscal Year field in it, so having to manually add each year to the Variable selection list is tedious.
ccccc4