jaredpk Contributor

Hi Nick -- I see where you are going with this. One possible solution could be as follows: * Import only the last day's data based on system Mod Stamp * Compare the new data to the existing dataset in Domo. * Based on the lastest day's data and the dataset Unique identifier (opportunityID, AccountID etc.) recursively pull…

Thanks for clarifying. Basically what is happening is that Microsoft Excel encodes dates as the number of days from December 30, 1899 (not sure why they decided on that one). So Excel is converting that serial number into a date for visualizing it in Excel, but Workbench is reading it as a number. One way to get around it,…

Hi ... Can you clarify if the error is happening in Workbench prior to upload, or in Domo after the upload. Thanks Jared @Hulachic5 wrote:Aloha All: I have the error: Failed to parse data '43269' as type Datetime for column 'Entry Date'. When I pulled the data into Excel to look for the error, I could not find it. This…

Hi Nick -- Yes an custom app could do this. For that'd you'd clarify the requirement with our App team and they would build and test with you to make this work.

Hi -- I just talked this over internally. Nick, you are correct. This can't be done currently. To put this on the radar as an enhancement request, I would put this ideas exchange.

PS ... Hi Nick. Just saw it was you.

Hi -- the SFDC connector is pretty robust. So on datasets less than a few hundred thousand rows, replace should work well. On larger datasets, you would need to run the data through a recursive dataflow and then deduplicate the results to find the latest updates. Instructions for SQL and MagicETL recursive dataflows are…

Make sure you are using aggregate functions (Avg, Sum, Max) etc. around all numbers. Summary numbers need those to correctly render.

Thanks for the clarification. For the nulls, if you are using workbench there is a search and replace option before you upload the data. That's a possibility, but only if you are using WB to load the data. If not, you might have better luck doing the ifnull logic in a dataflow or MagicETL rather than a beast mode. You…

In Excel there is a function, "EOMONTH", that does the same thing. So you could modify your excel file with a new column that includes that value. I know you had mentioned magicETL in the beginning. Unfortunately there is not an equivalent function in magicETL, but if you did a magicETL / excel combination you would add…

Hi -- The best way to accomplish this is to use the last_day function in a mysql data. See below for how this would work based on the following data: Date Amount Jan 1 10 Jan 2 5 Jan 3 10 If you write the following statement it will group all the data to the last day of the month: select last_day(Date) as 'Month End Date'…

HI there -- regarding nulls, if I understand correctly you are asking for a string with the word 'null' to be automatically included. There are some disadvantages to that. When a value is null, that is literally the absence of information. So calculations can run on cells with data, and will simply ignore the null cells.…

Hi -- I you are correct. A simple stacked bar and a nested stacked bar can do this, but this card type cannot. A good place to request this is in the ideas exchange. https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas It will be reviewed and users can upvote this for priority. Thanks

Hi -- Currently accesses are maintained through user permissions. An admin can see everything, whereas someone who is a participant will have much fewer options on what is available. If you are finding that new users are seeing datasets you do not want them to see, ensure that they are not admins and assign them to a lower…

Hi -- one important thing to note is that sometimes the HTML will show up as tags until you actually save the card and it renders. If you have gotten your beastmode to validate that's great. So then save to see if it renders as expected. The other hint I would give you is to start simply, maybe just a section to color code…

Here is one that changes the beastmode fonts as an example: CONCAT( '<div style="background-color:#bbe491; color:#000000; font-weight:bold; width: 100%; height:100%; margin:-20px; padding:20px">', '+$', `WoW Revenue Change`, ' (+', `WoW Percent Change, '%)','</div>' )

Actually, you can use HTML in summary numbers. To do that you have to encapsulate the HTML tags in single quotes to make it beastmode/mysql friendly. It's not always for the faint of heart, but if you are comfortable with beastmodes and html you can do some nice things. I have used it to color-code numbers green or red,…

Yes, that's the current way to do it if you aren't the owner of the pages. However, what you are suggesting makes sense. I could even envision an option to toggle the filters on and off. Sort of a "current state" vs "snapshot state" concept. If you are interested, you could submit it as a request in the dojo ideas…

Hi there -- Temporary analyzer filters are not usually persistant on a card. However if you set analyzer filters on a page and then as the page owner lock the page, those filters will persist for all cards on the page. Is this along the lines of your question? If not, please let me know some more details.

Great to know ... thanks for your exploration as well.

You can link an image source using similar HTML tags, if you know the location of a source. You should also be able to but a link on the image. I haven't actually done that, so it's new territory, but theoretically should work.

I have not experienced that. If that is happening, please contact Domo support. We definitely support multiple accounts. One thought -- Do you have administrator privilages?

Hi -- we don't have that kind of chart type, but it would be a great suggestion for a new chart type. There is also an Adobe Illustrator plug-in that allows for custom graphics and chart additions. Documentation is available at: https://developer.domo.com/docs/design-studio/app-overview (Domo login required) If you would…

It looks like at least one problem is with the date field in your second week function, highlighted in red. Those should be back-ticks (`) and not single quotes. Please test that and let me know if it works. If there still is a problem I will often just test one simpler part of the formula to ensure that works and then go…

Hi -- Are you trying to compare the current week's performance, with the same week last year? If so, there is a "Week" function that will show you the week number of the year 0-52. The syntax for current year would be: case when year(`Date`) = year(curdate()) and Week(`Date`) = week(curdate()) then `Amount` else 0 End The…

Hi Vincent -- Have you considered using Domo Workbench? Within the Workbench interface, you can use stored procedures. The link below discusses how to use Workbench. https://knowledge.domo.com/?cid=wb4faq

There are some product enhancements on the roadmap that will allow for mass managment of cards for duplication, movement, deletions etc. Those are already being used and tested in a beta environment. In the meantime, we do have an internal tool for duplicating cards. It does not allow for mass updates to the filters, but…

Hello -- This is possible using the concat function in a dataflow or beastmode. The exact syntax will look like: Concat('<a target="_blank" href="https://MySite.com'','Link to Source','</a>') You will have to modify the code above to fit the specific URL you are trying to replicate.

You can have as many accounts of each type as you would like. We routinely have mutiple social media accounts connected in customer instances. When you go into the facebook connector, for example, and choose "Select an Account" you will see an list of existing accounts, and an option to add another account as well. The…

You can do it either in a beast mode or dataflow. However, I recommend doing it in a dataflow. As a beast mode, it will recognize the new field as a date, but it will not be in the data grain options in card builder.