DataMaven Coach

In case this is still an issue...You probably have null values...which Domo HATES!!! Since it's a running total, just add a dummy set that adds a zero value for each period so that the thing has something to add to the previous total. That may do the trick. Hope all is well!

@RobynLinden @Valiant - This seems like it should almost do it, but I think Valiant could be right. Beast Modes are too adaptive, so I think it's not summarizing. That would mean that it needs to be done in the ETL. His is showing in SQL, but it would be easy in MagicETL, too. Let me know if you are going that way, and…

EEK - yes it is - duh! It does need to be date where I put City. I meant to test that, but then my brain said the city was the right answer because it was for that sub-set. Working on better anwer!

YAY!!! Teamwork! 

@DaniBoy Is it possible to label @Valiant's answer as a solution, too, or can there be only one? He was the one who came up with using the MIN function. I wouldn't have been able to solve it if he hadn't already gotten it started!

The new Governance datasets are great, so do a search in the Appstore. The dataset id's are in these tables, too. I created beast modes to have clickable links in table cards. Thought they may be helpful to you. Just update the company in the concat statement. Let me know if you have questions. I've been having a great…

I passed the link to this thread on to Nate Wolf, who was closing an issue I'd had. I'm sure you'll hear from him. He's very responsive. (If he fixes you up, do I get a solution? lol)

This is why it's a best practice to always create a dataflow, and not create your cards directly from input datasets. There is almost always sometihng to update. Just in case you don't already know this, you can easily switch all your cards over from one dataset to the other in bulk. Let us know if you need info on this.…

Your post doesn't really give enough information to hazard a solution. If you don't quickly get a solution from support, perhaps you can post some screenshots or more information about the issue you are facing. One thing that comes up a LOT is date format. So - First thing is to make sure the date field is in date format.…

Open analyzer, select dataset, select 'Maps' chart type, select appropriate Map. Modifications may need to be made to your dataset to align with the particular map's recognition of locales.

@DaniBoy I think this may be a nepharious link. Be careful.

It looks like this is a common challenge. Check out this thread. https://dojo.domo.com/t5/Data-Sources-and-Connectors/Workday-dataset-issues/m-p/16760 It's old, so @MattGo and/or @tseamans have hopefully found solutions by now, and may even have some tips for you. I hope this helps!

When you say you haven't gotten connected yet, do you mean you want the schemas for the Facebook datasets before bringing them in? I'm not sure that is possible to pull without bringing the datasets into your instance. There are multiple Facebook apps and many tables available within each of those. You can always sign in…

You may be able to request the Design Dashboard, which is in Beta, to be turned on in your instance. It's pretty great, and the filtering is fun to play with. You can set how the page filters function, as well as the interaction when you click on each card.

"Whoops! Something went wrong." is often a system issue, I find. It could be a hiccup in network or something on the Domo side. Although, the fact that it also flips to "Invalid" is curious. This is a bit like asking if you've restarted your computer and cleared cache...but... Have you gone through your transforms in order…

Are you needing to filter those rows out completely, or do you want to improve your filtering ability in your visualizations? Is this a text field or numeric? If you want to keep the rows, but need the null values filled in, you can use the mapper. This works for both text and numeric fields. If you are simply needing to…

You can try putting the whole thing in a beast mode. You'll notice the seemingly pointless concatenation, but that is the trick to making the beast mode available as a summary number. CONCAT(MIN((CASE WHEN `Date`>CURRENT_DATE() THEN `City` END)),'') If you name the beast mode 'Next Up', it will show the city name and say…

One small adjustment...In the Admin function, you can move pages and subpages. It's quite handy. I agree 100% that we need to be given the ability to move collections and/or the ability to select multiple cards when using the move/copy functionality.

The requirement to not use Workbench is sometimes a requirement of the user's company. I know that our IT department requires us to not use Workbench. Don't ask about the logic. It's mostly to hamper our success using Domo and increase our dependence on IT.

But @Valiant...I need it to be dynamic, depending on filters...any thoughts? Any new developments? PS - Why did you change your name?

I am actually looking to use this feature in Beast Mode because I need it to be dynamic. I need to rank to update, as filtering occurs. I don't think this would be possible with the ETL.

@Valiant - I think she wants to get rid of the decimal places, but not the values. @user07401 - I have managed to get rid of decimal places in the chart and the hover, but not the legend. I think for the legend portion, you will have to follow ValiantSpur's advice and remove them. Make sure that in 'General', the value…

I have the Domo Metrics tables, and have created some dashboards. I noticed that you mentioned wanting to know how to tell who are Domo Employees and who are not. In the original Domo Metrics tables, there was a field which flagged them. If that is not there, you can definitely use the @domo.com ending of their email…

Thank you @AS I really appreciate you checking and providing some leads. It's good to know that it's not some obvious datasource that I've missed! The biggest challenge of this endeavor is that I need the headcounts of the companies by country. Everything I have found to be readily available has been either a rolled up…

Hi Randy, I am glad we are getting there! I think that if you the value mapper, you can make a column called 'Status', with a default value of 'Closed'. The value to search for in the ActualClosedDate field will be Null Values, and that should enter a value of 'Open'. So - The entries in each piece of the transform would…

WOW - and I just saw the dates on this! I don't know why Dojo showed it as a recommended thread in the sidebar for me!

Hey Guys - The timezone issues are plentiful, and are consistently in the ideas exchange. If I don't already have one in there, it's on my list of things to add. I had to eat some serious crow when I realized a Salesforce report I had scheduled to run on the first of each month, with criteria of 'prior month' ran on UTC.…

How to solve it really depends on exactly what you are looking to achieve, and I'm not sure that I am interpreting right, so forgive if this is not spot-on. It sounds like you want to see the orders which are not closed, but also don't share the same unique identifier as a closed order. ***For both of these solutions, you…

Hello - You will need to set up a recursive query. There are a couple of ways to do this, depending on your process. Solution #1 - Create a dataflow which generates your output table. Save and run the dataflow. After it has completed running, make the resultant table your input table and modify the steps between your input…

@ValientSpur is right - That capability is in the pipeline, but not here yet. You may be able to reach out to the product team and ask to be a beta tester for that feature. I'm not sure what stage it's in for development, but that would expedite it a bit for you.