-
Failed to index using upsert method
Hi, during the initial stage, I had already loaded 6 months of data (hundreds of millions of records) with mapping using Magic ETL. I extracted the raw 6 months of data using Workbench, and Magic ETL connected to this raw dataset to perform the mapping. Upon review, I noticed that I missed mapping one type of document —…
-
Accounting Card
Hi, is there any table format card that is ready to use in domo suitable for displaying P&L accounting? it's a huge dataset and i need to aggregate them by month in a table. The dataset contains also different years, types and locations to be used as filters/variables. Plus, I am required to create and add hierarchical…
-
Total sales is 100% Calculation
Hi, i have tried solving this calc for the whole day but to no avail. Sincerely looking for help to calculate % of Sales in beast mode. I need my sales (of the selection whether by calendar type, location, custom period) to be always 100%, the sum of each category (numerator) will be divide by the total sales (14m in this…
-
Month Over Month Calculation
Hi, looking for help to calculate the Month over Month (MoM) with the metrics and months as above. I had successfully created my metrics by row, and Months by column in DOMO, however, I failed to create the calculated field for MoM Difference, and Mom % Difference as red in sample above. starting with 01-May because May is…
-
Connect and store dataset
hi, i need to connect to sap via odbc using workbench to get 530 millions data. these data must be stored in domo for data viz. they are range between 2023 until 2025 (still growing daily). i came across multiple methods online but not sure if they do work/or if it's the best way: append? partition? upsert? workflow for…
-
-delete
Please help delete this. My original post was backlogged, so it got duplicated.
