MichelleH Coach

@Anna_Otake This is a simple enough use case that I'd suggest creating a scheduled report off of a card that's powered by the People DomoStats dataset, rather than using Workflows.

@verytiredgirl You will no longer need the date drop down filter if you are using the filter view, but the reason I recommended the filter view is that it's better at handling relative dates.

@CK_16 The error can be resolved by rearranging the calculation so that the numerator and denominator of your beast mode each contain a single case statement within a sum like below. sum(case when year(`trx_date`) = 2025 then `extended_amount` else 0 end) / sum( case when `Product Category` like 'Product 1%' and…

@verytiredgirl Instead of using a specific card for your date filtering, I suggest using a filter view to default all cards to Previous Month. To prevent the bar graph from filtering to just last month, you can uncheck the "Allow global date" box under that card's filter exceptions.

@user082291 It sounds like you may be exporting a dashboard where all the cards are in the Appendix if they are all showing on one slide out of order. I second @MarkSnodgrass's input about arranging the cards in layouts to determine where they appear in slides.

@andyhicken If you don't have buzz I'd suggest directing the user to the "Forgot Password?" button on the log in screen to retrigger the email. Alternatively, admins have the ability to change users' passwords from the admin page.

@s_f_OTT If the value of your date field is on a Saturday, then the WEEKDAY function will return 7, not 0. So if you change the 0 in the first condition of your case statement it will apply the correct number of days to subtract.

@holodude Are all your beast modes the same? The rounding in the Productivity field looks suspicious, and if the ProdMinusTarget references that calculation it could also be impacted.

@holodude Cards should automatically update when the underlying dataset refreshes. Here are a few things to check if it's not working as expected: Are there any filter exceptions applied to the original cards on your dashboard that would not apply to test card you just created? Are there duplicate datasets with the same…

This would be a really nice quality of life enhancement. The lack of real estate is especially challenging when working from a laptop screen.

@James_Lord I'd suggest sharing the alert with the same groups used to grant access to the relevant dashboards. You should be able to accomplish this without a workflow, and hopefully saving you some credits.

@Utz I generally recommend aggregating the numerator and denominator when using division in Beast Mode like this: sum(`DeliveredMarginDefine`) / sum(`QtyMarketingForecast`) Otherwise, the card is dividing each dataset row first before then summing them, resulting in unexpected outputs.

I wouldn't play anything. I'd prompt my agent for the sound I want.

@qzqzqzqzqz Different systems may have different settings. Snowflake may be storing your datetime fields with a time zone, while Salesforce does not.

@qzqzqzqzqz Domo will attempt to convert your datetime fields into the time zone in your instance's Company Settings, so it's likely trying to convert to the default UTC. If you decide to change this setting, do so with caution to avoid disruption to your existing content. Otherwise, there are options in Magic ETL to…

This is really helpful! Commenting for more visibility.

That's awesome @ellibot, thanks for sharing!

I agree with all of @ggenovese's recommendations for optimizing the SQL. If you're still not satisfied with the performance after implementing those suggestions, you could also consider replicating this in Magic ETL (still following the previous guidance). I've seen some significant performance improvements since migrating…

Sometimes I don't remember key words in the title of a card, but I remember what it looked like. Other times, there may be multiple cards with similar names and it would be helpful to further narrow down the search.

@Jai Based on your screenshots, it appears that your "Date" field is being stored as a string instead of a date (you should see a calendar icon instead of "ABC"), so Domo doesn't know how to filter the data. To resolve this, you either need to change that field's datatype your source data or use a beast mode like this in…

I'm assuming the "Date Presets" card is a Date Selector filter card. Do the "Date Presets" and "Revenue" cards use the same dataset? If no, they both need to contain date columns with the same name in order for the filter interactions to work.

@jhp Do you have the date range hidden on your revenue cards? If this box is checked in Analyzer, then the card will not react to dashboard date filters.

@art_in_sky Make sure to put single quotes around 'TRUE' and 'FALSE'. It's likely trying to find fields with those names, so putting them in quotes will make sure they are recognized as strings and not field names.

@verytiredgirl Yes, you can specify how many lines to display under Chart properties > General > Series on left scale. The value entered here dictates how many lines to display. For example, if you enter "2" then the first two measures in analyzer (the Y-Axis value plus the first Series value) will both be displayed as…

@kaita I don't recommend using that chart type for a series with so many values. Bar graphs are best suited for comparing relative bar sizes, which requires seeing all values at once. If you're looking for a way to display all dollar amounts in a scrollable format, a table chart (mega table) is a better option.

@martinez473 It looks like the issue is that you're calculating the percentage before rolling up on a monthly level, so your card is adding up the percentages of each row of your dataset. I'd recommend changing the Meals per Day and Participation to beast modes within your card that calculate percentages based off the…

@Utz This is pretty common, since switching a field to No Aggregation is the equivalent of moving that field to the Group By clause (i.e. all other fields must be grouped by each unique value of that field). To resolve this, you will need to update your beast mode so that each individual field in the calculation uses the…

@martinez473 Would it be possible to see an anonymized sample of your data, as well of some examples of what you're seeing versus what you're expecting?

@Paras123456789_ Can you provide a little more information? As a starting point I would recommend looking into Period over Period charts, but it would be helpful to know what kind of data you have, how you define improvement, etc. so we can give you more direct recommendations.

This is a great idea and can help ensure that all cards contain the proper documentation as long as the definitions are added to the dataset.