jaeW_at_Onyx Coach

コメント

  • Workbench relies on several services to function https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/04Starting%2C_Stopping%2C_and_Restarting_the_Workbench_5_Service Try Start > Domo > Workbench Monitor.
  • @MarkSnodgrass and @user08570 , the new Beast Mode Manager beta has a feature that allows you to bulk copy Beast Modes from one dataset to another. If you don't have the BMM, talk to your CSM to get added to the Beta program.
  • @eriena two things to check. 1) the governance reports are only accurate up to the time they were executed. Was the page created AFTER the last time the connector was run? 2) if you're pulling 'Page and Card' then it should capture the cards SHARED to a page. if a page has no cards on it, then it makes sense that it…
  • In the official Domo literature and training they'd recommend you use a 'Remove duplicates' tile and build a recursive dataflow. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow Problem with 'remove duplicates' is there's implicit randomness to how 'duplicates' are…
  • As i understand it the iframes in Domo apps are all sandboxed as a security feature, hence why this would stop working (see linked article). I don't know of a workaround, this might be a question to direct at the apps team via support.…
  • https://www.webretailer.com/b/amazon-vendor-edi/ It looks like Amazon Vendor Central functions completely ... different from most other connectors. AVC uses an EDI exchange whereas most connectors use an API for data exchange. From the little bit of research i did, it looks like there are third party integrators that will…
  • Which ETL method are you using (redshift, magic, MySQL)? https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/DataFlow_and_DataFusion_Troubleshooting_and_FAQ Base MySQL does have column and row width limits. If you have one or two absurdly wide columns, try excluding them from your ETL. Does it make a difference? If…
  • if you're comfortable writing javascript, have a look at developer.domo.com specifically: https://developer.domo.com/docs/custom-connectors/connector-dev-studio, this might be a more ... satisfying experience. without a sample of data or screenshots ... i don't really understand what you're asking.
  • 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.…
    Text analysis jaeW_at_Onyxによるコメント May 2020
  • 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.