MichelleH Coach

@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:

@Zel Can you please explain what you are trying to accomplish in terms of business logic and what you want your final dataset to look like? That will help us point you in the right direction.

This would be a great enhancement. Short of creating an alert for every dataset or downstream dataflow there is not a reliable way to catch this before end users report that something is wrong.

Thanks everyone! I'm glad to be a part of such an awesome community

@Data_Devon How strict are the requirements for how the data is formatted? I often find that "pivoting" in card form is much more flexible than hard-coding columns into the dataset. For your use case, it may make more sense to create a separate branch of your ETL to filter or aggregate your data so you have a single row…

@renee12345 Beast mode date functions always run off of Domo's default calendar, even if the Use Fiscal Calendar box is checked on that particular card. I'd suggest creating a spreadsheet upload dataset with columns for Date, Fiscal Week, Fiscal Month, and Fiscal Year that you can join to any datasets that require fiscal…

@mmisky87 Have the credentials for the Google account changed?

@Jmoreno Interesting… are you querying from SSMS on the same machine as Workbench?

@Jmoreno What kind of dataset is it (Excel, ODBC, etc.)? What happens if you try to access the source data in a method other than Workbench?

@Lucky21 Be sure you are using the below chart type, not Stacked Bar. Note there is also a setting called "First bar series count" where you can specify how many Types go into the first bar

@Lucky21 I would also look into the Grouped and Stacked Bar chart. You would need to create a separate beast mode for each Type/Metric combination (i.e. Pen Revenue, Pen Forecast, Pencil Revenue, Pencil Forecast)

@HowDoIDomo Unfortunately, only the owner of the account can edit the credentials. Here are a couple of related posts from the Ideas Exchange that I recommend upvoting and commenting to boost visibility:

@Josh_Evans20 This issue is likely that your numerator is aggregated and your denominator is not. What does Total Inventory represent and is there a way you could restructure it as an aggregation?

@Brewha51 Gotcha. In that case, not having access to the instance eliminates most out-of-the-box solutions if accessing the raw data is a requirement. You may be able to script something locally that refreshes and fetches the data using the Domo API, then sends the file as an attachment. I'll admit that is not my area of…

@Brewha51 Do the people you want to email this to have access to your Domo instance? If they are, they could follow the scheduled report email link to the Pivot Table card, where they can drill down to the underlying data. Is there a reason it has to be in Excel?

@ColinHaze It sounds like you want to include both Drill In Place and Filter interactions for the same card, which I don't believe is possible. I'd suggest splitting this into two separate cards, one for filtering by state, and one for filtering by customer.

@Josh_Evans20 Is the column with blank values coming from the right table in your join? If so, check whether that value for your join key exists in the right table. If there is no match found in the right table, then any column that comes from the right table will be null for those rows. In the example below, assume you…

@Atieh These looks like the options for the output dataset, not the dataflow. If you click "View DataFlow" it you should see an option to re-run it.