HowDoIDomo Contributor

Thank you!

I can't rename the date fields since they come from their respective connectors. I'm trying to create a new date field in MagicETL, but not sure how to get the dates from both columns into one

Thank you for the information. @MichelleH You're right. When I rewatched the clip, he hovers over the 3rd "combined" card showing a described datafusion.

Sorry, I had completely missed your response. The issue I've bbeen having is that it prompts me to log in through facebook, but facebook doesn't recognize the instagram login.

XLSX :)

Hi Grant, I set it as a string in the schema, but the leading 0s are still dropped.

😓 I don't think so. They only date marker they can think of is the upload date. But, the dataset is set to replace. :(

Like @tbrock, I'm in a similar situation. Have you found a resolution?

I was about to post the same thing. I am trying to compare the previous 2 years. So, "Previous Year" and "1 Year Ago" can be confusing.

Hi John @DashboardDude , Thank you so much! That did the trick. Plus your tutorial was very easy to follow. I've already bookmarked your web page for the next time I need help. Thanks, Carlos AKA HowDoIDomo?

Thanks for letting me know. In that case, I will submit a ticket.

Thank you for letting us know!

Sorry, the workbench was pulling data from a hidden sheet. I realized it was user error.

Are you using Workbench or uploading directly into Domo.com? For me, I usually need to refresh my browser before any datasets or cards reflect the new data. If you're uploading directly to your Domo.com instance, have you considered Workbench or a different connector? It may work better.

Moneyshot, not being able to delete your thread isn't a bummer at all. I had the same issue and found the solution thanks to you!

Thank you, Mark!

I had to disconnect. Who won the escape room? 🤣

DONE

These sessions should be more than twice a year. Just saying :)

Thank you, @MarkSnodgrass. That did the trick!

I'm not good at Beast Modes. So, I personally would just set the date range in the top right corner to stop on August 31st if it's available. 😅 The downside is that you have to remember to adjust the range at the start of each month. 🤔

It works manually. But, I'll try adding a new a new connector and see if that works. I hadn't thought to try that.

Thanks, I'll do that!

At my work, we use a local shared workbench server that's always running in the background for reports that need to updated regularly, usually around midnight (since we're rarely logged in at the time). While this specific server uses the same login, we use the "impersonation" function under "configuration" to access the…

Thank you for clarifying! I was really confused about this earlier today 🤦‍♂️

Hi Paulo, I'm not sure how to do this myself, but am very interested in learning how as well. Have you seen Making a top 5, bottom 5 filter card — Dojo Community (domo.com) or filter top 10 — Dojo Community (domo.com)? They may be useful for your situation. Otherwise, I'm sure one of the resident experts will come help!

Like zcameron said, I like being able to see how others are using DOMO and how I can use it to support my company. I love the fact that there is such a robust community that I never have to wait long for someone to assist me. I still have a lot to learn about how to use DOMO effectively. But, what I do know for sure is…

NVM, I selected "Upload even if data hasn't changed" in the configuration and it worked.

So, I am trying to do the append rows, but then everything else becomes null except for the rows that came back null during my joins. I don't know what I'm doing wrong. I tried doing select rows to get rid of anything that would be a duplicate, but then I started having null data issue again for 3 columns.

What are the cases where it can't return the data? because I'm banging my head against a wall trying to figure out why the ETL keeps dropping my data on a full join. Also, the linked video is blocked at my work due to being on box.com.