ArborRose Coach

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 : name of card, suit, color (for bower identification) and value. A field to…

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…

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.

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.

I believe damen is correct and qualifies for this badge. It appears that the comment came after Dani became a deleted user. Who at Domo assigns the Domo admin badge to those of us who admin our Domo domain?

Seems like you would have gotten D and E. Can you change the “What happens when column types don't match?” to show type errors and see if it gives any indication?

I don't believe this can be done without a change to the Domo chart code. It's the way the period over period is coded. The value you circled in green is also the value represented in the area circled in red. Filtering it from one also removes it from the other.

I think excluding 0 and 12 would just remove it from the bars, not the lines. He's probably got a range set for 1 through 12 to prevent 2023-Mar from showing.

As Michelle mentioned with the case statement, I was thinking you would need to do something like that for both the current year and the previous year. So when any year/month falls into the scope of your chart, there would be an on/off bit preventing both from showing.

Have you tried period over period chart type? Select your date range and how you want it graphed (by week, month, qtr, etc). And then select compare to 1 year ago.

I had not tested with Powerpoint. After responding to Jessica's comment, I created a new image card using the code I pasted in this conversation. It worked. I re-tested export as PDF and it worked as well. Then I saw that I still had the original profile image card so I put it back onto the original dashboard..and it also…

Thanks for the comment. I have since removed the photo from the dashboard. Our need was for pdf or graphic output, not Powerpoint. My guess is that if it failed to export on PDF, it would probably fail on PowerPoint as well.