DataMaven Coach

This is a HUGE liability! Not being able to review how, where, and when tokens are being used not only poses a security risk, it also makes offboarding essentially impossible. We need to have some way of identifying how access tokens are used, especially since they are sometimes used for activities other than their…

@MichelleH - that's exactly what I am working on doing. It will be a pain for everyone, but will hopefully help.

@Joe_M - Those fields aren't something we will be able to give you much guidance on, aside from advising you to chat with the owner of the dataset. If these are not fields directly from the original dataset, there is a dataflow (or view) which is generating the dataset, and that's where you will find the logic. However,…

That's exactly where I am going with that! 👍️ I am in a credential nightmare right now. Hundreds of datasets where the credentials belong to about a dozen former employees. Can't delete the users because their profiles own credentials, and the ownership can't be changed. Ownership of everything else is simple to change in…

Done!

Here's my current find and replace list for the json. I don't have the multi video one, but if you search for amazonaws in your json files for your courses, you will know there is an issue there.

I am looking forward to deeper engagement and commitment from Domo in this space. Account teams should be directing users to the Dojo. It would be a huge win for Domo because so many first level support questions can be answered here. Perhaps cost savings on support could then be allocated to rewarding those who are…

And yes - In my beast mode comment, I was just breaking it down differently, using what was already typed. I didn't make an example and test it or anything.

You need to play with your parentheses a bit, I think. Depending on exactly what maths you are looking to achieve, this may help. Though, this assumes that you are including the multiplication step in the denominator. Not sure your order of operations. Throwing the sum around all of it may help with the date issues because…

This should be done in dataflows. There needs to be data integrity and audit trail in place. Deleting rows from source data is a slippery slope, not suitable for an enterprise platform.

You can currently do this. Check the 3 dots next to the field. There are some great features for the calculations, as well as the existing fields.

Upvote!

Link to Domo's Dashboard: https://www.domo.com/coronavirus-tracking @LLucinski

An observation...the Earth is heavier than any of its parts...In searching for swanky icons, I found that the 3-D flag icons are always floating, but the planet is not! lol

@imelendez ... Didn't I harp about null values in our work together? LOL Domo does not handle nulls well. Get rid of them in your ETL before the card. Beast mode is fine in the interim, but you know I always want it firmly built in ETL if it can be.

Did this help you solve your challenge?

Did it help?

Great Suggestion @Godiepi! I often forget about using Rank! I agree with @bdavis, and was about to suggest adding column selection in the front so it doesn't have to chunk through so much. You also may be able to remove the 'Remove Duplicates' function if the selection of Rank=1 does the trick. It seems small, but it's…

Mark's solution is what I do when the groups are fixed and can be calculated. You can run into trouble with some filtering, though. I have found that creative use of the RANK function can be helpful. Here's a sample of one that you can start with and explore: RANK() OVER (PARTITION BY `Category` ORDER BY (Sum(`Amount`)))

@SumanK - It's recommended to use a 'Group By ' function to aggregate after the collapse/uncollapse work. That will resolve your issue prior to the card building.

@Figauro - You can demote folks from Admin, and leverage the 'Default' sharing group. That will help with the datasets, cards, and pages. Non-Admins won't be able to see the dataflows of others, but it sounds like the datasets are the main concern. There are a lot of bulk sharing techniques that can help you with that,…

Did you try just 'JOIN'?

I would assume that he needs an account, and it would need to be Editor level. Was it in Domo that you were able to have a non-user edit data, or another tool? Once he's a user, you can grant him 'Can Edit' or 'Co-Owner' access to the dataset. If you continue to have issues, send some screenshots of the dataset settings…

Is it not uploading if it's null, or are you finding that when you try to filter a card on null, it says there are no results? Domo does not handle nulls well. If it's the latter, you need a dataflow which replaces null values with something. Since it's a date field, it will have to be a date, which can be 1/1/1900 or…

Are you doing any transforms that can't be done in Magic ETL? It has a tile for date operations, which handles this really well.

@DBandrew - Freakin' BRILLIANT! That's all I've got to say...

@DannyLewis - It looks like @AS solved your initial question, but it isn't marked as solved. Would you mind giving that nice little green checkmark?

Can you provide an example? Perhaps the info below will help... The initial question, it seemed, was to see how long it has been since they last ordered. Steps for that would be: 1 - Group By - You'll use this function to create a summary (Likely just 'Client ID' in the top section). In the bottom section, you will include…

@deefalcon - Did this solve your issue? Been a while, but want to make sure the solution gets in if it helped you. Thanks!

@user053008 - Is there more information you can provide? What was the page? Are you an admin? Do you own the page?