MarkSnodgrass Coach

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?

Ok. It seems like your case statement is working properly to get the Marketing, SDR, and Sales names for the series. Have your tried just putting Lead Source in your Y-Axis and choosing Count for the Aggregation? See if that works before we go into using a beast mode for the count.

@henryfact can you mock up a display of what you want the end result to look like? Can you also take a screenshot of how your Analyzer is currently configured, making sure to show the filter and sorting properties? With this additional information we will better be able to provide you with a proper solution.

There is not currently, but that is a good suggestion for the Ideas Exchange as it would make a lot of sense to do that.

@jaeW_at_Onyx I was assuming 'Marketing' was a numeric amount, but maybe I misunderstood what that field represented.

Have you tried wrapping your case statement with a SUM function like this: SUM(CASE WHEN `Lead Source` IN ('Event','Display','Direct') THEN 'Marketing' WHEN `Lead Source` IN ('LeadIQ','Prospecting') THEN 'SDR' ELSE 'Sales' END) Also, another reason why you might not be able to sum is if you have things in your sorting…

Gotta earn those Dojo points! :)

@Ritwik and @amehdad21 I added this to the Ideas Exchange if you want to help vote it up. https://dojo.domo.com/discussion/53480/hide-sorting-indicator-arrows-when-not-hovering-over-them#latest

In your example with counting Employee IDs and Job Codes, in order to not show the Employee IDs, you can use Magic ETL to aggregate the information for you by using Group By and Count and then build the card off the resulting output dataset. That way, the dataset that is used for the card does not have sensitive…

Have you tried using the Sorting Properties to define your sorting rather than clicking on the elements in the chart to pre-sort it? I think that is the only way I have been able to keep them from showing up initially.

Done!

I have seen people have issues with renaming fields in their view, especially with group by statements. You certainly did the right thing with opening a support ticket as I imagine there are still some bugs since it is a fairly new feature. I would recommend sending the ticket number to your CSM and have them advocate for…

Right now, you have it coded as a string. If your datasets has columns called Q1, Q2, etc. then you could have those in your case statement, but you need to fix that in your statement so it is actually referencing those fields. If Q1, Q2 are calculations, you would need the actual calculation in your case statement.

It looks as though you are trying to sum the lbs field with the string values: Q01, Q02, etc. You can't sum string values. That is probably where you error is occurring.

Just in case you aren't already aware, source datasets can be set to replace or append. They don't all have to be replace. Additionally, you can use recursive dataflows to create an appended dataset. See these two KB articles:…

It is really just for display purposes in Domo as you have noticed. It would have nothing to do with Writebacks because you don't use Workbench for writebacks. It is just there to make it easier for you to identify your workbench jobs.

@cthtcc I would recommend reviewing some of the information here: https://developer.domo.com/docs/embedding-into-sites/embedding-into-sites-and-web-portals I think the key is to look for a platform that works well with the SSO framework that Domo Everywhere uses. Domo is also developing a brand kit where you can take a…

@StefanoG Have you figured this out? One thing I noticed is that your column widths don't add up to 100%. They add up to 126%. That could be affecting things. If you comment out all properties will it display something? I would then try adding in properties one at a time, starting with the total row property and see where…

Good suggestion by @GrantSmith . I just tested this in a beast mode and it worked properly. Using this syntax: CONVERT_TZ(`_BATCH_LAST_RUN_`,'UTC','CST') Properly converts. See screenshot below. Again, the Batch_Last_Run field is coming in as UTC, so I put UTC and parameter 2. I want to convert to CST, so I put CST in…