DataMaven Coach

This can also be done in Magic ETL, using the datepart. The difference is that you would take the year and make it its own column. If you can't assume that folks know which year is the current one, you could do mapping that has to be updated annually, though I would hope that wouldn't be necessary! lol You can also…

@user006658 - Did adjusting the format fix your issue? If so, please mark my message as a soution. Thanks! @ST_-Superman-_ - Thanks for adding additional context! ?

That's kind of hilarious! It sort of makes it "idiot resistant"! If you fully understand the logic, you will push until you get a solution because it doesn't make sense to not be able to use reference tables against large datasets. If you shouldn't be playing with such things, someone somewhere will look at your stuff and…

Compatibility is a little dicey in Firefox. I use Chrome, which often works even better than Explorer.

Another possibility is to use the Date Operations to get the default periods, based on calendar year, and then map each of those to the periods they would be in your fiscal year. That would be something you could do without coding and in just a couple of steps. Let me know if you need guidance and/or screenshots. I am…

If you click on the wrench at the page level, you will see a functionality to "Turn on Page Filters". Also - Make sure that your date fields are formatted as dates and not text. If you want to isolate date parts, The "Date Operations" function in Magic ETL can help you make some nice easy filters. See if that does the…

If you click on the wrench to see the options, you will see many of them are inactive. I think there is protection on this that prevents editing. In these situations, I use the sample app as a guide/inspiration, and create cards on my own how I want to. I know that is likely not the solution you were looking for, but at…

I think your issue is the format of your Date Field. In your data flow, you want use the function "Set Column Type". Set your Date column to a date format. This is how the analyzer will recognize the field as a date. I am providing a screenshot of the setting I used for one of my date fields. I hope this helps! If it does,…

Let's see if any of these help: 1 - Have you used the Maximum function with a Date/Time field before? I wonder if it only works on numbers. (I assume you have - just throwing it out there.) 2 - When you run a preview, are you seeing the relevant fields populating in the append query? In particular, make sure that…

I use Box religiously, and have not had any issues when input files have additional fields. As @Valiant says, even if you want to use those fields, the update to the dataflow is quick and easy. If you have datasets with formats that might change, it would be wise to build in a QC mechanism which will alert you if the input…

Go to the Data Center. Click on the Dataset. Click the Wrench. Export the full dataset.

Hi Everyone, Glenn worked with our IT people and found that it's something on our side, and how our IE11 is set up or our security settings. If anyone else is seeing issues, try using IE11 on a non-company computer, and see if that solves your issue. Alexis

Hi Everyone - I have posted an idea for this to be fixed, and also pointed out that this issue does not exist in the downloads to Excel. Repair how Domo handles the 'Amount' field from Salesforce I hope this helps!

Hello - The functionality to add a hyperlink has been added. Are you able to see it now? What's nice is that when you copy and paste hyperlinks from other places, like email, it transfers and functions. Let me know if you have any trouble.

YES PLEASE!!!

That was actually an idea I was going to add to the idea exchange. It would be really helpful to have the ability to add text boxes to Magic ETL so that notes can be added. Updating the names only gets you so far. Sometimes I want to make notes about the dataflow, in general, or sections of the dataflow. 

I can't wait! I had such a great time in March. Next year will be interesting, too, at the new venue! Glenn mentioned the main stage, too. Darn theatre degree...

It's definitely a great experience. The ability to mark things as read or something would be cool, and I will think up a few other things that I know I've bumped into, but it's quite addictive. When I said that I come to the Dojo to search challenges. I was simply meaning to search for solutions for challenges I am running…

Connecting the dots on 'Domo trial' and 'cat mortality'...Been there. I luckily got picked up by a different manager who got behind me on Domo, but we are still fighting with IT for full approval. They REALLY want me to use Qlik or Tableau or Alteryx...UGH!!! Qlik makes me seasick and sad, Tableau is glorified pivot…

Thanks! @DaniBoy The Dojo is dangerous for me...I go in to search something, and fall down the rabbit hole! 

Being the smarter cat can really be a predicament because you have to be quiet about it. My last boss told me that I came up with solutions too fast, and it put people off. He said that when we are having meetings where challenges are posed, to keep quiet, and that he'd ask me for my answer after people have had a chance…

Are you wanting daily exports because you need to maintain a history of daily snapshots, or because you want a current version of the data available? For my daily reports, I use the Excel Plug-In. Each morning, I open the file and it asks me if I'd like to refresh the file. I use the entire page as the area for any pivot…

ok...and sound off next time...lol @glenngrossman Here's that thread I told you about. ?

SnagIt...ahhh SnagIt...when I use other people's computers who don't have SnagIt or don't have the same shortcuts set up, I twitch!!! I have to admit that I primarily use it for region screen capture and some things you'd normally beat your head against the wall using Paint for. But video snippets...I will be exploring…

OK...First...how did you do that video??? Second...I thought this was fully deployed, but I could be part of a pilot phase. They do gradual roll-outs of features sometimes. Ask your technical consultant or other contact at Domo how to get that functionality (not sure what phase of the process you are in). It's really…

How you highlight matters on this one. You have to right click up where the B is. For the rows, it's the same, but you click where the row numbers are.

The webform would be a good solution, except it has limited formats you can use. Checkboxes are not one of the options. Perhaps someday.

On my pages where I have webforms that I want people to update, I include the following instructions in a notebook card: To Add/Edit content: - Click Wrench - Select "Connect / Update Data" - Select "Edit Webform" - Make Changes - Save & Continue I hope this helps! 

You've probably seen by now, but this functionality has been added! Yay!!! Next thing we need to rally for is Filter/Sort capabilities!!!

It's a little complicated, but your friends at Domo can help. Step 1: You will need a MySQL DataFlow, which is specially enabled to generate a Webform. This is not something you can do on your own. Step 2: Use the dataset as the input in the above query to create the webform. It is important never to delete the resultant…