guitarhero23 Contributor

@Jeffsnake Your point about hundreds of fields is definitely something I've wanted in Domo, I'll search to see if an idea suggestion has been posted. I'd love to be able to define the fields that users have as options when filtering by card. For those large datasets it's definitely hard for them to navigate through, I'd…

@Jeffsnake In a perfect world and you could see all rows in the table what is the expectation of what the end user would do for a table card (asking so I understand how they might use it), want to make sure I'm understanding the pain point correctly. Not having editing capabilities limits what they can do in Domo so if all…

That seems a little dramatic, Domo it plenty useful for hundreds of other things, just because a limitation exists on the amount of rows shown on a table card doesn't make the whole platform worthless. I don't know whether it's a technical limitation they set because of how Domo handles that data being shown or they limit…

Just to clarify, are you saying the only number/date you're looking to make dynamic is the 7 in the divided by 7 section? Or you are also looking to make the '2019-01-01' and '2020-01-01' dynamic?

Here are some resources you might be able to reference. * https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Finding_the_Median_of_a_Value * https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Could-I-apply-some-statistical-functions-like-Std-Dev-Variance/td-p/10176

You can run Workbench from the command line SEE HERE. So a solution for you would probably be to create some sort of script (command line, powershell, etc) which gets some result from the SQL Query and IF it meets your criteria then it would run the command via command line interface. So on the Domo end you're just…

I assume the Workbench logs don't really show anything useful/don't show anything at all? If you haven't I'd say reach out to Domo support, I haven't come across this issue.

How large is the spreadsheet? Can you just copy and paste the rows from Excel straight into a new Domo Webform? I've done it for a limited amount of rows and it went "ok" but if you're making this post I'll assume it means you have an amount that makes that not feasible as the Chrome tab will hang and not really do…

I'm not sure what you've looked into already but for more details than I give here I'd recommend reaching out the the Domo team via support. They have created a custom app for Quickbooks Enterprise that I use which gets me a lot of things such as reports around expenses, EBITA, revenues, cash balances, etc. You can learn…

According to the FAQ's it seems their isn't one, at least on the Workbench side. https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/13Workbench_5_FAQs However if the table is huge you may want to think about the best way to get your data up their, perhaps in chunks rather than all at once but that's up…

I'm unclear on what exactly you're doing. Are you using the API to get a csv from Domo of a dataset you have? If so can you share your code of what you're doing? If you're doing something else can you explain the process you're going through?

You have to give permissions for Domo to access to an account that has access to the resources you're looking for so you need as many accounts setup as are able to access the pages you need. Ex. If one facebook account has permissions to manage 10 company pages that you want stats for you only need to create that one…

Personally I'd say it depends on how much detail you want to include with the datasets. In Domo you're a little limited in that you basically have the Description field to work with to describe the overall dataset and you can tag each column in a dataset with some value. If that's enough than you can work to build that…

I was waiting to see if someone would respond who knows the answer but I think the lack of response is because noone has asked that before that I've seen. I'd recommend reaching out to support to see if anything can be done. I don't believe it's a native option but maybe some creative workaround on your end for the website…

I don't have time at the moment to create a test dataset but let me see if I can get you further along. A full case statement is made up of (CASE WHEN X THEN Y ELSE Z END) you have multiple END statements, which would end a case statemement, but you only have one actual "CASE" function listed. You might have to try to…

Someone might be able to do this in beastmode without a dataflow so see if they come in with a good one, but you could do a dataflow that is just the MAX of date. Then since you have that value you don't have to inlcude it in the beastmode and just do something like CASE WHEN DATEDIFF(`Date`, `Dataflow_MaxDate`) > 28 THEN…

Have you tried checking off the setting under "Configure>Additional settings>Allow schema changes"?

Wow, yes that worked. Awesome!

I'm not sure if this is a step forward or backward but if you add "Content-Type": "application/json" to the headers and don't do json.dumps() you get this back instead "Unrecognized token 'sql': was expecting ('true', 'false' or ""'null')" For the hell of it I replaced 'sql' with 'true' and get the following 'Cannot…

I just tried this out myself in Python using the requests library as you did and I can confirm I'm getting the same thing. If I do json.dumps(data) I get "Content type 'application/octet-stream' not supported" If i don't do json dumps I get "Content type 'application/x-www-form-urlencoded;charset=UTF-8' " not supported I…

@zmyrenee Do you have in your headers that you want to receive octet-stream back instead of something json? I'm not very familiar with octet-stream but it appears that the api should return json by default so unless you have "Accept: Application/octet-stream" or something like that in the header I'd be surprised you'd get…

That's still one hell of a long beastmode. I don't know if long beastmodes have any performance issues but I can't help but think their has to be a better way to do this to save you the headache of having that many lines and I'm sure you'll run into the limit eventually (if you will add more lines over time). Might not…

Actually I might stand corrected....Take a look at this. https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet

One probably exists but it's way higher than anything you'd ever want to get close to. I tested with over 6800 characters and it saved fine, however it doesn't all fit when hovering to view on the page shown below, but if you open up the card it's all there.

If you don't get an answer here I'd ask straight from the source and reach out to Domo support. I can't imagine they actively save it since they would be paying for a TON of data that their customers don't even use but I'm sure it's possible the data exists for some time in the form of backups they/AWS does. I tried…

If you want this URL to be put into a data table or something so people can click it you can do it with the following beastmode CONCAT('<a href= https://{yourdomainhere}.atlassian.net/browse/',`issue_key`,' target = new> View in JIRA </a>') This will add a hyperlink to your ticket as it dynamically inserts the issue key…

Unforuntately I'm almost certain this isn't available but has been suggested in the idea section because I to would LOVE to be able to send parameters in terms of what to filter on and get back results based on that.

Ahhh ok, I mostly deal with the requests library with Python, thanks for the education.

Are you saying you want to be able to export out part of a dataset or are you talking about streaming or something to that nature.

I notice it references some cert where it says cert_required. Is this some cert you're using for authentication, one which is on your computer but would not be in Domo?