AS Coach

Ajith, right? That's an interesting question. Since Domo's in the cloud as a SaaS solution, it's pretty much always up to date. If you're referring to Workbench, it's version 4.6 that's the most up to date and can download now. We're on 4.62 something.

If you have a SQL query, you probably want to use Domo's Workbench application to connect that query output to your Domo instance. Then you can schedule the query to run at regular intervals and update the data upon which your card will be built. Workbench is usually installed on a server that has a DSN configured with…

I haven't implemented one myself but I've seen one or two using something similar to this https://bl.ocks.org/mbostock/4062045

That very well could be. Window functions aren't supported that I'm aware so I don't think there's any documentation to help out yet. It's all trial and error, hope and dissapointment for now. Lol.

That link is at http://knowledge.domo.com?cid=createtasks One assignment option would be to make sure everyone is aware of who the Majordomo is and assign projects to that person from his/her profile.

I think you can only add tasks to private projects that you have permission for as well as public projects. Admins can see everything and add a task. One option to consider would be to create a public "Domo Issues" project. By default everyone should have access to that project if it's public. In order to add a task like…

Sorry, nothing that jumps out in my mind right now.

@ST_-Superman-_ is correct. Filtering on aggregations is one of the top-requested features, I would estimate.

Hi @wogan As long as you're the data owner or an admin (and probably not using the free version), you should still see PDP options in the data center. If all of the above checks out and it's gone for you and other admins, check in with Domo Support.

Yes, this is definitely possible. We have a number of such cards in place. The first thing to remember is that your card needs to NOT be filtered to just this year. If you do that you'll be missing last year's values in the data and can't do the comparison. So don't pick "This year". That trips a lot of people up. The…

Hi @cwolman I don't believe page filters can include beast modes. It doesn't work for me, anyway. 

Are the values correct that we're filtering on? Like, are the capitalizations correct? Those are pretty specific strings to match.

I provided similar feedback to Domo a while back because of a similar circumstance. In my list of tasks I can't see what card I was referencing, and in my card I can't see the specific task I created. It's definitely helpful to create a task straight from Buzz, but it's really an incomplete experience. I never did hear…

How about something like this: SUM( CASE WHEN `Item` = 'ARM' AND `Opportunity Status` NOT IN ( 'closed won','lost') THEN 1 ELSE 0 END) And SUM( CASE WHEN `Item` = 'ARM' AND `Opportunity Status` = 'closed won' THEN 1 ELSE 0 END)

This might be a problem with the way Domo has implemented mySQL CTE functionality. Instead you could try listing your cte1 and cte2 as subqueries in your FROM clause.

What is the erro message you're seeing? It looks good to me except maybe your join. Try ... FROM cte1, cte2 WHERE cte1.`pfa type` = cte2.`pfa type`; OR ... FROM cte1 join cte2 ON cte1.`pfa type` = cte2.`pfa type`;

Using MySQL dataflows you should be able to create a stored procedure to help you loop through the values and create more rows. This stack overflow post would be a good starting point: https://stackoverflow.com/questions/17308669/reverse-group-concat-in-mysql

That's pretty strange @ShaneB. I know you mentioned your value column is a number. Can you double check that maybe? How are you displaying the output of the beast mode? Can you try a table and verify that the raw value is being calculated correctly? Maybe send a screenshot.

There is a function called SEC_TO_TIME() that would probably work for you. Are your values in minutes? Try this : SEC_TO_TIME(2.25*60) -> 00:02:15 Are your values in hours? Try this : SEC_TO_TIME(2.25*3600) -> 02:15:00

Hi @DataMaven Are you looking for a list of companies with their employee counts? You can individually check LinkedIn or Glassdoor pages as well as company websites. In the US you should also be able to find SEC filings for publicly traded companies, and those documents should list employee counts. But that's all done one…

Hi- In a previous position my team tasked with doing something along these same lines: hundreds of similar as well as disimilar sheets that needed to be uploaded into a single dataset in Domo. You can connect data multiple ways into Domo. With its API streams and connector library specifically, the Domo out-of-the-box…

This is a beast mode, right? In it you're trying to compare a single row of data to a conditional aggregated value. Beast mode doesn't like that kind of comparison. It likes columns vs columns or aggregations vs aggregations. You'd have to bring the data into a dataflow to get the counting (find the count then apply it to…

What you want is an analytic function that evaluates the max of the ID window and adds a column with that value. See: https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Analytic/MAXAnalytic.htm Domo has done some work on beast mode window functions but they aren't currently available,…

If I recall it was my customer success manager that worked it out for me. I don't think this plugin is a mainstream thing yet, so it might have bee the labs team that put it together for some customers.

Does your resolution date get filled in once the ticket is resolved, or is that more of a promise date (create_date + 5)? That might determine the exact parameters your datediff function receives. In general, your beast mode could look something like this in order to group your tickets. This assumes your resolution_date is…

You can do custom beast modes to create your bins. Something like: CASE WHEN `days` >= 0 and `days` <= 30 THEN '0-30 Days' WHEN `days` > 30 and `days` <= 60 THEN '30-60 Days' WHEN `days` > 60 and `days` <= 90 THEN '60-90 Days' WHEN `days` > 90 THEN '90+ Days' END

I must have misunderstood, then. I was thinking you wanted to keep the time and graph bars down to the second, but only display minutes on the X Axis. I don't know how to do independent axis labels and charted X axis values.

Oh, that's a really interesting use case. Thanks for the extra detail. I can't think of a way to do that. Maybe someone else has an idea here, but you can reach out to support to ask for help.

Taking @ST_-Superman-_'s example and just inverting it a little bit, what about: AVG(CASE WHEN YEAR(`Date Field`)=YEAR(CURDATE()) AND MONTH(`Date Field`) = MONTH(CURDATE()) AND `Status` = 'Break' THEN `TotalDurationPerdayInMinutes` END) + AVG(CASE WHEN YEAR(`Date Field`)=YEAR(CURDATE()) AND MONTH(`Date Field`) =…

On the admin screen there is not a way to see a list of names. However, there is an Excel plugin you can get from Domo that allows you to download administrative data like that: There could be ways to automate this data so you can view it in cards as well. You might want to get in touch with your consultant or account…