Comments
-
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…