guitarhero23 Contributor

I haven't seen that being an available option in Cloud or via Workbench. You can connect directly to a database or you'll have to put it in Excel or CSV. If this is kind of a one time upload or rarely updated dataset I'd say just to Excel or CSV.

Guess I should have drank my coffee before posting this. Don't know how I didn't realize that....

Scott, I think this will do it! Seems to be sorting correctly. Right now I have a lot of extra stuff going on because we're still iterating on this dataset and it's being pulled in from Excel still and not directly from the database yet which means I have to do ETL to correctly identify NULL fields, field types, etc so all…

I can look the specific syntax up my I only have access to MySQL DataFlows. Do you know if it has a comparable function? It doesn't like "Partition By". Does Redshift have to be enabled by support?

Having some trouble figuring which ETL(s) to use to get the max date of the field I have. The calculator can't find a max date, just numerical calculations, date Operations can give me month of date, day of year, etc, but not max date. 

OK thanks, I'll have to get back on how/if it worked(Monday). Leaving work shortly. 12 isn't always the last month, in the real one I have it as a rolling 12 months

You're kind for trying to help me test Scott. It didn't work as I had it so I've prepared some test data for you that I made up. It's the Heatmap card type with the following values: * Category 1 = Date * Category 2 = (Rejected % calculated field) * Series = Name * Sorting = Date Asc + Rejected % Desc (if I reverse them…

This is along the lines, you've given me some ideas. From the data itself in SQL Server we basically get a success number and a rejected number for each row of data because not all of the data fails for each run through the system. Basically if 100 things come in as one 0-100 could fail so i calculate that failure in Domo…

The inner join worked? What did you change?

Done, I didn't realize one existed and had also created an idea

Do you definitely need a rowID as opposed to just not showing one of the duplicates like I mentioned? I onyl say that because it seems to solve the problem but I don't know the answer to your most recent questions so you'll have to see if someone else knows.

The good news here is that your data looks like it's correct, it's just that the JOIN doesn't remove the column from showing up in this case. If you can do it via a MySQL dataflow you can choose to just not select that field and it won't show. If you want me to walk you through it I can.

Actually I'm doing a test with your data and getting the same thing, even with an inner join. Hopefully I can followup shortly.

Sniped. My response I was typing. A couple more questions I was preparing: * What exactly is your set column type ETL doing? Is the data not coming as a number? * Is there a reason you have an input dataset in their that doesn't connect to anything? It might be due to the JOIN type you are doing. The full thing being…

Can you post a screenshot of the ETL you currently have setup? Are each of the values in column1 unique? Sounds like it, just checking

Help! 

This isn't an answer to your question and you might already know or it's not possible in your situation but a solution would be to have a remote connection to some other VM or desktop and have it installed there. When you need to send data you would both use that same workbench application, though you would be limited to…

Can you be a little more specific? I'm not sure I understand what you mean.

After a long time it seems more stable...not too confident in it as I didn't change anything, however it's working.

Also make sure to try to find and use the direct link to the document, SharePoint Online likes to throw a bunch of stuff at the end/in of the URL for all sorts of stuff. As basic as you can to the file path

Are you using this connector (which is hidden from normal view) https://XXXXX.domo.com/connectors/com.domo.connector.microsoft.sharepoint.online? I've only done a little testing but I was able to get a document with the relative URL. So for example if your company URL is company.sharepoint.com that would be setup in the…

Which connector are you you using?

I'm sure this isn't useful to you but adding it to this chain for potential future research by others. Example Python Script to launch Chrome, navigate to the publication, and pass in access code. from selenium import webdriver import time #Link to the file path for where you have chomedriver.exe driver =…

Agree, trouble is depending on the size of the company and how "techy" they aren't that isn't always an option. I'd like it to be on a Rasberry Pi myself as that would be super simple, but to convince the company that we should get Rasberry Pi's for monitors wouldn't fly past the operations team and sysadmin who wouldn't…

I'd be interested in knowing this as well but as an alternative the easiest way is to have a VM or easy access to the environment powering the TV/Monitor so you can control it remotely.

Look into PDP. I don't use it myself but it's possible that even though they select it in the quick filter, because they don't have access to that data based on the PDP rules they probably wouldn't see anything. Also (again I haven't tried so this is just an idea) the quickfilters might not show the values you don't want…

Interesting, I don't remember ever seeing that, or it was too long ago to remember but definitely don't now. Are you new to Domo and the Getting Started helper is telling you to until you complete it? Can you send a screenshot?

I get errors when saving certain card(s) which gives my a similar error saying it can't be saved and to contact customer support if it persists. I created mine on 8/16 but haven't heard anything

Most likely in Excel you could do that, though I don't know how. In Domo you could use the isnull function in a beastmode. IFNULL Used in logical statements in which you want to specify a replacement for null values. IFNULL('Values',0)

I think a different way might be the more proper way but this seemed to work. I recreated your dataset and added an extra one that had data in those last 4 cells This formula assumes you DO WANT TO SHOW the row when any of the 4 values exist. Create the below Beastmode then use that beastmode as a filter where the criteria…