G_Grey Contributor

Hey! Today I learned, thanks for sharing! Thanks @MichelleH

Hi, thanks for your response, agree that card descriptions can be useful and have their place. Card descriptions serve a very similar function to a text box, but with more formatting issues. The key function I'm trying to zero in on is the ability to show/hide explinations of underlying data on a card. This doesn't quite…

@Scotsman143 -- I did find a solution but it's not the most ideal. As long as the filters contain one 'like row' then the dynamic filtering works properly. Even if the field is null. So, here's my dataset: Then I do some beastmodes -- such as this one that takes a var: SUM(SUM(`Whacks On`) FIXED (FILTER ALLOW `Campaign`))…

@creed Thanks! I try to be hyperbolic and keep things fun with my posts, glad it's appreciated!

I wonder if adding metric B is messing with your lag function. I'm speculating... But is it possible that just because you're filtering on Metric A in your first case statement, it doesn't necessarily create a new table that excludes B? That would mess with your lag calc because it's at the row level wouldn't it? Edit -- I…

Can you provide a little more commentary about what exactly you are looking to solve for here? It looks to me like you've already figured out the solution. If you're looking to calculate numbers based on different filter criteria I'd recommend using a CASE statement on a beast mode or in magic ETL to solve. Pretend I'm…

I'm a big fan of if it works and gets results fast without being a huge resource sink then don't over think it. When it comes to comparing periods in my shop I like the ability to use any chart I want rather than being restricted to period over period charts. So what I tend to do is append one dataset to itself, increment…

A couple of ideas on this -- 1.) Some visuals, although not the table card, have a feature called annotations. Depending on your table structure you could show a data table below a bar chart (or another chart that supports annotations) to leave commentary. Here's an example where I call out 'look at all this cake' when…

You should be able to resolve this by using replace text in Magic ETL. Here's a screenshot of where to find it: In this example I have this highly complex table, behold my unstoppable data prowess: Then by adding replace text and replacing "." with an empty string the output table returns this: Hope this helps!

Love this idea it would be super powerful. I often find myself debating where to put filters on my dashboard or even if I want to create multiple filters of the same type for my users experience. Freeze panes on key cards general would be a nice to have (not just filters), if I had a few 'master cards' that could always…

Not sure if you're already aware of these features -- but my users have found it useful and they do what you're describing. Solution 1 -- When you click on the title of a card you can choose an option (pic1 below) to schedule as a report. Within the next window you'll be prompted if you want an excel sheet attached with…

You might know about this already but in several visualizations there's a 'scale abbreviation' option that does what you're describing. It's not always available for all numbers in all visuals all the time, but it might help you in a pinch.

Upvoting, agree and posted about this last week. Glad I'm not the only one. ^_^ https://dojo.domo.com/main/discussion/56737/can-you-paint-with-all-the-colors-of-the-web#latest

And also add cross joins -- making a column with a value of 1 on each table and then joining on that is a work around, would be nice to have as a feature.

There's also this but I haven't played around with it much.

Our users want to interact with DOMO in this way as well. There's a few ways to go about this... variables are a cool feature if the values don't need to be saved. Alternatively you could have them fill out simple inputs on a google sheet as a method of capture, pretty good option if you don't need to be married to excel.

The quickest way I would solve for this is by putting a date range into the analyzer like so Alternatively you could probably do something like this as a beastmode then filter if NOT 'not my date'

Oh! Oh! Add the ability to autodetect if a join is one to many or many to many too!

Sir, there may be children on this forum. Those tables appear to have mature content! -- take my upvote

Side Note: a beast mode could be created to make a flexible time filter that looks forward and backward could be used as a work around. Just incase someone is trying to make something like this happen today and it's a high priority. Drop kick those work arounds! Post ideas :)

Agree

Also! On card backgrounds add an opacity option. You might be surprised what you find under a card.

@DavidChurchman Totally aligned, I use bullet charts all the time. I think this is really helpful to point out on this post because I adore bullet charts. The limitation that I run into is that the business wants to see more than one singular sales bar (so a stacked bar) and they also love the 'bar symbol' tremendously. So…

Want to really rock their world, add multiple lines! Seeing a sales bar punch through forecast line, budget line, and some other goal line exceeding multiple expectations. Oh man. The more lines the better!

bonk Figured out the answer right after posting. Add multiple fields using a comma. 🧐 AVG(AVG(`Score`) FIXED (FILTER ALLOW `Where Monster`,`How Monster`)) Might be helpful to add an example like this to the domohelp article.

@Billobi can you expand on this concept a little bit more. I've been tinkering and I'm running into an issue where, even with fixed functions, if because Campaign1 and Campaign2 don't share at least one common row the chart bombs out. This is the dummy dataset I made Gave myself a lot of options for summing.

@Billobi thanks! I think that will work, this actually exactly how I handle looking at same time last year and forward looking prior year analysis flexibly. The only issue (to your point) is it's a clunky and awkward way of ETLing the data. I'd love for DOMO Team to develop a solution more custom tailored to addressing…

@GrantSmith thanks for your reply. I did look into this but it doesn't seem to solve the business problem. Variables appear to be extremely useful if I need to pick a number or a date, however when it comes to strings they appear to be extremely limited. Very powerful if I want to build a button that says pick units or…

@GrantSmith thanks for your reply. I did look into this but it doesn't seem to be able to solve the business problem. Variables appear to be extremely useful if I need to pick a number or a date, however when it comes to strings they appear to be extremely limited. Very powerful if I want to build a button that says pick…