DataMaven Coach

@ST_-Superman-_ - That's awesome! I need to get better at the SQL, so we balance out perfectly! I will put up a solution. I just need to create it. I'm not as fast as you are. I don't know how you do it... Well...yes I do...you're a freaking superhero! LOL 

@ST_-Superman-_ is amazing with SQL Code. Let me know if you would like me to put up an Magic ETL solution. I just ask if we do that, and my ETL works, credit us both with the solution. @DaniBoy is able to make that happen if we need it. I don't want to be a solution swiper when there are always multiple ways to accomplish…

Try sorting ascending by date. You can combine that with a sort by the value to get the bars to lay out nicely, but you may need to play with the order of the sorts to get the behavior you want.

@DaniBoy It was giving an error loading. Wasn't an issue of finding the connector/app. I think the other user couldn't find one thing, but had the loading issue with domostats. I had the loading issue witb the training modules.

@ST_-Superman-_ ... you're my hero. I don't even know I need this yet, but your posts make me wish I could geek out with you regularly.

The super secret workaround we all use... Right outer join instead of left. This keeps people who don't know what they are doing from breaking stuff, but enables the rest of us to go on blissfully joining. It'll seem awkward at first, but in a bit, you won't even have to think about it. You want to set it up to pull all…

Have you tried dragging the date to the filter box and setting a default like you would other filters? Not sure if that would mess up the grain, but wanted to throw it out there.

My workaround is to run them more frequently. Unless the etl is doing something that will impact the result if run every hour, it should be a non-issue. It's a waste of back end Domo resources, but if it concerns them, they can work on a functionality for us to schedule based on our local time zones, and have their systems…

As it turns out, we have to use SharePoint On Premise for this work. I've encouraged the team to get some tests rolling in O365, but we also need to figure out the On Prem. Anyone using SharePoint Connector with On Prem successfully? @ST_-Superman-_ @Valiant @JasonAltenburg @TacoShelly 

Here's what I just built that worked. I ended up retypying it to make it work. I got errors at first, too. CALL word_cloud('fake_phrases','`Statements`' , 'y','y' ); Looking at the error - Make sure that you have run and applied the previous transform. I have missed that 8 out ot 10 times that I get an error! lol Also…

I tried to download some learning modules yesterday and ran into the same issue. I wonder if it's related to the new features rolling out. May be a hiccup. @DaniBoy - Have you heard anything, by chance?

Anyone still looking for this on this thread - this just helped me. Scroll down for the code to handle phrases. http://knowledge.domo.com?cid=wordcloud

There doesn't seem to be an issue. 199.68-(-95.36)=295.04 If you want the answer to be 104.32, you need to add the two values together. 199.68+(-95.36)=104.32 I hope this helps.

@swagner I want to be able to make videos like you some day. Really excellent!!! Of course - the idea is great, too!

@user09879 - The underlying issue and upcoming fix has been discussed and established. Excited for the fix, too! There are still folks who need to make it work today, through a workaround, and need help. That is what the community is here for. Whenever there is a hurdle, even if Domo is working to smooth it, the user…

Here's the workaround we came up with for quarterly grain to come through in order: In ETL - Use datepart function to isolate year and quarter. Combine year and quarter columns with Q as the character separating the values. Because this results in a text output, it will sort properly by default. Of course - we will all be…

What connector are you using? Is it using the other person's credentials to pull in the refreshed data? You may need to update the settings with your credentials. If it's not a credentialed connector, and you are appending, check the field contents vs. field formats. Look for fields in the Domo upload which are date and…

@ST_-Superman-_ YES!!! I was SO excited when I saw that!!!

@James_Thoma - That's one of the things I do, too! ? @DaniBoy - Glad it's on the horizon!!! (Patience? I don't have patience...I have workarounds!)

I got this functionality while it was in beta, and found that I liked it opening the cards in a new tab, but as you work with it, you will find what works best for you. One thing that is a little hinky with the new dashboards is that you have to watch where on the card you click. I often ended up filtering the page when I…

Hi Olivia, There's a little trick I have come up with to handle reporting of multiple metrics, which I think will do what you need. You want to use the 'Collapse Columns' function to make fields for 'Currency' and 'SpendingCost'. Here's what you fill into each blank: 1. Currency 2. SpendingCost 3. SpendEuro and SpendUSD 4.…

It works the same way as the previous set-up. Perhaps you didn't save the page yet? Once your page is saved, you'll see the wrenches you are used to. Simply click the wrench and select 'Edit Drill Path'. If that's not quite what you're looking for, perhaps the card interaction settings will help. They are available while…

There is a capability to publish via URL, but it is a paid add-on. You'll want to check in with your sales rep to get a quote and have this functionality turned on. @imelendez - Do you guys use publications? Any insights to share with Philippe?

Have you tried creating a dataflow off your resultant dataset? It may help the performance of your cards if you do some light etl on the result to lighten the load. You may need it to hit all 14M rows, but likely aren't using 120 columns in your cards. If you add a column in the future that you need accessible in your…

Domo has a really hard time with null values. It's actually not really specific to Domo - null values should be avoided whenever possible in datasets. You didn't specifically say that the actual values are null, but I am making that assumption based on really common challenges encountered by all of us. In your dataflow,…

I believe the only way to do this currently is to hover over the item you want to highlight. This would be a great idea to suggest in the idea exchange!

Side note on this one - It's a best practice to run your data through an etl, even if you think you can just build cards right off of it. This way, when things come up that you want to modify, you can simply update the etl, and all your cards will be seamlessly updated. I recommend to folks to use a tiered decision-making…

So glad I could help, Priya! (Is this Priya from GOSC?)

Thanks @DaniBoy - In the meantime, I will see if I can help folks with a workaround. Jugaad is my specialty! ?

@user09879 - I understand that you reported it, and that they haven't found resolution for you. Others are having similar challenges. Support not having a resolution does not mean that I will not be able to find one. Would you prefer that the other users launch a new question so that you don't receive the alerts? I'd like…