MichelleH Coach

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

@Lu_zhang Check out the Grouped Bar with Line chart:

@Lu_zhang You can use the "Line bar" chart type to achieve this. These charts default to one line metric and bars for the rest, but you can change the "Series on left scale" (found under General chart properties) to 2 to display a second line.

@Lu_zhang In the "Text" box in the data label settings, change "VALUE" to "%_VALUE" for the macro to show the field value instead of the word "VALUE". You can also click the plus (+) sign in the text box to auto-fill the macros. If you want to always show the labels on the bars and lines, change the "Show datalabels on"…

@NFerna Can you please share a screenshot of all your settings on the connector?

@Charlie Bantoft The Dimension should correspond with whatever field you are use to group your data in the card, like Customer. If your card is not grouping by any specific field, then you can remove "by Dimension" and just have "FILTER NONE" in the parenthesis.

This would be a nice enhancement to make the card assumptions more clear to the data consumer, especially since there are reasons why different cards use different calendars

@Charlie Bantoft You can use a FIXED function in Beast mode so your calculation ignores filters like this: sum(sum(`Revenue`)) FIXED (by `Dimension` FITLER NONE) More on Fixed functions:

@damen You will need to create the scheduled report based on the card instead of the dashboard to enable the spreadsheet option

@LBucalon Domo's most recent product release added the ability to use alerts to send scheduled reports. This means you can configure the alert so that it is only triggered when rows are visible in the card

@Dodgeball_Australia What value do you have entered for the "From Email Address" in your connector settings?

@BMilner If you wrap an IFNULL function around your existing ETL formula, you can specify the value you want nulls to be remapped to like this: IFNULL(your formula,'Value for Nulls') This will apply to all null values every time the ETL runs.

@joebenz You could also create a Segment for your grand total. Here is more information about Segments:

@ColeStuart The email address associated with the dataset is only used as the recipient of the email with the attachment you are sending to Domo. Each dataset has a unique email address so that Domo knows which dataset to upload the attached data to. Domo does not send emails from this address. If you want to be notified…

@ColeStuart It looks like the values you entered for Header Row and Starting Row are the same. Try changing Starting Row to 4 if your header is in row 3.

@Cbrack Can you send some screenshots of what you mean?

@Cbrack Can you confirm that the other user also has the add-in installed and that they have access to the dataset in their Domo account?

@damen It sounds like the LPAD function in the formula tile is what you're looking for. In your case you would want LEN = 10 and PADSTR = '0'