MarkSnodgrass Coach

I'm not sure how that beast mode is showing as validated because your WHEN statement isn't valid. Do you want to process what is in your THEN statement when COUNT(DISTINCT 'orderID') is greater than 1? If so, then you would write it as such: WHEN COUNT(DISTINCT 'orderID') > 1 THEN .... Also, a count of the sum of line item…

@Shumilex I would point you to this post by @GrantSmith that should do the trick for you. You would add an extra calculation to divide the current week number from the previous week. https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest

Make sure you are using the HTML table card. In your beast mode, you can use one CONCAT function and have as many links as you want. Example: CONCAT('<a href=https://www.google.com>Google</a>',' ','<a href=https://www.yahoo.com>Yahoo</a>')

I would suggest you use the Annotation feature to do this. Here's the KB article to learn more about it. https://domohelp.domo.com/hc/en-us/articles/360042923974-Adding-Chart-Annotations

Definitely seems like you followed all the correct steps. Either there is a bug, or the Filter Views feature is not completely built out to handle embedding properly. I would suggest sending this thread or these screenshots along with an explanation of your situation to support and see if they can confirm the bug/missing…

When you chose to embed the dashboard, which options did you select? According to this KB article, https://domohelp.domo.com/hc/en-us/articles/360043437993-Sharing-Cards-and-Dashboards-Outside-of-Domo-Using-Domo-Embed#h_01ESKWJ8QEVSRKQBQVQA9P65QP it indicates that the page filters will display if the Allow interactions and…

Have you created a filter view and saved it as the default? You should be able to set all of your criteria with the date range filter in the top right of the dashboard and then save it as the default. See this KB article for more information:…

@etszyingho if you can mark the answer as accepted, that will help others in the community. Great to see the massive improvement!

Awesome @etszyingho !!!

You may want to review this KB article regarding a recursive MySQL dataflow. You can avoid having to execute a delete statement, which is likely causing your timing issues. https://domohelp.domo.com/hc/en-us/articles/360043428133-Creating-a-Recursive-Snapshot-SQL-DataFlow

@Fadem if your join keys are two text columns, it is likely a data issue. Extra spaces and capitalization are two common reasons why rows don't match when you think they should. I would use the String Operations tile and trim spaces on both ends of your text. I would also convert the fields to upper case. Then try joining…

Glad to hear it @gospel . If you can mark any of the answers as accepted that you feel helped you, it will help out the rest of the community.

I plugged your beast modes into a card and replaced your fields with fields from my dataset and I got the correct numbers I would expect for my dataset. That tells me there is likely a data issue either with the filter dates or the premium amounts. I would also check for what field is used in your date range filter and if…

I would try and create a new redshift dataflow and copy in one step at a time and save and run it after each step to see if there is a particular step that causes the issue. This will help support out if you run into something and your syntax is something that the dataflow should be handling.

@RobB If I am understanding you correctly, for a given sku and a given date, you want the sales amount for that same sku 30 days prior, even if there is no record for that sku 30 days prior. You can do this as I described earlier and this is what it would look like in Magic ETL. I will try and describe it below. Use the…

You can use the Flex Table card to do this. You can adjust what is displayed in each column so that you don't see a bar or line graph, but the actual numbers. https://domohelp.domo.com/hc/en-us/articles/360043429073-Flex-Table

I would suggest using the Domo Dimensions calendar dataset to create a dataset that has all the dates for a given time period. You can then left join this to your sku dataset and replace nulls with zero. Then use your rank and window tile to go back x days. If you haven't used the Domo Dimensions connector, you can find it…

@GrantSmith I think "a little competitive" is understating things quite a bit. 😂 I do love the idea, though.

Are you sure that the URL is for the actual image? I typed in that first URL in your screenshot and it took me to a page. That won't to display an image. It should look like this in the case of the first row: https://m.media-amazon.com/images/I/81tA7oHRLVL._AC_SL1500_.jpg Is that what the Image #1 Actual Content field has…

Excellent idea! Just ran into this issue myself. Makes it challenging that there is no notification that a scheduled report will no longer be delivered.

You need to switch to the HTML table card for images to show. Your concat text looks correct.

@jefflmp585 Looping is encoded into the GIF itself, not the img tag. Open the GIF in an image editor and change the mode to loop. If you have access to Adobe Photoshop, here are the steps: Open your file in Photoshop Go to File and click Save For Web At the very bottom of the save dialog, you will see the Animation…

Did you already click on the dataset name and then go to the lineage tab and work your way back inspecting each dataflow to when those columns are getting created?

You can do this if you set up a web form that has a list of when your start and end dates of each your months. Like this for example: Next, create a MySQL dataflow that joins this web form dataset with your Shopify dataset so that you will have these start and end dates as additional columns to your main dataset. Here is…

You may want to look into the Domo Campaigns App. It is an add-on, so you will want to talk to your CSM about cost, but it does allow for PDF attachments along with a lot of other functionality. You can get a trial of it and see if it meets your needs. Here is more information on it:…

I would recommend using the Send/Export option and then choose Excel if your card is a table. This will ensure the complete data is sent. The Send Now option is intended for graphs because it is essentially doing a screenshot of the card.

I will defer to @jaeW_at_Onyx and @GrantSmith on this one as they are Window Function gurus. However, I believe you would need to add a partition by in your over clause, but you can't use MONTH('date') as Domo eliminated using a calculated field in the partition statement. I would also suggest you watch Jae's video on…

@gospel That is correct. You could also do the opposite if that is easier for you if you reverse your signs like this: CASE WHEN DATEDIFF(CURRENT_DATE(), `dt`) <= 7 THEN '1 week or less' WHEN DATEDIFF(CURRENT_DATE(), `dt`) <= 14 THEN '2 Weeks' WHEN DATEDIFF(CURRENT_DATE(), `dt`) <= 21 THEN '3 Weeks' ELSE 'More than 3…

Yes, you could do this: CASE WHEN DATEDIFF(CURRENT_DATE(), `dt`) >= 21 THEN '3 Weeks or more' WHEN DATEDIFF(CURRENT_DATE(), `dt`) >= 14 THEN '2 Weeks or more' .... END You will want to work chronologically, though in order to make it work. In this case going from greatest to smallest since the case statements stop…

@henryfact so if you use your beast mode that will display Marketing, SDR or Sales and put that in the series and put Record ID in the Y-Axis and choose Count for Aggregation, are you still getting incorrect numbers?