AS Coach

You're welcome! There are many ways to acquire data in Domo. What sort of file are you working with and where is it stored? Can you have individuals share files on a network drive that Domo Workbench can access on a schedule? That would remove the necessity for manual uploads as well as finding backup users. What about…

Currently we're only able to have dataset and dataflow ownership by a single individual, plus administrators can access everything. What issue are you confronted with? Data is out of date when someone is unexpectedly gone?

Those are labeled as "hints" and I don' think you can change those. You can, however, turn them off. You can also change the data label settings (not hover label settings) to always show the text macro %_PERCENT_OF_CATEGORY so the percent of 100 always displays. That's not what you've specifically requested but gets you…

Great ideas here. You might also inquire with Domo about "stacker" if you haven't already. It can provide the flexibility you're looking for.

+1 to Scott's idea. We use a version of this all the time.

No; the only card I know of where you can change the formatting of the titles is the table card where you can configure the column header.

Your idea behind the first two transforms is good. For every primary item id approval, find the start date and find the end date in different transforms. Then you need to join the two tables together on the primary item id and calculate the date difference. It looks like it's that second part that still needs attention. It…

Variability makes it more complex for sure. Will there always be a fraction? That could matter in your approach as well. I tinkered a little bit. There has to be a better way but see if some of this helps (also see attached): select '8''-4 3/16"' as length , case when '8''-4 3/16"' like '%''%' -- if there are feet…

What kinds of problems are you having with SUBSTRING()? I've used that plenty of times in dataflows, so I'm surprised to see you're having an issue. What kind of variety do you see in your string data? Do each of these parameters (feet, inches, fraction numerator and denominator) exist every time (like 8'-0 0/16" vs 8' for…

We had some issues with dataflows running last week, but no workbench issues that I'm aware of. We have a mixture of CSVs, Excel files, and ODBC connections and all have run properly. Is this still a problem? Call Domo support.

Hi Chad Generally speaking, beast modes with aggregations within case statements are pretty tricky. Why are you summing PayTotal but not aggregating PayTargetWeek? What your beast mode is doing is adding up a bunch of rows to get the sum of PayTotal, but then comparing the aggregation against a single row's PayTargetWeek…

Right. In all of these cases we have to remember that beast mode is looking at one row of data at a time, and iterating through the rows in a loop as it aggregates. That's not the same thing as counting all rows at once but only if certain conditions exist. That's how the brain thinks of the situation typically, but not…

@ST_-Superman-_ gives very solid advice. I offer one more suggestion to possibly speed things up for you. I have a similar transform process in one of my dataflows where I combine a list of all days with a list of all customers to get an array of all possible customer-day combinations. Instead of doing date math using your…

If you delete users without changing owners of pages, cards, or dataflows, those objects will just be without an owner. They won't be deleted. Luckily, Domo has given you all the object reassignment options you want. You can reassign owners of dataflows en masse through the datacenter if your company has the newest version…

I'd simplify your beast mode by bringing your assembly values together into one comparison. CASE WHEN CONCAT(`PrimaryAssembly`,`SecondaryAssemblies`) like '%Allergy Immunology & Inflammation%' THEN 1 WHEN CONCAT(`PrimaryAssembly`,`SecondaryAssemblies`) like '%Behavioral Science and Health Services Research%' THEN 2 ... END…

What are you seeing as the output and what are you expecting to see? Do you want to count Critical Care or the other values twice if it shows up in both the primaryAssembly and the secondaryAssembly? Does your secondaryAssembly always include the text of your primaryAssembly? If so you could simplify your beast mode by…

The output of your case statement there is going to be the number 1, 2, or 3. Is that what you want? To display one of those numbers? You asked to count each occurrence, but I'm not seeing a count function here. Is that aggregation in the card configuration?

Hi! We do this all the time in our datasets. We have a dataset for targets (aka goals/quotas/forecast/budget/etc). Usually broken down by time (month/year) and person or product. Like 100000 01-May-2017 Jackson, Theresa Then we have regular sales data. Our sales data is at the transaction level. In order to bring the sales…

@ST_-Superman-_ Can you wrap each of your product columns in a single MAX() function (ie MAX( CASE WHEN `Product.... END) ? That's what I've done in SQL in this kind of circumstance before and it's worked.

https://knowledge.domo.com/Prepare/Magic_Transforms If you're familiar with SQL, https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows is probably where you want to go. If not, try https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/01Creating_an_ETL_DataFlow

Depending on the other data you have in there, you should be able to get unique values by aggregating the total spent column. If for every customer that value is always the same, then you can use an avg, min, or max function to do that.

I'm not sure what you mean by PDP alert. All cards have the alert option not in the Card Options menu, but in the set of options to the left of that. See attached. When a dataset has PDP on it, the alert will automatically adjust for a particular user's PDP filters. In the absence of PDP, the alert will review unfiltered…

Hi! Can you provide a little bit more detail? Do you have PDP policies in place on your dataset but cards built on that dataset don't have the option to create alerts? Cards built on PDP-enabled datasets should have full alert functionality. Or is something else wrong?

Hi @TargetDataGuy Are these two datasources in Domo already? If not, can you get them there using any of Domo's connectivity options, like Workbench, email connector, Google Sheet connector, etc? Once they're in Domo and on a refresh schedule, it's a minor thing (using dataflow) to join them together to create a final…

Card annotations is something currently in development over at Domo, in beta stage. So that means it's pretty far along. It includes just manually marking a date on the card and putting some notes in. The note snaps to the card date grain (ex on the month for monthly aggregated data) as a bubble comment and it follows that…

Does your beast mode validate but not return what you expect? Or does it return nothing at all? Conceptually it looks ok. Might help if you provided a sample `adname` value.

No, you can't manage your data to that level. Not where it sets in permanent storage ("Vault"). You'd only want to do that if cards weren't rendering fast enough. If dataflows are too slow, you can, however, write a procedure in each dataflow to create all indexes in one transform, then call the procedure in the next…

If you're using mySQL dataflows you can add indexes on transform tables. It is definitely recommended for mySQL dataflows. This article in the knowledge base talks about it.

The newest card count model seems to display at the bottom of the card the total count of all views from any source, including page view. That's different than clicking on a card and viewing it in isolation. I think DomoMetrics counts reflect the latter. That's my non-authoritative, educated guess.

There isn't a process currently place through the interface that lets you do this. I think there's a post on the Ideas Exchange for it, though. Ideally, I think, there would be a list of PDPs stored independent of datasets, and you could apply a group of policies to datasets at the click of a button. That said, we're using…