MichelleH Coach

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

@damen I'd suggest setting up a card using your webform dataset for the alert. You can use a beast mode filter to only include rows where action is needed from Department B like this: case when column A is not null and column b is null and column c is null and column d is null then 'Include' else 'Exclude' end Then you can…

@Mark Puddephatt You can use the INSTR function to return the starting position of the email address within field2. If field1 is contained within field2 it will return a number greater than 0. case when INSTR(field2,field1) > 0 then 'Looks good' else 'Looks bad' end

@jmmc To add to @ArborRose's suggestion, note that you do not need to aggregate dimension fields like in your MAX(address) example. Table cards and pivot table cards will automatically aggregate the entire cards as long as every Metric (numeric) field is aggregated. You also do not need to create beast modes for simple…

@terrydoyle You can also filter an existing dataset in Views Explorer without saving a new dataset using the "Export" option in the top right corner.

@DanieleSilva You can use the following case statement either in Beast Mode or an ETL formula tile: case when `Fixed Value` is not null then 'Fixed Contract' when `Spot` is not null then 'Spot' end

@vaco I have not had that issue with the Google Sheets connector before. Do you have data validation rules set up on your date field in Google Sheets to ensure it is all stored as a datetime?

@Sean_Tully Could you please share the current fixed function you're using?

@benm_2000 Is there a policy status column in your dataset? If so, you can drag it from the Dimension section of Analyzer to the chart columns to include it in your card. However if you are unsure, your best bet is to ask whoever requested this change for some clarification on what specifically they are looking for. If…

@benm_2000 Can you elaborate some more on what you want with this column? Are you trying to flag policies to rescind based on certain criteria?

@Zel Can you confirm if the Monday Test2 (X-axis) field is in a string format? Does the pill in Analyzer show "abc" or a calendar icon? If it's a calendar, you may need to wrap the entire formula in a CONCAT function.

@barb_barney_88 I'd also suggest exploring subset processing in MagicETL, which will allow you to request smaller amounts of data on your Workbench dataset (last 30 days, etc.) and merge with the existing output data.

@Zel If you don't want the date gaps, you can convert the dates to a string using the DATE_FORMAT function: DATE_FORMAT(case when DAYNAME(`Date`) = 'Sunday' then DATE_SUB(`Date`,interval 6 day) else `Date` - DAYOFWEEK(`Date`) + 2 end, '%Y-%m-%d' ) Note that if you do this, you will need two versions of this beast mode: one…

@Zel Try changing the Graph by in your chart to "None". When it is set to "Week", the chart will still convert all weeks to starting on Sunday, so you want to bypass the default date grouping.