-
Does domo allow a dataflow to run for more than 24 hours
I have dataflow that gets failed when it tries to completely run a dataflow that runs more than a day. Is there any solution. can the dataflow can run more than a day. Can anyone help me with this problem?
-
MS Office PowerPoint Variable Integration
Hey Community, We are looking to get some better integration with variables in the office plugins. Specifically, we are looking at the Powerpoint plugin, and we want to be able to bring in cards and dashboards that have Beast Modes utilizing Variables in the calculations. Perhaps something like you do for Filters, the…
-
Domo Sandbox Instances
I'm using a shared account to log into Dev environment (https://company-dev.domo.com/). In there, I've imported some datatsets to create 5 dataflows and eventually an APP in the Dev Instance. Then in Sandbox, I created 2 repo: Dataflows (5 ETLs) App It got pushed successfully. But my question is how can I see those…
-
Income Statement: How do I join 'Chart of Account' table & 'GL Records' correctly
I have 2 tables: Chart of Account - Right Table: notice that there are Addon Repairs, Restocking Charges, Contractor Discount in 'Cost of Sales Others' 2. GL Records (for all branches from Feb 2024 - Sep 2024) - Left Table Problem: I've tried both Full Join, Left Join (key: gl_account_id) then make a pivot table (filter a…
-
Data type of column changing from text to integer after import
I have a dataset column that has number and alphabets and is a text column while uploading. However after the dataset import it changes to integer and the text values become null in the dataset. Even if I change it in magic etl, it converts to text , but the null values still remain the same.
-
Can I move a variable to one column from another?
I want my Credit Type 1 to have just Position Owner or none, and Credit Type 2 to have Candidate Owner or none. Can this be done? I was trying the below SQL statement, but it is not working. SET Credit Type 2 = Credit Type 1WHERE Credit Type 1= 'Candidate Owner' AND Credit Type 2='none" I am just learning SQL, so still not…
-
Convert time to decimal
Good Afternoon, I want to convert my wrapup voice time to a decimal because I want to be able to use that number with interactions to be able to get my Calls Answered, is there a way to do that?
-
How can I change a cell that has not data to say "none?"
Hello, I have data set that I used the split column in magic ETL. If the column has a blank cell, I want it to say none. Is this possible in ETL or a beast mode? Below is the example, where there is yellow (credit type 2), I want it to say none.
-
Variables with Python Forecasting
Is there a way to use variables with a Python forecast model like ARIMA or Random Forest? I have a linear regression working, and I'm able to extract the coefficients, create variables, and use a Beast Mode calculation to generate a forecast. However, I'm unsure if this can be done with models that aren’t linear. Ideally,…
-
How can I mark a duplicate row instead of deleting it in magic ETL?
I use domo to handle metadata transformations for music tracks, and for publishing purposes it's important that I don't have any duplicate track titles. It can mess with the royalty payouts. So basically I want to mark a row as a duplicate based on specific values in columns/rows instead of deleting it. Ideally I'd love to…
-
How to Count the same record again with Multi-Selection Attributes
I have a multi-selection attribute with 19 selection options within it. I am trying to group these 19 selection options into 5 slices on a pie chart with this code: case when Impacted Business Division_p LIKE '%Biologics%' then 'Biologics' when Impacted Business Division_p LIKE '%CGT%' then 'CGT' when Impacted Business…
-
Filters not displaying all data present in the dataset used.
I have a dataset which is used for cards, when filtered by dropdown cards, even though the value exists in the dataset under same column, the filter is not working on all rows, even though the data seem to be existing in the dataset and working for other columns in the same row. What could be wrong here? The below have…
-
Multi-Select Variable
The ability to toggle a variable to be multi-select (in string type only) that will create a comma delimited string of all the values selected from the variable.
-
Add on option to Save Filter for Cards added in Favorites
I can save filters in the card added in my Favorites Can we have saving filters as well for cards in Favorites please
-
Is it possible to duplicate an entire dashboard and all cards on it?
Hoping there's an easy way to do this with just a few clicks, rather than doing a Save As on each individual card, then rebuilding the dashboard layout. Thanks!
-
Treemap colours
Hi, is there a way to colour the items one colour based on the group ? It does not seem to work.
-
Removing Duplicates and making sure only the one with the most recent move in stays
I am working on an ETL where I am transforming some unit rental records. I am trying to only include the most recent rental for the unit not historical data but the input dataset includes historical data. When using the remove duplicates tile I do not have control over which ones are removed or added as they arent…
-
What's the best way to pivot this table
The table on left is what I currently have, what's the best way to pivot in ETL, I also want to calculate the growth rate, for example the growth rate for A would be (110-100)/100 and second month would be (120-110)/110 How can I use pivot component in Magic ETL to get there and what's the fastest way to calculate the…
-
JSON No Code Connector Pagination with Sam.gov
The sam.gov API supports JSON pagination, but it's not clear if their API is supported with Domo's pagination options. Sam.gov does include a next link, but it includes a placeholder for the api key, which needs to be replaced. Domo adds the configured api key as another parameter, but don't see how to configure Domo to…
-
How to Flag/Color Duplicate values?
Hi, I have a list of contact information; one column is the Contact's Full Name. I am trying to set a rule where both rows are highlighted when two names are identical. Similar to how in Excel conditional formatting will color identical values.
-
Delete the most recent update on an existing dataset?
I loaded in a dataset A → Settings → bring in dataset B, Update method: replace (it's supposed to be append). So now I need to delete the most recent update, but I don't have that option since I'm not the Admin. I remember someone answered in a community post saying that in you can add some text into the Dataset History…
-
On card details pages, under the viewcount where users are listed as circles, how are they chosen?
I'm trying to prune unused cards. I'm an admin but don't think I have access to the activity log, I've seen it mentioned but the option doesn't exist anywhere. Some cards have hundreds of views, but the only avatar I see is my own. On other cards I see other people. Does this mean no one else has viewed it recently? Is…
-
350-501 SPCOR exam passed
Hi Everyone, i am happy and share my journey that help a lot of students who struggle with there career. i face a lot of challenges during my studies and i have no idea about my career. then my professor advice me to learn skills and he recommend me the cisco 350-501 SPCOR certification. i start my preparation immediately.…
-
Inline editor taking focus on dashboard
I have added inline editor to a dashboard in order to review some regular cards and then have the ability to update some values in the dataset linked to the inline editor. This part is all working well. However, I have noticed that the inline editor is taking the focus on the dashboard when it refreshes. This is…
-
Sum Distinct Not working Correctly in the Total
Hi, Am I overlooking something? I have a table and a beastmode using sum Distinct, however the total is not adding up Correctly. The total for Projected Loads should be 12,682 not 8596. I dont see any two numbers in the sub totals being the same. Thanks in advance
-
Counting or Grouping?
Hello, embarrassed to ask what's probably a fairly basic question… but hey, we're all new at some point, right? So here goes: I'm building an app for a department at my org to bring in event data from an external platform (API hurdle crossed✅). I would like to show a few cards for things like an event count per month, per…
-
Is there a way to remove cards en masse from my "Shared" page?
Is there a way to remove all the cards from my "Shared" page? I don't want to delete. Just want to get them out of "Shared".
-
How to pull data from a report within a website report
Hello, We pull pricing information from the USDA: https://mymarketnews.ams.usda.gov/public_data Previously, we used an advanced HTML connector and it was easy enough to just swap codes out in the path to pull the item I wanted information on - example below ONS was for pulling onion pricing. They have changed their website…
-
Is there a way I can see what dashboards a card is on from the card details page?
I am trying to do some auditing of what visualizations are being used from datasets as we are preparing to swap source data. I want to be able to easily see what dashboard a card is on without searching for the card in the admin section. Previously, I was able to click on the Move/Copy option and it listed what pages the…
-
Any ideas how to best visualize boolean data?
I have data where as checkboxes are used to describe an event - on the drill of the event - I am looking to represent visually if the check boxes were utilized… this is how the data is gathered on the collection form… any ideas out there? I would like to use the Checkbox selector chart type - but you cannot populate the…