-
Dan Kivlin - Lee Enterprises
Hello all. I am senior manager of financial analysis as part of Lee Enterprise's corporate FP&A team. I am based out of our corporate offices is Davenport, IA. I have been working with Domo for as long as we've been customers - something like 7…8 years. I am a system admin and probably the closest thing we have to a Major…
-
Beast Mode - CONCAT with a carriage return?
Looking to CONCAT several address fields into one, but with carriage returns between Name Address City State, Zip Any thoughts on how to accomplish this in a beast mode?
-
Round Down In Beast Mode
How do I round down to the nearest thousands. For example, 17,692 should be 17,000...not rounded up.
-
Export All Workbench Jobs?
Is there a way to export all of our workbench jobs to make a copy/backup as a failsafe in case our workbench server goes kaput? I see how to do one at a time. Maybe I'm just not seeing the option?
-
Multiple Users Update Same Dataset From Workbench
Is there a way for two people, both with Workbench be able to update the same dataset from their machine using their ID? Tried just using the same dataset name, but Domo just creates a replica of the data with the 2nd person as the user...
-
Using Magic ETL For One To Many
I have one dataset with many, many lines with a company number. I have another dataset with one line per company with plan values in it. I want to combine the two in Magic but don't want the Plan number to repeat over and over (flatten the plan?) in the combined dataset so that the summarized number per company number in…
-
A beast mode where sum is greater than X
Trying to create a Beast Mode where I count distinct customers who have spent more than $100. The issue is I need to sum the revenue amounts because customer spend amounts cross many rows, so looking at just one row won't do it. Something like: COUNT(DISTINCT (CASE when sum(`revenue` > 100) then `customernbr` -- else 0…
-
Fiscal Calendars - how do we check the setup?
We are a 544 company on a calendar that does not end in December. At one point Domo setup our calendars for use with the Use Fiscal Year checkbox. Can we check our own fiscal year setups somewhere? If not, how can we check the dates that are used and make sure future fiscal years are setup correctly? Regards, DK