Billobi Contributor

Hi Anthony, did you ever get this one figured out? (no screenshot was attached) There are a solid handful of settings that need to be handled properly. Did your Redshift DBA review all of the steps in the power up guide? Was SSH identified if needed? Best advice is to double check each component of the setup and try to…

Absolutely, Domo calls will count against your API limits, whether you're doing report-based connections or SOQL queries. I'd recommend using a new service account within SF that you only use to authenticate in Domo to so that you can monitor the impact. Watch out for row abuse, use LAST X DAY type SOQL queries if the…

Say you go into the Salesforce Advanced connector and pick Browse Objects and Fields...if you put in "note" in the object dropdown as the wildcard, does the 'Note' object and others appear for you to try and connect to? Depending on the SF deployment there could be custom named note objects in use that you'd want to talk…

I think you're out of luck still on this one. Switching connector types requires a different type of credential / integration account and changing that in a dataset isn't really an accessible method. You could see if Support has any backend tricks to help accommodate...if you find out please let us know. In the meantime if…

So if "Invoices marked 'No Code' in Appt Text, '0' in Bay Code, and 'No Bay' in Bay Text indicate that that invoice did not have an appointment", does that mean that all other invoices have an appointment? If so I'd just do an evaluation against those specific contents to give you a unique count of the 'Invoice #' field.…

Watch out for your second portion of the evaluation...easy typo but you're looking at YEAR() vs MONTH() so it's not going to yield any results. Same day last year: case when year(`INVOICE_DATE`)=YEAR(CURDATE()) -1 and YEAR(INVOICE_DATE) = MONTH(CURDATE()) then INVOICE_TOTAL_AMOUNT ^^^ instead of year(invoice_date) I think…

I've seen this issue before but never pursued it...@apritchett you're not going crazy. The governance/datasets report pulls down 1 row per unique dataset for sure and the row count for that dataset...you'd expect them to match up with the summary values in the top right of the warehouse (or pretty close to some degree) but…

@G_Grey glad this did the trick for you! I'm hopeful that Variables could help with something like this once we're all more familiar with how they work with controls and such. Quick ETL snapshot below for anyone who comes along this thread in the future (I didn't mean to actually duplicate the dataset, just meant double it…

It's a pretty interesting scenario. Quick disclaimer that I haven't gotten deep into Variables yet so this would be my old school workaround. If you can afford to be a little wasteful and not bumping up against rows within your instance, I'd duplicate the dataset and append itself to itself, but with one set having column…

What's the fashion that your data is coming in? Would you be OK with doing some sort of recursive/append that stands up the new column as zero on the new data rows side, but preserves the 1 setting on legacy rows that have been touched by the python script? Tough to tell without knowing more, but I'd anticipate some degree…

Shopify really just gives you the products & variants datasets last time I was in there...if your bundle relationships don't jump out at you from that you'll be pretty limited with what comes from Shopify. Unfortunately with all the bundling apps out there the storefront API doesn't have a uniform way of reporting on them.…

Hi Shiel, I've found that most of the social media connectors keep account/channel data (followers, subscribers, friends, whatever) separate from engagement data (likes, comments, saves, shares, etc.) and the naming structure is pretty different on each too. I'd use ETL to normalize the inputs from various social media…

Hopefully this one took care of itself by now, but for anyone from the future who wants this, here's what to do on the LinkedIn Ads connector: Report: Ad Analytics Reporting Facet: Ad Campaigns Campaign Selection Criteria: All Campaigns Fields: depending on what you're looking for, could up to 20 choices such as: clicks,…

Absolutely it's possible. You can do it via the connector you referenced or Workbench if you need to. Have you had any luck since your original post?

I'd love to see a "select all" option in the remove duplicates tile, sort of like the same button on Select Columns where it loads up all the fields but then you can go back still and remove the ones you don't need or care about. I see plenty of cases where there's a junky input (wonky APIs, spreadsheets uploaded directly…

Hi ancasselman, have you had much luck on this one yet? The page-level date filter is pretty handy. It adapts to set the date range on every card based on each own card's date dimension. Say you had 2 cards, one for "product sold" with "PO date" as its date field, then another (or same) dataset for "product delivered" with…

Hi Damen, I think that using Views Explorer on your dataset would make this a very easy lift. Once you're in there, click on the 3 vertical dots at the top of the purchase date column and select "Remap nulls"...put in a value like "rows to inspect" or whatever. Then you can filter just on those column and export to CSV.…

No you don't need to have the same username for the Bing connector and your Domo user. The Bing user needs to be configured as a super admin for it to allow the connector to work. As long as your Domo user has permission to create new datasets, you shouldn't need to change any config settings on your Domo user. Using…

Hi Skhatri, that certainly is a limited ad platform dataset. You can join header data to the daily ad rows even though they're only associated by row placement, but it's heavy on the assumption that these sort of daily rows repeat in this same fashion throughout the input. Here is my start dataset and output dataset: Here…

You could always do it in a few Magic tiles if you prefer to stay out of MySQL. The calendar dimensions dataset comes in handy all the time. Narrow down the two populations that you're interested in with their own filter path, group by a constant (like _BATCH_ID_) to count dt, then join them back up on your constant. Let's…

Hi there, I have felt the heartburn associated with the Bing Ads connector as well. The authentication method leaves a lot to be desired for, especially if you're not a regular within the Office/Azure workspace. The KB article on the connector calls out the big 3 - making sure you have the dev token, the client ID &…

Did Mark's method get you taken care of? Changing the type should do it (either with Formula tile, or Alter Columns tile and change the datatype) but here's another method you could use... Before: Replace Text: Results after:

That's a good workaround Jae, but I think it's a cumbersome one that Domo shouldn't require of its users. If a story is too tall to export, I'd rather see it shrink itself down to print, or figure out a way to print a taller PDF. Either way, figuring it out without user intervention. Will hunt around on Ideas Exchange to…

Hi @Boone408, Old topic, still relevant, figured I'd share something that I found. Depending on the Ads instance, the scripting for the CAMPAIGN_PERFORMANCE_REPORT to get exported to Google sheets works fine, UNLESS it's a Google Express account https://developers.google.com/google-ads/scripts/docs/limits#adwords_express…

Nice! That's the way to do it! ? Grouping is a wonderful piece of ETL. Any time you've got aggregations that you want to filter on in a card, just take it upstream and group it in magic.

There's always the option of changing your cards from "This Month" to "Last Month" in the date filters, but a "Last Month" card may not be that valuable by the end of the next month. Easy/quick button would be to duplicate the card and set one to This Month and one to Last Month. The user could then make the judgement of…

Hi Sankar, I've done this before by putting the card that you excluded from page filtering on its own dataset. It can be a mirror of the dataset that the rest of the page is using, but with slightly renamed fields for those that would be commonly used on the page filter. The page filter will be applied to any cards from…

I agree completely, keeping an eye on SF API call count is a very expensive topic, either from the standpoint of a single purpose user being created for the Domo connectors or from the standpoint of upping a SF subscription to allow more API calls per hour. In most cases I've seen, the Domo admin is a SF user, so they just…

I believe what you're looking for is the ability to Obfuscate Values so that the users just see a masked field of gibberish, unless they have the explicit password to unlock it. There are a couple pages that review the process, which is slightly different depending on the version of Workbench you're running. Encrypting,…

From looking our QB ledger, I can see where you're coming from on this. Instead of using your logic to keep an eye out for the MAX() of TN#, I'd switch it to looking at the most recent Last Modified datetime stamp. You could also use the Rank & Window ETL to get it to rank the last #x transactions and that would allow you…