rado98 Contributor

Am I right ot assume that, as 100+ cloumns would be ineligible at a glance, the data would be extracted to use on a spredsheet or something? There are better ways to extract Domo data if that is the case. Alternatively, if you wont have more than a few rows you could collapse the whole data set and have columns headers on…

Hi You could use a Beastmode but it would not work unless you group by Order on the card (like the second box on you xls example. Case when sum($) > 50000 then 'Yes' else 'No' end

HI The easiest way I can think of (and unfortunately ti requires a dataset mod, a 1 tile mod in Magic ETL) is to collapse the data set so that you get a table like the one below 2010Jan22010Mar32010Jul82010Dec22011Jan32011Mar82011Jul22011Dec32018Jan82018Mar22018Jul32018Dec8 After that use "Month" as x-axis, "active users"…

HI I dont think the Beastmode above would work as any dates classed as Yesterday will not longer be classed as WTD, and so on. I think a Beastmode would work but on a transposed version of the card only. You can use Beastmodes in Sumo, you cannot create them in Sumo though so you need to create in a regular card and share…

If collapsing will not work you cna trying the following (continuing form ST's data set restructure) In Magic ETL (sorry I am dont really do SQL) create a new set of rows with the total of each Category/Subtegory and append it to the original data set. After that in your table card create a beast mode that will collect of…

I will depend on how the new columns were generated, if they come out fo beast modes collapsing unfortunately will not work 

Hi You can hide any columns in hte General chart properties. As for custom subtotals, I dont think so. If you need custom subtotal, what you can do is: Create duplicates, triplicates and or quadruplicates of all the rows but rename the amount and budget columns as Amount Duplicate, etc. That way suign beasmodes you can…

You can do a seudo Datediff in Magic ETL First Convert the date columns into decimal. Then subtract. Then convert to Days (multiply by 1 440 000). When Dates are converted to decimal 1 equals 1 miliseconds (and for reference 0 is 1 Jan 1970)

They are completely different things. Workbench is the tool that automatically uploads on premise data to Domo. The DataCentre is the collection of all your data in Domo.

In magic ETL the function isin the Rank & Window file. Check out the knowledge base about it.

If SQL is not your thing (like me) you can get the same new column using the lead function in magic ETL

Not a perfect solution but this should work On the drill card create a beast mode "Month" (in your prefered format) and use that as your X axis. Unfortunately with that you wont be able to change the date grain in the drill card

Is the other file type, escentially a csv with a different extension? I get an .asf file from a website, but as it is equivalent to a csv adn simply change the extension using a script and then upload using workbench.

I am assuming it is not a data type thing as that becomes obvious during an append. The only thing I can think off is the the titles are not exactly the same. Maybe on the CSV column there are spaces and while generating the ETL you name the column properly without space (or the other way around) I only even get the issue…

Hi Are you still after an answer on this? I managed to get the waterfall graph to work as intended (and the way I understand you would need it to work). See the attached image as a sample (sorry but had to crop out the detail). The first column is the budget profit, the middle the categories variances to budget and the…

The Workbench DataSet Job Group Wizard (Tools->Schedule) will generate a batch file as part of the schedualling process. The batch file rusn the selected jobs in sequence which is what you need. So create a schedule wiht the jobs you need. Go to Task scheduler, disable the task and check where the batch file is located.…

It also depends on how you want to present the informantion. If it was me I would do the following on Magic ETL: Basically generate a table with the following fields (one row per date) "Date", "Daily Distinct Users", "Monthly Distinc Users" Create a beast mode as either Daily/Monthly (or AVG Daily/ AVG Monthly for Summary…

You could create a beastmode along the lines of: IFNULL('Initials Column',1) The alert if Bestmode is 1. There will be a bit more to it but that will at least recoginize the NULL part.

The problem with "when Denominator = 0" is that is does not work if the Denominator is null. Then you would need to add IFNULL and so on. There are circunstances when 0% is not what you want (I would need NULL instead sometimes) if the Denominator is 0 or Null, so +0.0001 is useless. At that point I start trowing IFNULLs…

If what you are after is to have the two graphs "side by side" what you minght be able to do is the following: Split the dataset and then reappend it so that you end up with somethign like this:…

Two ways come to mind 1 Create a in excel a dataset that has two columns "Date" and the matching "First day of the month date". Join that to your current dataset. Not elegant but it will work. I have a fiscal calendar dataset that has this plus last day of month, quarter, year, half etc. 2 In magic ETL Convert the date to…

Probably a a column or something was added to the dataset or something else was changed. Run a preview and then check the schema to see what might have changed. You can also tick "Allow Dinamic schema changes in the job settings, although I would no recommend it.

What I do sometimes is adding 0.000000000001 to the denominator. That way you always get at a least 0% as a result every time. Not he cleanest solution and obviously the result will always have a ninor error but gives the output I want most of the times.

The only way in found to do in ETL is to add or subtract hours, not ideal unfortunately. * Convert Date/Time to decimal * Add or subtract the hours you need (1 = 1 milisecond) * Convert back to Date and Time 

Fixed it. The source data was actually "20180704130000" so I had to remove the " first.

See attached the soruce CSV file

HI You need to create two beastmodes One would be Sum of Actual hours when greater than Sum of Proposed The other one would be Sum of Actual hours when less than Sum of Proposed You then put the two beastmodes and Proposed hours as your fields. Select Grouped and Stacked as Chart Type Choose your colours There are a buch…

HI Ussually when you go into a drill down on the top lelft corner there is a filter box (which should say 2018). If you then click on the cross next to it to remove the filter it should go back to showing the full original date range.

Ideally you shouldn't even have to go through that exersice. As long to you have your fiscal calendar enabled on your instance it should be done automatically.

For the non-SQL people like me.... Collapsing all date columns into a single column using ETL, then applying a MAX in ETL or beastmode should also do the trick