MichelleH Coach

@NathanDorsch Do you have your date range set to graph by "Day" or by "None"?

@jakebutterfield If you want to show the totals for each year, add a beast mode using the formula YEAR(`Date`) to extract the year from the date column. Then add that new beast mode to the pivot table in your second image in the rows in front of Date. The pivot table will add subtotals by year once you do this.

@Rupak Instead of using a fixed function, you can add a case statement within your sums to find the current year totals like this: when sum(case when `Year` = YEAR(CURRENT_DATE()) then `Count Yes` end) / sum(case when `Year` = YEAR(CURRENT_DATE()) then `Count Overall` end) > 0.99 then 4

@muahmmad_zaidi I'm glad you got it to work! Can you please share what you did in case others have the same issue?

@muahmmad_zaidi Can you please send another screenshot of the full Analyzer view? The Series option should appear next to Y Axis

@EmmaDonery Can you share a little bit about what data you currently have available and what you want to do with it? If you need to take snapshots at particular points in time, then a recursive dataflow would likely be your bet bet. Otherwise there are some other methods you could use by categorizing and appending data…

@muahmmad_zaidi The stacked bar chart type is listed under "Bar", and is the first option listed under Popular Charts

@jakebutterfield You are correct that nulls are populating after the join because the right table has fewer unique values in the Campaign field than the Session Campaign field in the left table. Left joins return all rows from the table on the left, regardless of whether it matches any rows in the right table. If a match…

@Aag2023 What do the valid date values look like in Domo? You will likely need to use a STR_TO_DATE() function to parse it into a date field yourself

@JohnnyN In that case I would follow @ST_-Superman-_'s suggestion in trying an upsert dataset so you can bring in a rolling X number of days without duplicating.

@JohnnyN What kind of connector are you using to pull this data? If possible, I'd suggest setting the update method of your dataset to Append, then aligning your query and update schedule so that it always pulls data since the last time the dataset ran. For example, if you have your connector set to run once a day then you…

@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 [email protected] 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,…