MichelleH Coach

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.

@Jonathan53891 This is awesome! I'll definitely be using this in the future

@kim_barragan0126 It looks like this would have been caused by a format change in one of the inputs to your dataflow. I'd recommend using the FUZZY_PARSE_DATE function in the the Magic ETL formula tile to account for these different formats and convert them correctly into a date datatype.

@kim_barragan0126 Does it have to be the week end date? There is a beast mode function called YEARWEEK that will return the year and week number of the date field. So if you wanted to create a metric for total starts per week, you could do something like this: count(`StartDate`)/count(distinct YEARWEEK(`StartDate`))

@NateBI Forgive my question, but what is the purpose of this chart? With so many bars, you'd be better off converting this to a table or creating multiple visuals rather than trying to squeeze labels into a giant bar chart.

@Utz Joins can return more rows than both tables combined if multiple matching rows are found between the two tables. In this case, it sounds like you want to return the same number of rows from your left table, but the same ItemNumbers appear multiple times in your right table. Without knowing the nuances of your specific…

@verytiredgirl If you haven't already, I suggest reading @GrantSmith's write up on this topic: https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

@sourabh05 Depending on your role, you should be able to move existing pages under Admin > Content > Dashboards. Here is an article about how to move a page from that screen:

@Data_Devon Can you confirm that the Google Sheets account used in the connector has access to the sheet?

@ColemenWilson I was able to create an alert from a card built from a dataset view. Does the card not even show the "New Alert" button?

@andyhicken I often find content that has been shared with Domo Support if they have ever needed access to troubleshoot an issue in your instance for a support case. There shouldn't be any harm in it being shared with them but you can probably remove them if you don't have any open cases

Great idea! I would love the same option when exporting a dashboard as a PDF and Powerpoint as well

@Chris_Wolman Assuming the previous user was using dataset connectors, you should be able to add additional owners to the dataset account: