MichelleH Coach

@haipham What specifically didn't work? Did you receive an error in the ETL or did it return an incorrect value?

Hi @Abe, would you be able to share some sanitized sample data with an example of how you want the output to look?

This is a cool idea! It would be great for standardizing logic and helping new users get up to speed.

@Sbhatia The reason the total is showing a count is because the actual calculation is occurring within the CONCATs in your case statement, which means the that "Visits vs Prior Week Colour" field has a string datatype. If you want to conditionally color the column and have a total row, I suggest using Domo's built-in color…

@WorldWarHulk I agree with all of @ArborRose's suggestions. I would also recommend checking the activity log for User Renaming events that have occurred, which may give you more information on what is going on.

@WorldWarHulk Do you use Single Sign On to provision users?

@WorldWarHulk Are you changing their name from their profile in the Admin People screen? Is it possible that you are not clicking save?

@kim_barragan0126 Yes, that would work!

@levi_kim This will largely depend on your data and how it's ingested in Domo. For example, are new rows added a day/week at a time where you can use an ETL to add a relative date field to the new rows? It will also be helpful to review the other columns you have available that could be used to infer a date, like period or…

@kim_barragan0126 It looks like the parenthesis around the value are preventing it from converting to a floating decimal. You will have to remove those characters before converting the datatype using a formula. Do you know if the parenthesis represent a negative number, like in an accounting format?

@dkonig Which Adobe Analytics connector are you using? Some have partition capabilities in the connector itself.

@Eric.P Depending on which type of statistical test you are running, you could potentially recreate the base p-value calculation in beast mode. Admittedly, that would be a pretty complex calculation, though I do see that there is a standard deviation beast mode function.

@Stu5677 What have you tried so far?

@DataLyd The dataflow will continue to run on the original schedule even if you manually run it.

@TMonty0319 What does your original data look like?

@har_d_har1 Before you do that, I recommend reading this Knowledge Base article on Gantt chart cards, which provides guidance on how to structure data for these types of visualizations:

@har_d_har1 I generally advise against pivoting by date in a dataflow because it is very cumbersome to manipulate a constantly growing number of columns. May I ask how you intend to use this data so we can suggest another transformation method?

@kim_barragan0126 Usually when I've seen that error, it's because the dataflow is running at the same time as I click "Save and Run". In my experience it will run with the new version at the next scheduled/triggered execution. Can you confirm if that is the case here?

@bdavisclaro Is it possible that the "by month" text is actually a summary number on the card?

@PJG The bar labels may not be visible if the card is too small on the dashboard so that the labels aren't taking up the entire chart. If you want to make sure they are visible, you can either make the card larger on the dashboard or add the Category Name to the data label settings, like in @ArborRose's screenshot

@ArborRose That option is still available under the "Total" menu from your screenshot.

@scpradhan There is a setting in the Dataset via Email connector under Advanced Options where you can specify whether the data has a header row. This setting is "true" by default, but you can change it to "false" to make sure the first row is now interpreted as the header.

@ryangreiner9 Which Snowflake connector are you using? The Snowflake Partition Connector allows you to only fetch data from a trailing number of days to merge with the existing data. Rather than referencing the last refresh timestamp from the Domo connector, I'd suggest specifying the trailing number of days based on the…

@ArborRose You should be able to change the ranking function in ETL from Rank to Dense Rank to make it so it doesn't skip numbers. Here is the documentation on ranking functions in the Magic Tile:

@Absher_645 You will need break your calculation into two separate case statements surrounded by a count distinct, one for positive values and one for negative values: count(DISTINCT case when `OrderReason` in ('New Service','New Account') then `AccountCode` end) - count(DISTINCT case when `OrderReason` = 'Disconnect' then…

@SLam Method 1 is closest to what you would need for beast mode. The only change you need to repeat Sale Liability again after the AND. case WHEN `Sale Liability` >= 50000000 AND `Sale Liability` <= 100000000 then '$50M-$100M' WHEN `Sale Liability` >= 100000000 AND `Sale Liability` <= 250000000 then '$100M-$250M' when…

@Elnaz Good catch! Yes, that setting will change the color direction for all fields. Unfortunately the Flex Table chart is not super flexible. Here is an Ideas Exchange post I'd recommend commenting and upvoting for enhancements to it: In the meantime, you may be better off using the Table/Mega Table chart type in this…

@Elnaz If you check the Reverse color direction box under "Change Value Options", that should give you what you're looking for

@ColinHaze The STR_DIGITS function removes all non-digit characters, including decimal points. If dollar signs are your only issue, then I would use this function instead so that it only removes the dollar sign character: CAST(TRIM(REPLACE(TRL_MISC3,'$','')) as float)

@Lu_zhang ETL has Scripting Tiles that you could use to code R and Python within Domo, though your access depends on your instance's subscription. Here is an article about these tiles: