swagner Contributor

Camtasia - let me know if you would like to see examples.

One of the things I have done to engage users in our instance is by using videos as I answer user questions. When I receive a question from a user I make a video response that demonstrates how to answer their question in Domo. I have a page in our instance that contains all of those user questions (which is searchable) and…

Thanks for the quick reply! Really hoping to find a solution for this with a Beastmode. Would be a much faster solution to implement if it's possible.

I am tracking this as follows. * I have an Excel list of my Domo users * I created a Magic ETL blended my list of users with the DomoStats Activity Log * The ETL provides a count of the field Action = LOGGEDIN for each user * I then produced a card, and filtered on users with 0 in this count

Unfortunately an SQL solution won't help me in this case. It needs to be dynamically calculated in at the card level.

It's working! I was able to work it out by doing a bunch of the row calc in the Magic ETL instead of doing that in the Beastmode. More detail in this video: https://youtu.be/h9YTqTEYXKo Here is my simplified Beastmode after the changes I made: `Current Head Count` - (FLOOR(`Required Resources`) + CASE WHEN MOD(`Required…

How would I approach this rounding issue in the Magic ETL? The calculation step only contains very simple math operators.

First, the special rounding solution you provided is working great! I am getting a strange summary number/column total I wanted to run by you. When I export the table data from Domo to Excel and sum the column I get a value of 13, the summary number and the total on the column in the Domo table card is showing as 24.…

Doh! (in my best Homer Simpson)

With the beast mode: * Number of Lines: COUNT( `2nd Item Number`)

There isn't a field in my dataset named `lines`. I have a beast mode now "number of lines" (details in my orginal post). Is there a way to alter the solution you provided to use my "number of lines" beast mode?

Thanks @Valiant, I appreciate the BeastMode help. Still hoping for some ideas on the Magic ETL.

For example, would want to filter where the result is >$5000 only. Regardless, would like to know how to do this in Magic ETL if possible. Thank you

Just tried, this is what I got:

This appears to be a SQL function. I'm looking for info on a beastmode function. I may have mistated the syntax, should be: APPROXIMATE_COUNT_DISTINCT()

@DaniBoy no replies on this one sir. I've asked a similar question in this discussion, no resolution there either. Can you provide some feedback, possibly have a Knowledge Base document created to address this request please? If this is something that cannot be done in Domo lets discuss alternatives - what other methods…

Thank you for taking the time to provide the detailed answer! This is awesome! I had already started working through the solution @zcameron had provided (which worked exactally as I needed). Great to see another approach - learning opportunity!

Thanks! Working through this now.

@DaniBoy this is still an open need for me. Have not been able to address how I described in my post earlier this year. The addition of subtotals to tables gives the ability to do a % of total, but the formatting is problematic - especially when you don't have multiple layers of sub-categories. Notice how the % of total is…

I've tried a few times without success to change my existing Beast Mode to include what you've suggested and I cannot get it to work. Can you show me the completed Beast Mode instead of just those suggested lines please?

@ADerbak Here's an example of a beast mode I am using to calculate sales PYTD: sum( case when `Invoice Date` <= DATE_SUB(DATE_SUB(CURDATE(), interval (DAYOFWEEK(CURDATE())) day), interval 1 year) and YEAR(`Invoice Date`) = YEAR(DATE_SUB(DATE_SUB(CURDATE(), interval (DAYOFWEEK(CURDATE())) day), interval 1 year)) then…

@user06886 you could group those categories together via a case statement, and then use the card drill path to display all the sub-category items.

@user006624 Yes, this can be done via the dataset schedule. Minimum refresh time is every 15 minutes.

@wgechter you could handle in Workbench via the "Schema" section of the dataset job, or you can address in Domo via MagicETL. Take a look in the "Edit Columns" section, and the "Set Column Type".

@user01162 maybe can help with some more understanding of your dataset. Here is a Knowledge Base article on the donut card type that might be useful: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Donut_Graph 

I had a meeting yesterday with Ryan Moody and Zack Cameron from Domo and I took the opportunity to ask them for help. They gave me the solution! In am posting this in case others have the same question. Here is a short video I put together that provides the solution. Please hit "LIKE" if you agree using videos like this is…

Thanks @ADerbak, but the UCL and LCL do need to be dynamic for this to really be what I need. Don't forget, if you support the idea follow the link to the Idea Exchange and "Like" that post please.

@user005775... I forgot to tag you.

@Mohit If you haven't already, you might try using Domo in Safari or Google Chrome on your iPad. I have recommended this to my users who are avid iPad people and they're feedback is that the experience is much better in a browser than in the current release of the Apple app. I heard at Domopalooza that improvements are…

Open the card you want to export to PowerPoint. * Click the export button (top left of the card - looks like a box with an arrow sticking up) * Choose "Export" * Choose "PowerPoint" There you go!