NewsomSolutions Domo Employee

@Jones01 Can you elaborate on that feature?

This would be very nice to have. It does not currently exist to show a visual of what is coming in. I think this may need to move to ideas exchange.

the only want I can think of getting close to that is do something like a 'line + grouped bar' and then make the sales the bar (Y axis) and the rate the line (series).

@MarkSnodgrass - 100% agree. This should be an option for the Admin to turn off/on or allow the user to ignore forever if Admin.

I can't think of a way to do this on the same page. You could change your interaction and nav, someone, to a different page, but moving them around on the same page with html anchors in Domo may not be do-able out of the box. If you had the right licensing you could build a webpage, use Domo embed, and handle your…

You can change the week display in company settings, but what you're asking for here I think is different. You can set up a fiscal calendar and just use it for the 3 cards you need it for, this link will show you what you'd have to do to get it. If you just wanted to change the order of the display of the dates in your 3…

I figured it out. I think it is still a bug but here is what happens. If you have a field from the datasource going from slider to preset works fine. If your date is a beast mode created date (say to get the names to line up across datasets), it does not work. It works fine on a slider, but not a preset.

Thanks @MarkSnodgrass , Yes, I've used them too but I'm getting some weirdness here. Take a look at this. Original - Slider: slider Date Change the same filter to presets: Notice that on the presets, all the datasets that it previously had been connected to have been dropped (I don't have screenshots of those, but they…

Thanks for all the replies. I think what I'll do is create a filtered annotation google sheet offsite and then for my annotation, tell the user to reference that cell. So that way people that may not need to see the annotation won't/can't and reduce any confusion. Maybe I'll do something like "Filtered Annotation Note…

I'm pretty sure the fix is just to reduce the height of the taller cards on your publication.

If the file includes the data you can set your filename to use it...filename[yyyy-dd-mm].csv. But if you don't have that luxury and it is just filename.csv and filename.csv...or whatever...the workbench connection should only be picking up the most recent file. So if a file is dropped in there daily, just run the workbench…

@user08142 2 questions and you've probably already looked here but just a thought: 1. Have you tested the connection to the SFTP server with something other than Domo to ensure the credentials were valid? 2. Have you opened the csv file to ensure that it was saved as a csv and doesn't just look like one? May not help as…

@MalcolmChaney you realize they are rounded when you're previewing the data inside of Box? Is that where the rounding is occurring? You mention "once the data ends up in domo the field data type is correct" does that mean the problem does not exist in Domo and just the preview in Box? Sorry for all the questions, I'm just…

Did you add that nested page to the allowed pages in the Publication Group and all the datasets in it?

If you're talking about doing it through the page directly it isn't do-able right now to my understanding...they just show up with blank boxes. With the new update with more options for images in Stories that may change I guess....anyone know? I've exposed branding images in the past using the URL of the image in a…

If the schema is the same for each file you could combine them into one. With a mac I think these instructions would work. I have done it on a windows system, but not a mac. https://www.anitaowens.net/blog/2017/5/7/how-to-combine-multiple-csv-files-using-mac-terminal If the schema is different then you could just upload…

@remember_Sagan Your co-worker was right on the filter/constant for Magic ETL. But being better than SQL is hard to say. I say that because yes it may be more complex to set up this situation in MagicETL, but the performance of the execution of this ETL will most likely always be much better than whatever you did in SQL.…

@LanesaS are you logged into Domo with Chrome on the same computer when you try to do this (with ppt)?

So when you go to the Domo tab in PPT, then over on the left you hit 'connect to domo', new acct and in the box you put just the company name or whatever it is you have and hit authenticate another box or something with your open/connect browser version of Domo doesn't pull up it just returns an error? Can you share what…

Congrats @ST_-Superman-_, @TheDean, @JesseK 

Good catch @tadashii 

Save the card as is with the BM in there, Close your browser and try again, The code looks ok and contains an aggregation..and if it runs in like a table or something it should work on sum num,

@AdamT I know this is super old but wanted to say thanks for posting that. I had a use-case where I needed to do something similar and was able to do it in ETL's rank and windows vs MySQL. But not sure if Rank&Window was an option in 2016, I can't remember. But posting this in case someone else sees this old post and needs…

I'm guessing you're asking how to do this? One way you could do it is use a single bar chart, then in the data label settings use the percent of total macro to show % that is gthen and % that is lthen from the total.

Not sure about the 'forced logoff' issue, but they have an apple TV app for just this scenario if you can't get it worked out on a browser. https://knowledge.domo.com/The_Appstore/Available_Apps/Apple_TV_App Hope that helps. Matt *Please like to thank.

The totals row is derived in Domo. So when you export to excel it is just giving you the data from the table vs the add-on rows that Domo came up with for totals. It shows up in a presentation/report because it is a view of the card not export of the data. Hope that helps Matt *Please like to thank

Both Dataset and Dataflows have a History tab at the top when you are in it for properties...it should show you run times there. Matt *Please Like to Thank

@user14877 I don't believe there is a way for you to hide/display cards based on data results. At least on a dashboard/publication group set up. I'm guessing you don't want people to see 'no data generated for this card' type message when no data is available for them? If that is the case you might be able to create a row…

I think you'd be better off doing a BeastMode and doing a case statement something like: case when field = x then numerator1/denominator1 when field = y then numberator1/denominator2 .... end That way you may be able to use these values in other cards down the road if you need to vs creating data for just one card type.

If this data is broken up in two columns already you can use this: To count without duplicates: count(distinct()) You can do this from beastmode in a card or do if from mysql. If you are trying to ignore the bar and whatever number is after it, then you'll have to do some more work of course: *If you're already in the card…