NewsomSolutions Domo Employee

If you have your Netsuite dataset, set to APPEND, and you have C in a previous run and then in the next run someone deletes C, the next run will show C as blank like you describe. If you have the connector set to Replace, then you wouldn't see C at all because the schema will change to the new format. What I've always…

I'll try to look at this one a bit more closely later today, but as I quickly look at it...you have 3 CASE statements with only 1 End. they have to be 1:1. Also, again I dont know your data, but it may be helpful to take a step back in the process if you can and do something in ETL to help join the data so your…

私はあなたが今言及しているのを見ます。 混乱させて申し訳ありません。 15のジョブを特定の時間帯に1回実行し、それが同じ時間にリセットされるかどうかを確認することができます。その後、ウィンドウを削除します。 しかし、完全なデータなしでレポートを表示することに問題がある場合は、Domo側でETLを作成し（ワークベンチではなくDomo）、実行後ではなくスケジュールに従ってETLを実行することができます。 何かが更新されました。 それが役立つことを願っています。

I think there are limits on how much data you can bring down from salesforce in one shot. you may have to limit it by month and then append to build your year.

この翻訳が間違っている場合はご容赦ください。英語からのGoogle翻訳を使用しています。 しかし、あなたは設定に入ることができます - そして同時ジョブを制限するための場所があるので、あなたがそれをチェックしないならあなたはそれらを同時に実行できるべきであると思います。 Workbench 4では、1つのスケジュールから複数のジョブをスケジュールできると思いますが、Workbench 5では、スケジュールはジョブと一緒に存続します。 私はとにかくワークベンチ4でそれをしたので私はそれについて間違っているかもしれません。 これが役に立つことを願っています。 マット

A participant by default can export card data out to excel/etc. But by default, they wouldn't rights on the dataset itself. If they HAVE to export data....What you should do is create a custom role. Go into Admin - Roles - in the top Right...click New - then select Particpant and then add in the Data rights for Edit…

Few questions: 1. You're wanting unique counts of those contact IDs? 2. Why does it look like you have 3 case statements in this, why not do everything in one? I'd write this up something like this, but because of your business rules or whatever, this may not work...but may help spur a better idea. (COUNT(DISTINCT( CASE…

In a table format, I've created a WoW usecase similar to your example below. With lets say stores are the rows...and the Weeks are the columns. So youd have 'Atlanta - '3 Weeks Prior', '2 Weeks Prior', '1 Week Prior', 'Current Week'....it tooks some ETL work, but all you'd need to do is use a grouping function and some…

@AttuAk You can't create a duplicate dataset...you can create a duplicate ETL and thus a duplicate dataset from that. But the beast modes wouldn't go to the copied version. You can use 'save as' for a card on a dataset that has BM associated with it and they'd go to the newly created copied card. If you're trying to 'back…

You have to go into the default group itself and in the member at the top...x that user out.

Is there publication groups involved in the card/page? Maybe the new owner of the card doesn't have access to the dataset - if Publication Groups are involved.

I know this is sort of an older case but want to put in that I ran into this error today (using wb 4) and ended up just re-creating the job and it cleared up. I think I had saved/edited so much something just got screwy on the back end.

Sure thing... Report = Decennial Census Geo Break Down = All US (you can use whatever I guess) Year = pick what you want Hope that helps.

There is a rural/urban housing one available for the US Census Bureau. You have to apply on the US Census site (thru domo is a link) to get the API key. The data shows rows by county b/c zip codes are a US postal service designation, not a legal jurisdiction. I've run into the same problem. You can then pull down something…

No

As for the DF, yea, SQL is so much simpler and as a former DBA it was my go-to, but too many drags on mysql forced me to make the change. It sucks sometimes setting up and it will take some time to get used to it and how to think about it, but performance wise for me it was a much better move. As for the comparisons, if…

Great. 1. First off, MySQL is slower in performance than Magic ETL. To me so is RedShift, but officially I'm not sure that is the case. 2. Nice 3. Makes sense. If you are using a card that does time period comparisons, does that not work for you vs writing out your own dataflow/BM comparisons?

I'm going to follow this b/c I am bringing in data and some may come in at the billion row level. But a few questions: 1. When you have slow dataflows, are they using Magic ETL, MySQL, or RedShift? 2. Have you tried thinning out your datasets and possibly structuring your data differently for the cards? What I mean is that…

Did you look at the business in a box options? May not apply to your specific industry use case, but there are some handy sample examples in there for different departments/needs.

99.9% confident it is server. What may take long is other details in your visualization (page filters, dataset refreshing then rebuilding visual, etc).

Answers: 1. no stored system variable - must find it myself using a date/id field and go from there....build recursive to just filter out the dupes. 2. Maybe - but you have to build code to export source data to a flat file to then import in your stream which sucks. Alternative: There is an option for data assembler for…

I don't think you'd be able to do that in beastmode unless I'm not understanding something. You'd have to do it in ETL. Say MySQL, If the surveys come over with some ID you could do something like this...check my syntax and logic...but theory should be good. My thought here is you may have multiple surveys with the same…

What is your input data source? And is Domo assuming your initial data type is Numeric but they're wrong? Domo determines datatype sometimes b/c of the first set of rows....if the alpha numberic is outside that sample set then it may be incorrectly assuming the wrong datatype. I'm guessing your Set Col Type is tyring to…

Let me recap to make sure I'm understanding your problem correctly. You have an Input - then a Set Column Type then whatever.... But you have an error at Input (which is the first action in your ETL) or the error is on the fact the SCT can't convert some peice of data? Most likely your problem is that you have a…

Then on whatever action that shows then something may be squirrely with the data. If you can see if you can just copy the action...replace the failed action with the copy and remove the original.

If Magic ETL and they all say 'failed' go scroll over them slowly and make sure you go one by one...sometimes I think they all say 'failed' but there is one that says something else. And from that you'd be able to figure out where to go. Hope that helps. Matt

Nice work, thanks.

Gotta love the power of a reboot! Glad it worked out.

Just out of curiousity, do you have more than one instance you have connected to in Domo? It could be that your jobs are stored under a different server instance and you're looking at another one?

You're welcome. Do me a favor and like the post and accept as solution so it closes this down. Thank you