Shevy Contributor

Another option is to create a date table that tags days as business days or not. That way you can exclude holidays that your company is closed or whatever criteria you need. The table can be linked to any other table by date and you get a lot of date information that will be consistent. We built our own, but DOMO has one…

Solved this - we ended up getting rid of the Publication groups as SUMO cards had an issue as well. Thanks for the offer!

That is the original solution and great for the average user - I have some EXECS, that are asking we show it without hover.... Can't always please everyone!

The "cancel" link not working? I have this occur at times but if I hit cancel and re run it usually works fine.

I have seen this issue a few times - sometimes it worked and sometimes it didn't. When it didn't I found deleting the original data set and creating a new Dataset that used the same name often fixed the problem and allowed for minimal maintenance. Also I sometime just did a second data set and then changed where cards…

I have solved this by creating a date table that I link most "actual" results to. DOMO will not display results for months that have no volume and this can be good or bad depending on what you are trying to do. By creating a join on a date column - and 'left join" based on date month - you can ensure all months are shown.…

Windy, ultimately you needall the columns you want to report on but yes - knowing how the two datasets relate to each other - Lead ID# or whatever else it may be. When you say "bring in" are you linking to SFDC and creating a linked data set or are you downloading from salesforce and uploading two separate data sets into…

Perfect I did go like it. Thanks for pointing it out.

I did get this once when I deleted a data set that was created from a Magic ETL upstream and then had created a similar, but different one with the same name. Ultimately I had to recreate the downstream Magic ETL and delete the one that could not load a data set. ultimately i think i corrupted it a bit by making the…

Thanks, trying not to give them access to data source but to an input "card" Maybe a good idea to add to new ideas.

You can! In a drill, below the export there is a pencil icon. That is labelled "Edit Drill".

Yes - my goal is to have the ability to allow a user to change an assumption and have that dynamically update. Could be a webform or any other solution.

The simple answer is yes you can - there is a Magic ETL widget "Uncollapse Columns" that will do what you are looking to do in Magic. I have not used it yet, so i cannot give you step by step instructions but i saw a demo at appeared fairly straight forward.

From your post I can't tell if you need to know it is 0? If you only want to be alerted if it goes >0 then the alert set to greater than 0 will do what you want. Alerts only fire the first time it goes over, not everyday it stays over. So you should get what you want without daily alerts of it stays above 0. Setting the…

depends on what you are tying to do. If you copy a card (not duplicate as card) to another page, a change to that card will update it both places. Once you duplicate a card and make changes, then it is its own card. The exception to this is BeastMode calculations. if you have the same Beastmode calculation in different…

yes you can definately do this. go to the user, add pages and just select the subpages you want them to see. Can also do this in publication groups. Works well.

There is not a way to do this today. i suggested it in the ideas a while back on just received an update to that idea that it is being worked on. While there was not promise of a delivery date, I am thinking we may hear more at DOMOPALOOZA... I am en route and looking forward to hearing whats new!

Add a ROUND(XXXX , 4) to the equation. CONCAT( ROUND((SUM(`Calculation Use 1`)/COUNT(`Phone`)),4)*100,'% Conversion Rate',' ',',', COUNT(`Phone`),' ','Total Leads')

OK so that did not post well.... First table Colums are dates and values Output table puts the dates as column headers and the values as a single row.

This works great and we have employed situations like this as well. One item to keep in mind, is if you use this, you cannot get these metrics to appear in your Daily DOMO digest. It will not pick up a concat statement. So weight the tradeoff of one card vs. the auto email update of KPI's. No right answer here - just a…

Without a doubt its DOMOPALOOZA!!!! Day 1 of DOMOPALOOZA has workshops and many of the course / classes from boot camp are offered there. The Brilliance Bar, conversations and other events will give you more than bootcamp ever could!! (No - I do not work for DOMO)

This may not be a perfect solution but does work. In ETL you can add columns and then filter by those columns. So, as an example, I just took a data set - linked it to the "Date Operations" under "Edit Columns" and made a calculation that looked at two dates using the "Days Until Date" selection in the drop down. My data…

The only advice I would add to the solution is to be sure you have your sort order in as it will return the first 100 (or designated number) of rows. If sorted by date, volume, size or whatever else, it will take the number of rows specified.