ArborRose Coach

You could put a filter on the data….create a calculated field such as CASE WHEN {there's data} THEN 1 ELSE 0 END. Put it on filters and the output should keep those from showing

I would check all your quote marks to make sure you are terminating the proper html tags. Mark sure each opening single or double quote is ended at the appropriate place. When I have done tables this way, I use two cells in a table. The top cell may include a photo using something such as And then another cell would have…

{Re-reading your original post.} You could find your most recent record's date using some kind of max date. But it seems you know the scheduling delay already as somewhere around 4 days. Yes…as added columns. My comment shows how I do this kind of thing dynamically. The formula is saying….take the sum of all the records…

Solved it. When I couldn't get rid of the comma, my first guess was also to change the field to text using concat() but it didn't work. My previous version workflow still exists under a different name and it works just fine. Both use the same formula for creation and I duplicated the card being used as a dropdown filter.…

I do this using calculated fields that represent this year and last year. So Last Year YTD would be something like this… sum( case when YEAR(transaction_date) = YEAR(DATE_ADD(CURRENT_DATE(),-365)) and transaction_date <= DATE_ADD(CURRENT_DATE(),-365) then amount else 0 end ) And obviously This Year YTD wouldn't have the…

You could also probably use rank to determine the condition.

You could create a calculated field that identifies the lowest and highest. So when its min, the fields says lowest, and its max the field says highest, otherwise its empty. Then use color rules based on the calculated column, when condition='lowest', set color. When condition='highest', set color. etc.

(?i)\bRMP I haven't been doing regular expressions in Domo. But the regular expression above says use case insensitivity to find "rmp" or "RMP" or "rMp" etc in the string. \bRMP2\b Would find RMP2 but would not find RMP.

https://community-forums.domo.com/main/discussion/comment/64143#Comment_64143 Euchre….lol. Jason, I live in Dallas. People in the South don't know euchre let alone how to spell it. Let me know when you figure out how to use Domo to play an online euchre game. The data set and sorting is easy. The cards in the euchre deck :…

As Mark says…you need an aggregate (COUNT, SUM) on the amount field. Place the month field and the amount field next to it. To order the months in chronological order, you can create a calculated field using Month({your date}). That will give you 1 for Jan, 2 for Feb, etc. Place that in the sort and the data will line up…

Can you use coalesce? Coalesce(`timefield`, 0)

Its hard to visualize what you are describing without a mockup or screenshot of your data. Perhaps the datatypes are not allowing something to total? If I had a list of things and only one column had numbers, I would expect the number column to total but not the other columns. If I'm aggregating totals, I can count the non…

https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/257248/entity-not-showing-up/721058 Is there something you need to check on the back end?

@user015090 - with an html brick (like using images), you wouldn't upload the video to Domo. You "host" the video on a server, youtube, or wherever, and call the video as I showed in my earlier comment. In my test, I pushed a video up to a location I already had on the internet. Then called that video with its URL.

I tried using <video></video> and it did not work. As Aknowles mentions, perhaps something needs to be enabled. CONCAT('<div style="text-align:center;border:0px white;border-collapse:collapse;"><video width="320" height="240" controls><source src="https://mysite.com/image/movie.mp4" type="video/mp4"><source src="movie.ogg"…

I have suggested this as a serious need. Your wording is much better than mine. :)

If you are trying to graph or count occurrences in a dynamic way. I would suggest something like this… Say you create two calculated fields: field_1 and field_2. Field one representing the abbreviation (ie WBH). Field two being the name of the thing (ie. Wabash). Field_1: SPLIT_PART(Campaign, ' ', 1) Field_2:…

I think you are trying to do too much in one column. I would break those out into separate columns so you can see the information in a table display across all companies. Then filter or group by. Lead_Count: CASE WHEN Status='Unqualified' THEN COUNT(Lead ID) END Lead_Total: CASE WHEN Status='Unqualified' THEN SUM({amount})…

And yet, this ideas exchange post shows up in the list as if it is an unanswered question.

https://community-forums.domo.com/main/discussion/comment/63979#Comment_63979 I am the original poster of this question but I don't see it on any of the responses.

@RobSomers - That's what I expected (for it to be under the responders post). But, as in this case….I don't see that anywhere other than your comment suggesting it should be there.

@Zel. You don't need to force your current column to date. If your data is in datetime, create a new field for the report using date() but keep your original so it is maintained for your recordkeeping.

@RobSomers - There's no intuitive button appearing for accept an answer. You have answered my question and I see links for Flag, Quote, Insightful, Agree, Like, Awesome, and LOL. Where is the accept answer link?

Without seeing a dataset or column values, I have to generalize and create some fake data. Let's say I have two tables represented here by webforms. The one one the left contains headers or something representing the titles or bigger things. The right being the detailed raw data. If I am joining the data, there needs to be…

I haven't been using the ODBC driver myself. “Transaction was deadlocked” happen when 2 or more sessions are trying to lock a resource which has already locked by another session. The sessions cannot complete and SQL Server has to intervene. It gets rid of the deadlock by choosing one of the sessions as a victim and kills…

There is no need for pivot tables. Assume you have a webform (in your case the incoming dataset gathered from the alarm system software). You would just put those fields on the card as healthcare name, alarm received, and count(alarm received). Then add sorting and format your labels. And the final result would be a list…

The way I did it in SQL, it doesn't matter how many commas there are. In ETL, I'd have to create something recusive to make sure you can get any number of elements typed into a string. If you know you won't exceed the number of delimited items you show, something like this will work. Using that flow, I then went out and…

As @MichelleH mentions, in the ETL I'd be looking to use split to get the pieces from the string. I don't have a chance right now to try it in Domo, but I did a quick mock up in SQL with code shown below. As I mentioned, I would split the strings to create a table as shown below. Then aggregate the table using count to get…

I'd need to ponder a bit. First instinct - try to break up the string by the delimiter, in this case a comma. Feed the pieces to a table (aka a list) and then aggregate using count.

I had the same issue and was told we can't remove nor customize the information. You might try saving the dashboard to a powerpoint where you can remove that part and then send.