MichelleH Coach

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

@Brewha51 Have you considered using a Pivot Table card in Domo instead of an Excel file? You can use an alert/scheduled report as @Data_Devon suggested to send an email with the card details.

@Atieh The message in your screenshot says it was saved, so you don't have to run it from the ETL editor screen. If you attempt a manual run from the dataflow history it should provide more details on why the run fails.

@Atieh Do you get an error message if you try to manually run from the dataflow history screen instead of "Save and Run"?

@Atieh When I've received that error before, it's usually because the dataflow is already running. I would check the dataflow history to see if that's the case.

@Zel There is a link to support in the top right corner of the Domo Central home page:

@Zel This looks like it could be a bug, then. I'd suggest reaching out to Domo support to investigate further.

@Airwon What does your raw data look like? Is it possible to have passes and failures in the same row?

@Zel Do you have anything in the "Limit Rows" section of the top level of the card? If you do, it's possible that it got inherited down to the drill and you may have to remote it

@Zel Do any rows populate when you save the card and drill from the card details? I'm wondering if this has to do with the preview in Analyzer

@ColinHaze Have you tried using a FIXED function instead of a SUM Distinct?

@ARosser Can you walk us through what other steps you have taken to regarding null handling?

@Atieh Yes, support should be able to help you with the bug and implementing the fiscal calendar!

@Atieh Are your filters and calendar card powered by the same dataset? If not, be sure that the dataset powering the calendar card contains fields Fiscal year, Fiscal quarter, and Fiscal month. As a side note, have you enabled a fiscal calendar in your instance? If not I recommend creating one so that you can use the…