guitarhero23 Contributor

My original message dissapeared so re-adding, sorry if you get notified twice. This probably isn't the answer you want but I think it's only possible via the API. I have a script that gets the response from one of the API endpoints which returns the text seen below. You could do the following to generate the schema for all…

Based on the lack of responses and the fact that I couldn't find anything in the developer docs I'm going to assume no, but you're welcome to add it to the product suggestion in the idea section of Dojo.

Probably not the answer you're looking for but I think you can only do something like that by utilizing the API. Ex. I have a short python script that I have to get a specific datasets details which includes information about the dataset and the schema. So via the API you could get a list of all dataset ID's in your system…

Yes sorry by ETL dataset I mean the new dataset that you chose to create at the end of the ETL process (Input block-->ETL transforms-->Output block) where the output block is where you created a new dataset. This is what I'm referring to as the ETL dataset. In the ETL settings just choose the option which will…

The common case is that you wouldn't combine them. In this case since your ETL dataset contains all of the same information + two additional columns you would just use this dataset for all of the cards, the other dataset would exist but only for the purpose of getting the untouched data into Domo, then the ETL would…

It won't let me edit my post but I realized I misread your question. You DON'T want it to be decimal. Disregard my last message.

My understanding is that DOUBLE should be able to store it as decimal https://dojo.domo.com/t5/Workbench/What-the-difference-between-double-and-long-data-types/td-p/15852. 

I haven't experimented to see if a connector exists that does that but it sounds like something that's better suited for scripting out in a programming language and sending the results to Domo via the Domo SDK. Example: in Python use Selenium or Beautiful Soup to scrape the contents of a site and then format it as a CSV to…

Try the following: * Input dataset is the dataset this is stored in * Add the "Split Column" ETL block and draw a line from the input dataset to it * #1: Choose the column that has the values you mentioned that you desire to split * #2: Choose the delimiter that's being split, for you choose custom and put that slash *…

Do you have the ability to click "+", "Data", then "ETL" in the upper right? If so it would mean you're an editor or higher.

You might be able to utilize the ETL tools for this. Refer to this post regarding using REGEX to create a new column based on that existing column. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Magic-ETL-Value-Mapper-Wildcard/td-p/12059

Unfortuantely it does not, if contains X most recent records that get replaced as more come in so I have a lot of stuff that doesn't exist anymore

Oh I see. The closest it seems you could get would be to use the design dashboard feature as you described and organized it like that. More extreme is using the Adobe Illustrator Design Studio to format it very specific to what you want and having that on a page. Something you could do that we use is to design two…

Like @ST_-Superman-_ said you can use the slideshows, or publications to achieve this. Slideshow would show the cards on a page, if you publish a publication you choose cards from any page and group them into a publication and can have it be public or private (access code) to view. We have some support stats on a computer…

I don't believe it's possible to remove the legend for the funnel chart. It does seem like something that should exist if it exists in pie charts since they are sort of similar, maybe a suggestion for the idea exchange? I personally haven't had a use case yet where I don't want to show the legend since the chart doesn't…

How many columns, rows and how long is it taking? Also does the source data not have some sort of ID column to let you join via a MySQL dataflow or is it that the two datasets just don't share a common ID field to join on?

Is something stopping you from just displaying the SUM of Cost by Code on a chart since normally in Domo if you were to put Code and then SUM of Cost on one card it would already do what you're asking without a beastmode.

Using the ETL tool and using the Uncollapse Columns block may be of use. (See attached)

I also use the SharePoint connector and have a dataset that runs every hour that I have yet to have an issue with and it's been going for the last month without need a re-authentication so perhaps it's like @AS said and is an O365 (assuming you're talking about SharePoint Online) admin security setting that can be adjusted

Can you supply some information about the type of data connector being used and possibly some screenshots of the settings?

What exactly do you mean by being converted to SharePoint Libraries? The files you're talking about are already in a SharePoint "Document Library" if they're in some folder which would connect as you have already done it seems. You can also connect to SharePoint lists. Can you give any screenshots so I can see what you…

Did @dthierjung's response answer the question? I agree that's the route you should go, mark his as solution if it solved your issue

I asked my account manager the same and got this response "Hey Travis, I just spoke with some members of our technical solutions team here and they indicated that this wasn’t released this time around. They expect it to come with some of the other features later this Summer or early Fall."

Dani, If you have any specific videos you'd like customers to demo I'd say let us know if you're looking for anything inparticular. I'm well versed in making these sorts of things as I'm sure others here are as well and would be happy to make a video or two going through something.

Ah the classic solve one thing just to find out something else is also wrong. I did change in mine to remove self only because to test it for you I didn't need that. Did you try it with and without it in you're real code? Also what exactly is the end product of what you're producing? I'm interested. My guess seeing as how…

You would want to get the base64 encoded version of your client secret and client ID combined. You could do this in code but I found it easiest to go to that Domo developer site I mentioned in the comment and generate it there. If you scroll down on that page it has a spot you can fill in your Client ID and Secret and on…

My message seems to have disappeared.... At risk of this showing up twice I'm posting it again. ----------------------- I took your code and tested it out using the Base64 Authorization as documented in the developer documentation instead of how you did it and it worked. (Note, I ran this locally, not in AWS but that…

I took your code and tested it out using the Base64 Authorization as documented in the developer documentation instead of how you did it and it worked. (Note, I ran this locally, not in AWS but that shouldn't make a difference since you're just returning the HTTP response) import requests def get_dataset(id): # Get Access…

Can you provide the Lambda code? Is this a response from the Domo API that you're getting with a call from a Lambda function?

I'm not very familiar with Epic to know if a simpler integration exists but it seems you could use Epic Clarity to get the data in a SQL Server database and then use Domo Workbench from there to get it to Domo. That way you don't have to try to develop some sort of Custom connector to Epic. Epic Clarity Because of the data…