-
Grab value from one column and add it to another dataset?
This is probably a simple question but it eludes me since I don't use DOMO regularly. I have 3 datasets. A, B, and C Dataset 'A' has all the metrics for a specific ad set ID but no information for the campaign. No campaign ID or campaign name. Dataset 'B' has all the high level details for the ad sets which include the ad…
-
How do I remove the 'Total' row from a data import?
I am using a connector to pull data in from one of our web analytics platforms. The problem is that it pulls in a 'Total' row which I can not suppress at the source. Using an ETL how do I remove that row? I've tried to use the Filter Row tile but perhaps I am doing something wrong there because I have not been able to…
-
History for Connectors
I had an experience today where I was duplicating a Big Query connector and accidentally overwrote the production connector. Fortunately I had already copied the query out of that connector and pasted it in the new one before overwriting but if I hadn't I would have had to build that query from scratch. It would be great…
-
Is there a way to roll back to the previous settings of a connector?
I was working on a connector and using an existing connector as a template. I overwrote the Big Query SQL query and saved. At that point is when I realized I I actually overwrote the production connector. Now, fortunately I had the Biq Query SQL query already copied to the new connector and I could just copy it back and…
-
How do I take a portion of a column value and push it to a new column?
I have a column for campaign names that looks roughly like this A1234567| Campaign 1 | Google Ads | …… What I need to be able to do is read/grab all the non-space characters before the pipe and put that value in a new column called Campaign ID. In the case above, the new column for Campaign ID would contain A1234567. If…
-
Is there a way to rebuild a connector to allow for partitioning?
I use several connectors that do not currently have partitioning capabilities. Is there a way to rebuild them to allow this capability? For example, Facebook, LinkedIn, etc do not have the merge option.
-
Paritoning beta. Where to start?
I've got access to the partitioning beta and trying to figure out where to start. I have a number of legacy datasets (marketing platforms like Facebook, LinkedIn, Google Ads and Google Analytics) and dataflows that are clunky at best and go the long route to handle recursive data. I'm looking to simplify and make these…
-
How do I set up a connector for Lumar which uses GraphQL?
I'm trying to build a connector for Lumar(formerly Deepcrawl) but I am stuck. I've found my way to the custom connector in DOMO but from there I am lost. I have Lumar's API documentation( but I'm not a programmer by trade and no idea how to translate that into the custom connector. Any help would be greatly appreciated.
-
How best to handle variations of a single dashboard?
Here is the situation. We have a master dashboard that have several cards on it. To keep it simple lets say there are 5 cards. Now, we show these dashboards to clients but not all cards are relevant to every client. In fact there is almost some variation. Let's just say each client has a unique variation. The way we handle…
-
Can I take the Data Specialist certification with only a little experience outside of the training?
I've been through the Data Specialist training a couple of times now but haven't had a lot of time using our production Domo instance. Is it reasonable to believe I can take and pass the certification? I'm concerned that I might be in a 'What comes first? The chicken or the egg?' paradigm. I can't get the access levels I…
-
Is there a strategy to manage data that would allow 2 owners?
Is there a way to have two owners for a dataset? We had a previous user leave the company. Now we have to re-assign a new owner for all those datasets but the reality is that those datasets might not be solely managed by a single user. Is there a way to share the ownership?
-
What level of access do I need to take the Data Specialist certification?
I am looking to take the Data Specialist certification. I am curious what level of access I need to take this. My understanding is that part of the certification requires using Domo for a project or something along those lines.
