-
Identify percent of people attending current event
I am currently trying to gauge how many consistent event attendees are attending our upcoming show. For context, we have 2 events every year and every registration for an event is on a separate record which I have categorized by year between 2021-2024. I am trying to roll this up into a table that gives us a percentage of…
-
Question on Expanding Data to Display Unique Values
Is there a way to take the data that has a start/stop year (Column A/B) and have it expand while retaining the associated notes from Column C? The data is in Domo, but can manipulate in excel. The goal is to convert columns A-C to E-F. Not sure which platform makes most sense to make this happen (excel, access, Domo).
-
Add ability to ingest all files at specific folder location using the CSV SFTP Push Connector
The customer would like a CSV Connector using Domo SFTP that doesn't need the file name to match the dataset name for ingestion. But rather just ingest all files placed in a specific Domo SFTP folder no matter the file name. 1- Is the customer using the Domo SFTP or their own SFTP server? Domo SFTP 2- Do they need regex to…
-
How do I logout of a domo instance?
I have created a new organization in domo everywhere so I could share dashboards with a client. Normally there will be a profile picture at the top of the page where I can select log out, but this does not appear within this new instance. How do I logout so I can login as someone else?
-
Beast Mode is Inaccurate
I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks! CASE WHEN GL Group Code…
-
Combining two datasets based on two potential fields
Hi, I have two datasets. One has pacing data, the other has monthly data. All rows have unique IDs, however the pacing data may have either an ID from the old system (legacy ID) or the new system (new ID). Pacing: ID 1 2 3 4 11 Monthly: New ID Legacy ID 10 1 11 12 13 2 14 3 15 How would I go about joining these two…
-
Can DDX Bricks apps bring up blank outlook email?
We are trying to utilize DDX Bricks and I wrote some code in javascript to when clicked open outlook and a blank email to a specific address. I have troubleshot my code decently, but now I wonder if it's possibly Domo not allowing it?
-
DDX Form Brick Only Updates If I put in two request.
Hi, I am using the DDX form Brick and modified it using Ellibot video on Youtube. It only runs when I fill out the form twice. Is there a reason for that? If I fill it out once it will not collect the data. If I fill it out twice it then runs and collects both sets of data. I am afraid that some responses will be lost…
-
DDX Form and Dataset Brick
Hello I want to use this brick: However ' Sync Now ' button does not trigger any action…my web_form does not gather any input. SyncToDataset is set to 'true'. Any thoughts?
-
Form and Dataset Brick Allow Users to Edit
I have installed Form and Dataset Brick from Appstore, and it appears that only the individual who installed the brick has the authority to access the "Save and Finish" options. Even if the owner of the installed brick grants ownership or access to other users, they are still unable to make changes. It's unclear whether…
-
Count items within a cell
Looking for a formula that can count the number of items in a cell, that are separated by commas and I am stumped. So in the example below, row 2 has 3 items, row 5 has 0, the other rows have XX items. Any suggestions?
-
return a percentage for a measure
I am trying to create a calculated field that will give me the percentage of share for the column total i.e. taking the unit from one data point of measure and dividing that data point by the total of that measure. Is that possible?
-
Is it possible to do a background change (At once) to some or all cards on a dashboard?
-
DOMO Office Plug-In - Excel Filter
Hello, I am working with a client on importing a item list, into their Excel planning worksheet. When I get to the "Setup Filters and Select Columns" it won't let me enter in multiple selects for the "contains" value match. I tried to add another "selling season" filter but it gives me a duplicate filter message. Any help…
-
Real null count in dates
Hello everyone, I am trying to get an accurate count of the number of blank cells for a column inside an ETL prior to using a formula to estimate the date in the event that it is blank. I included a test output dataset inside the ETL to track the number of blank cells as well the estimation before/after creating a new…
-
Set a moving average with a 12 month period to the trendline below
How would I overlay a moving average (12 month period) on the following trendline below: The data is by month - 2014-present and aggregated to a monthly rollup. Thanks, Garrett
-
Dynamic Weekly goals
We have 2 tables: OrderDetail - which stores order info like date, sku, quantity, price, ect SalesGoals - DateWeekStart, DateWeekEnd, SkuQuantityGoal, etc Is there a way we can do a visualization that dynamically shows the weekly sales against weekly Goals? I am new to this, so I am not sure the best way to set up the sql…
-
One text box for multiple text cards?
I may be coming at this wrong. I tried to concat but on occasion a zip is missing or something like that. I think I want to use a notebook card somehow, but my brain is blocking me from thinking outside the box. How would you get this data in multiple text cards, into one?
-
Batch Move of Cards from the Appendix?
Is it possible to "batch select" a group of cards to move to a dashboard (rather than moving one at a time?) in the Appendix?
-
Creating Alert to identify significant data changes from previous day
Hello, I am currently building a number of data control checks in DOMO for daily files which get uploaded to our client portal site. The cards all look fine and when viewing the cards I am able to see if there are any significant data changes from the previous day for a specific column of data. I am now looking to automate…
-
Average Count Distinct across Date Range
I am working on Turnover metrics and need to capture the average unique headcount of employees over a user selected date range. Here is what I've tried, but Domo keeps giving errors: COUNT_DISTINCT(CASE WHEN (Team Member status = 'Active' OR Team Member status = 'Unpaid Leave') AND Date BETWEEN 'start_date' AND 'end_date'…
-
can someone please help me for this question of magic etl
Magic ETL Activity Using the DataSet in Domo you created using Workbench in the previous activity, 1. Use Magic ETL to parse the currency code from the "Transaction Amount" column and separate the amount and the currency code into separate columns. Submit: A screenshot of the output of the data showing the different…
-
Turnover Beast Mode: Avg Distinct Count / Days in date range
I am attempting to create a Turnover Rate beast mode that would take the Average Distinct Count of employee IDs, then divide it by the number of days in the user selected date range. I've tried the following syntax, but I receive an error: Raw syntax: AVG(COUNT(DISTINCT CASE WHEN Team Member status = 'Active' OR Team…
-
Flag percent of change when it goes negative
Hello, as the title says I am trying to figure out a beast mode or add an additional column in a view/etl to flag a member when they logged in fewer times this current month compared to the previous month. I manually upload the month's numbers at the end of the month so we are measuring trends and wanting to reach out to…
-
Calculation error: Duplicate calculation name
Hello, sometime ago I noticed that when I am trying to update the existing beast mode calculation on validation step it shows me error message "Calculation error: Duplicate calculation name". The calculation itself is working and when I create a new calculated field with same formula but with different name I can validate…
-
Dropdown - Values
Hi Team, How to find choosing dropdown selected values. if i get, i will try to compare and dynamic values print in the dashboard. Thanks, Raja Parthasarathy 9791724400
-
Check for condition against the whole
Assume the dataset I am given looks like the following (below). My downtown store was flooded in 2023. Some of my customers may have moved their shopping uptown. I need to filter the list so I only see customers that had "Downtown" amounts in 2022, and also had "Uptown" amounts in 2023. In the scenario shown, I expect to…
-
line labels disappear when a "Show Right Scale" is applied
Is there a way to add this functionality? I love this feature, and it really helps tell the data story.
-
Filter on Total Column?
Can you filter on a total column? We are using a pivot table to calculate our selling capacity per areas, per therapist discipline but hoping to remove any that have a TOTAL less than 5 for all of the disciplines in an area combined. Wondering if I am missing a simple filter options vs adding a few more beast mode…
-
Custom Chart - Customizing the Legend Values / Displayed Names
I have a custom chart that lists all the counties in our state. When applying the custom chart to data, the legend populates the values. I want the legend to populate the names. Can this be achieved? The first photo shows how the legend is showing counts of the FIPS (counties) values. The second photo shows an example of…