mbelmont Contributor

The odd thing is it just started happening today for no apparent reason. Never needed to impersonate before. But I can give it a shot.

Both unfortunately.

CASE WHEN IS NULL `DATE.001` THEN CONCAT(AVG(`NUMBER.001`),<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', 'RESPONSE 1', '</a></div>') WHEN IS NULL `DATE.002` AND DATEDIFF(CURRENT_DATE(),`DATE.001`) > 2 AND `STATUS.001` = 'Alpha' THEN CONCAT(AVG(`NUMBER.001`),'<div…

Can I ask, does this data come directly from another source or is it stored in excel (CSV, etc) somewhere you could manipulate it prior to reaching DOMO?

This does not seem to be the case anymore and it appears the line is being arbitrarily chosen. In fact, the line gets changed when I add a data label (what ?!?!) Specifically, I have a series that is a count of certain string types so sorting does not work. Is there anyway to choose which category is the line in this…

If you mean an entire column then yes. You can use HTML. Let me know if you need an example.

hahaha, no problem!

Are you sure you are not changing anything? I am getting a fine result and all I did was switch fields to those in my dataset (also a string field) CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px; padding:7px;font-weight:normal">', MAX(CASE When `19` = 'Purchase' then 'Regular' Else `19`…

It looks fine to me, are you looking at the summary number on the card or in the editor? It will always appear as HTML in the editor but is fine on the card. If it still doesn't work try adding back your MAX() in front of the CASE() statement: CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px;…

Can you send me the exact code you are using?

I only included that as it was in your original reply; however it is not needed if all of the results end in a CONCAT() statement or if you use the second version I sent you. I am assuming you are using the MAX() to get it to show in a summary number, which CONCAT() will do as well.

Oh, and I was assuming that you would want different text formats for the two values; based on your reply it looks like you might want it to apply to the any result. If that is the case then: CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px; padding:7px;font-weight:normal">',(CASE WHEN `XX` =…

The HTML has to be in the result of the case statement, I am assuming in the below that you want the positive result of the case statement to edit the test using the HTML you provided: MAX( CASE WHEN `XX` = 'No' THEN CONCAT('<div class="big_number_option" style="color:#000000; line-height: 10px;…

Yes, you simply add the CONCAT() with the assocaited HTML code in the result of the associated WHEN statements.

Take a quick read of this post: https://dojo.domo.com/t5/New-to-Domo-and-Admin-questions/set-fiscal-year/m-p/12355#U12355 You need to get with your DOMO Consultant to update the calendar.

I see what I was doing, I was encapsulating only the portion I needed changed, not the whole string. Thanks

Is the data from Salesforce going directly to a dataset or do you have a dataflow that may be limiting the data available?

I do not believe so, might be a worthy addition to the Ideas Exchange though, I am sure this has been brought up before.

There are a lot of discussions about Sumo Cards on the ideas exchange. I would head over there, find the most upvoted topic and add another vote. Sumo Cards definitely need some love.

I know this is a huge topic in the ideas exchange, you should head over to there, find the most upvoted version of this topic and contribute another. With regard to your issue of making a liked drillpath a "standalone" card I have accomplished this without recreating the whole thing by copying the card and changing the…

If I understand the question, you can accomplish this by simply using a filter to get rid of the Null results. Let me know if you need a walkthrough or if you can provide a screenshot of your card-edit so that I might be able to better assist.

The short answer is no, but there is a workaround. If you like your drillpath simply duplicate the card and recreate the main card chart as you go. Typically (at least I have found this) the drill paths are a bigger pain to create especially if they are heavily formatted table representing some sample of your "end data."…

Yes, I am simply trying to find the most recent date from a table. I think a SQL dataflow would work. Thanks.

Yes, however I was hoping for a more elegant solution because I have about two dozen columns that I need to check against.

Thank you so much! Worked perfectly.