MichelleH Coach

@kav_100 I'd suggest using a Group by Tile to find the totals, then joining that back to your detail data

@Ajita Try adding <div> to the beginning and end of your HTML, and "','" between the URL and target field: CONCAT('<div><a href="https://www.adp.com/"','"target="_blank">',`EmployeeID`,'</a></div>')

@Ashleigh It looks like it's because the Graph by is set to "None" in analyzer. If you set it to graph by a particular date grain then you should have the option to change it from the card details

@user07231 Are you the owner of the SQL Partitions account used in your datasets? If not, the owner will need to change the password on the account in the Domo Data Center

@JohnnyN My dashboards page looks like what you see in this KB Article. Are you an admin in your instance?

@Chayan .xlsb files are not compatible with Domo's file upload connector. You will need to save those specific sheets in a new .xlsx file.

@JohnnyN Can you please send a screenshot of what you're seeing? My view has checkboxes as expected.

@renee12345 The TRIM() function in the Formula tile will remove any extra spaces from text values, while preserving spaces between words. Try applying that formula to your dataset field before joining.

I second this!

@dheeraj_sandhanshi You can set up a beast mode like this to segment what data to filter: case when DAYNAME(`DateField`) in ('Saturday','Sunday') then 'Exclude' when HOUR(`DateField`) >= 9 and HOUR(`DateField`) < 17 then 'Include' else 'Exclude' end

I'd also love to add default number and date formats

@Ashleigh Are these users on a different Outlook server than the rest of your users? I've occasionally had issues with scheduled report emails not making it to external users too, and we've had to have their network admin whitelist the notifications@domo.com email address for them

@domoexpert Try adding another open parenthesis before "partition": COUNT(MAX(`ID`)) OVER (PARTITION BY `Clinic`, `Product`)

@caiopimenta I was able to add the average line to a horizontal bar chart with a series using the Scale Marker settings below. It does not include Min/Max, but I was at least able to get a line to show up

@PJG Have you tried adding users to groups through the "People" section of the Admin panel? As far as I'm aware, that does not trigger an email.

@leonbrooks The primary email address associated with each user's Domo account needs to exactly match the email address used by your SSO provider. If the old email addresses are still going to exist as an alias, then I would suggest using the old email address as the alternate email for the Domo account as a backup.

@LucaMartini1969 Just to be sure, is that exactly how you have the partition written in your beast mode or are you simplifying for us to view? If you are simplifying it, could you please share the full formula?

@travorhouse Is the time zone for your instance the same as the time zone in your dataset?

@damen Yes, you can use a recursive dataflow to create your master "snapshot" data. The way you would do this is to add a column to your input data with the current date, then append to the existing output dataset. Here is a KB article about how to set up a recursive dataflow: As for your question about duplicate entries,…

@sarahi6 Try changing it to a Single Date with a relative 1 day back. If you're setting the dataset to Append then you don't need a static start date

Agreed! It would also be helpful to update the function list in this KB article:

@sarahi6 You will also have to filter the source data to yesterday's date so you are not duplicating rows. What kind of connector are you using?

@lauramiddleton You can create a top level card based off of a drill path. When you drill on the original card, just use the "Save as" option to create a new card with the same configuration as the drill.

@gbrown What about your raw data in the underlying dataset? What are your beast mode formulas?

@gbrown That depends on how each of those fields are set up. Could you please share how your data is structured and the beast modes you already set up?

@gbrown Yes, you can do this using a pivot table card. If you drag your bucket values to the Columns section and use Weekly Plan and Weekly Actual as the values.

@Goodeman I see. Since you want to include a SUM and LEAD in the same calculation, I'd suggest adding the previous timestamp as a column in your dataflow instead of in the beast mode. If you are using MagicETL you can accomplish this using the a LEAD function of eventTimestamp in the Rank & Window tile, ordered by…

@Goodeman It looks like your total is not populating because you are using a window function without an aggregation function (i.e. you need to include a SUM somewhere in the formula). I would also recommend moving the SEC_TO_TIME function to the outermost position in your formula. Can you share a little bit more about what…

@Goodeman Is your Total Unavailable Mins column already a beast mode? If so, could you please share your formula?

@AdParlor_Domo_Access Yes, I've heard of a few different people getting the same error on email connectors today. I was able to manually re-send the email report to Domo, but I would reach out to Support if that does not work for you.