jaeW_at_Onyx Coach

This is a Domo Stats dataset called "Dataset" it has attributes of ... datasets. You can only schedule it to run once per day.

it would help if you provided a screenshot of a sample of data (column headers are most important) and a excel mockup of what you're trying to accomplish.

Take the test. There is no cost for retrying. The test is multiple choice.

Create a Table of Dates with columns Report Date , Actual Date , Period Type 1/1/2020 , 1/1/2020, 'Current' ... then UNION all the dates with the offset 1/1/2020, 1/1/2019, 'Previous Year' 1/2/2020, 1/2/2019, 'Previous Year' ... then Fusion your lookup table to your transactional data. (this will effectively double your…

The Datasets dataset last run date. So create a beast mode case when <last update within 24 hours> then 'we are fine' else 'error' end replace the pseudocode. To only track 'the important' datasets, build a webform 'LU_ImportantDatasets' with the dataset ID. Then do an INNER JOIN to the Datasets dataset. Now you can alert…

@hamza_123 i don't understand what you mean by 'values first' and column after. Do you mean have the Row labels positioned after the metrics? If yes, then just use a table card.

If you want your visualisation to be one series per response choice (i.e. 4 people picked choice A and 3 people picked choice B) You need to alter the granularity of your dataset from one row per question to one row per answer choice. use the COLLAPSE function in MagicETL.

@Cartergan Case when `Department Name` = "Revenue" then ABS(`Transaction Currency Amount`) End By using double quotes, ", around Revenue, it's interpreting it as a column name instead of text. I believe you meant: Case when `Department Name` = 'Revenue' then ABS(`Transaction Currency Amount`) End Because you want to invert…

@jimmy Dataset Copy is just a type of Domo connector. It will copy a dataset. Set it to Append instead of Replace. Use Filters to limit the source dataset to just the subset of data you want to Append.

Where there is a will, there is always a way. Yes, there are a raft of writeback connectors. They are a premium feature, so have a conversation with your CSM / AE about Integration Cloud, https://www.domo.com/integration-cloud. If you have the technical knowhow you can write your own writeback connector.…

@Clement , can you confirm that the job is finished executing by the end of 15 minutes? What do the Logs say? https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/03Running_Workbench_5

assuming you use the APPEND model: it sounds like "for each row, calculate sum of revenue divided by the sum of all sessions." sum(revenue) / sum(sum(sessions)) over () you'll need to ask your CSM to enable aggregate functions in beast modes. Here's a tutorial video with an example:…

@user063417 , Analyzer decides what becomes a bar or a line based on position of the field on the series (ex 1st, 2nd, 3rd) So if you apply a filter that restricts from showing 3 metrics to 2 metrics, by definition, you'll shift position of the metrics and therefore reassign Inventory from Line to Bar (for example). As a…

i assume your use case is something along the lines of randomizing an employee name. if you want all cases of 'ABC' to update to the same value 'NVA' you need to create an anonymization table that has a list of all the employee names and then the anonymized value that you changed it to. Then JOIN the anonymization table to…

Sorry. I'm asking the dumb question re:access token. yours is perfectly reasonable. I think i'm misunderstanding your use case. you're trying to send data back to Domo? Replace_ds according to documentation is for updating a dataset IN Domo https://rdrr.io/github/domoinc-r/DomoR/man/replace_ds.html You could try to run…

@Benjamin , splitting data into Current and Archive might be a solution... but are you sure the problem will be resolved by splitting the data into two sets? obviously i can't see your ETL, but it sounds like you're just moving your execution time bottleneck to another place... how are you building up your archive? b/c as…

@user055735 , this is a VERY broad topic / question. do you have some sample data you can upload? do you have a final dash board in mind that you want to build? a way to think about getting started would be 1) pick 4 or 5 categories for each free text answer 2) decide HOW you'll identify if the text answers the question.…

https://knowledge.domo.com/Prepare/Magic_Transforms/DomoR_Plugin/DomoR_Usage I assume you're using a fetch() and just dataset_ID ... dumb question, the access token you're using, have you confirmed that it has access to that dataset?

hey @user053351 , you can use FUSIONS + Webforms to create parameterized queries. check out this video for an example. https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=7&t=59s

There's a lot to unpack here! 1) don't JOIN your date dimension to your transactions to get the day count. instead APPEND the two sets of tables and conform columns so the Transaction Date and CalendarDim_Date line up. Then assign an activity type "Transaction" and "Calendar Count" to differentiate the two datasets. Why?…

@Billobi you can also use the border element too subdivide your dashboard. Domo will assume that content between borders are supposed to fit on one page, so if your content exceeds one page, it'll throw an error message in the Dashboard Design mode.

@clloyd01 my pleasure! If you run into more problems feel free to AT mention me or DM me at jae@onyxreporting.com. I create content based on problems in the Dojo, so message me if you run into a good brain teaser. sorry for the plug. Since producing those videos, I've gone freelance, so if you need direct support in…

if this is a production dataset, absolutely you should do everything possible to minimize the strain on the system. content management activities like minimizing beast modes, removing unnecessary columns, removing unused cards etc. will all help. additionally, follow best practices a DBA would implement to improve query…

a CASE statement is not the optimal solution for this problem. For maximum dataset reusability, you should implement a Window / Rank function in MagicETL to calculate row_number. In this case you'll Partition by Check_ID and then ORDER BY date desc or however you identify the 'correct' version of the check. Then in your…

@Sweep_The_Leg , Data volume can be a contributing factor. Filtering on DateTime instead of Date doesn't help either. If a dataset was updated recently, performance can feel sluggish until the cache / query history warms up. Are you working with a Fusion? Maybe build cards on a 'Dev dataset' that has a subset of the data,…

@riley_finn and @user10986 , tthe median() function can be enabled via feature switch. Ask your CSM to enable it. I believe the feature was added more recently, so the documentation and or UI may not have been updated to include it. Defo feedback for the "product feedback" button.

@user003911 , it's really hard to help you. can you post a sample dataset? or some screenshots? "same invoice number" as what? another row? or another column? do you actually have duplicate rows of data in your dataset? "pull one of the amounts" ?

@riley_finn , there isn't documentation on the set of functions available. you can see the list in the beast mode editor / creator. and most days of the week the functions will follow MySQL syntax. Median can be enabled using a feature switch (talk to your CSM) but that may be why the function isn't appearing in the UI.…

@JeffDaySJP i hate to say it, but I don't think you're going to get this one across the line without pre-aggregating your data. with the new Data Views beta, you'll be able to generate the aggregation in a VIEW, a la. CREATE VIEW new_domo_dataset as SELECT count( distinct customer, date) as visit_count, customer, date from…

@HelenHimmelman , at the moment, no i don't believe it's built into product. There is a beta feature that will enable a default filter. (I believe). create a BIG, conditionally formatted text box that said case when count(distinct currency_code) > 1 then 'HUGE ERROR' else 'currency code end). ... in reality I think they…