-
What is the best way to filter open-ended comments on a dashboard displaying survey results?
We have several dashboards that we've built to review customer survey data. We always have several open-ended questions/comment boxes on these surveys, with thousands of responses. Currently, I have these text responses set up as drop-down selector filter cards, which then populate table cards that are used in dashboard…
-
How to invert x/y axis at Scatter graph?
I Would like to invert y and x axis at my Scatter graph where the bottom would be the positive number and when goes up it reduces. Same for X axis. This is the card I'm trying to fix: and I want to look like this (from a excel file chart):
-
SORT!
Need to be able to sort data from most recent date first to oldest date last for GSheet writebacks that take 22 minutes to finish so newest dates are available to view immediately while older dates eventually show up.
-
🎊 Congratulations to our New Community Coach DataMaven!
It's evident that our community is beaming with truly brilliant individuals when we get to announce not one, but two new coaches on the same day! @DataMaven has been a member of the community for over six years, so it was only a matter of time till she joined the ranks. She has earned our highest admiration for being one…
-
Average Session Duration Y/Y
I am importing GA4 data and trying to display Y/Y in a multivalue on a dashboard. I used SEC_TO_TIME(Avg. Session Duration) to change the data to time format, but it's still not showing appropriately. Any ideas?
-
New Chart Type - Timeline
Currently there are a few ways to show a series of events such as Calendar and Gantt chart. However, neither provides the clearest snapshot of current and future projects to help with decision-making while being visually striking and intuitive enough to be distributed across the wider business.
-
GA4 Weekly and Monthly data - should I schedule a better import or make an ETL?
I'm not sure which direction to take - has anyone dealt with GA4 weekly, monthly, and yearly datasets before? I've realized that if I need to get a summary number of users over a certain time period in GA4, the only true way to make sure they are not double counted is to make separate datasets that pull in users by day, by…
-
Issues with new Domo for Office Add-In
Wondering if anyone else is experiencing an issue with the new Domo for Office Add-In. When I attempt to open the add-in in PowerPoint I receive an error that says "Sorry, Domo for Office requires a more recent version of Microsoft Office" it then specifies that I need PowerPoint 2016 of later on Windows. I'm already…
-
Line chart to show the values as % of the column total
I need to create a line chart in Domo with my existing dataset. I have the idea in excel pivot table but I need some help in getting the same in Domo line chart. As an example, my pivot table is this data: Count of ID Column Labels Row Labels Plan A Plan B Plan C blank Grand Total good 89 4 29 260 382 bad 7 2 5 106 120…
-
Network Down or Performance Issues Alert
Hello, Have an alert, when we have performance or network issues at DOMO. Just so we know when those occur, in case we are working with clients during that time.
-
Chart Showing only Projects with Cost; how to show all projects?
Hi all, I have a simple Table Card with only two filters, one for project number, and one for project phase. 97 projects meet this criteria. One piece of information I'm displaying in the Table Card is the planned project cost. At the moment, only 50 projects have a planned project cost. The chart is only showing these 50…
-
Workflow - running workflows without using alters.
Is there a way to run the workflow without using alerts? Currently, the workflows I have run great, but I have to link them to alerts. Alerts limit me to just three options: When value is created When value changes When value is deleted If I just want to run the code, there is no option (or I can't find it) for that…
-
Number abbreviations
Hello! Is it possible to abbreviate numerical quantities displayed as currencies inside analyzer? For example, in the picture below it says 21 but that is times 1 BN. Is there a way to include the 1 BN abbreviation without having to do any sort of modification inside the ETL? Thanks!
-
How to show a unique count for a different period than the selected date range?
Hi All, I have a card where I am showing a year to date breakdown of assets, in order to show this I have 'This Year' selected for my date range. However ideally I want to show a count of unique accounts as at the end of the prior year, a count of unique accounts as at the end of the current month and the difference…
-
Prepopulate Filter
Hi hopefully this makes sense. I am trying to prepopulate a filter based on the users last input selected. The rows in my dataset have a staring city location and an ending city location to get possible routes. The first method I tried was to join every starting location on every ending location and then from there join…
-
Rank Beast Mode with Issue
I´m using this formula to make a RANK rank () over (order by sum(NET_SALES_CY)desc) The table show the rank correct. But as soon as I try to filter my top 10 customers on table using the rank, I receive this error message An issue has occurred during processing. We are unable to complete the request at this time. what am I…
-
Google Analytics advanced connector not working
Hi, I am trying to connect our Google analytics account to Domo. I am using the Google Analytics advanced connector, but the views are not showing. It should show 2 views, like what we have in Google analytics, but it is empty. I am using a free Google analytics account. Can you please let me know how I can connect the GA4…
-
Possible to Connect Domo Card within Excel?
I presently use the function of connecting data sets within excel. However, is there a way to connect an existing card to excel? I have a large data set that will take awhile to refresh in excel. The only solution I've seen is to create a modified data set using filter in an ETL.
-
Beastmode to decide how much to spend per ad in a given category
We have a working beastmode that calculates what ‘n’ should be depending on spend, revenue, and page depth (page depth is in 3 categories – all pages, product, and shopping cart). Here is the formula: = 1 / ((spend / revenue) / (sum (all spend per category)/ sum (all revenue per category))) Note that the category of all…
-
My beast mode is not calculating correctly
SUM(SUM(BILLABLE_ORDERS) FIXED (add COUNTRY_NAME)) / SUM(SUM(ATTEMPTED_TXNS+VOUCHER_TXNS) FIXED (add COUNTRY_NAME)) It should be 0.82 Below is an extract of the data
-
Syntax of ANOVAF(), ANOVAP() and TTEST()
These functions are supported in the Fx Tile in Magic. Does anyone have some syntax examples ? The function requires an aggregation context suggesting a group by action
-
Save As in Locked Cards
I would like to lock pages and cards so that only a users assigned to a group that owns the card or page (or is an admin) can edit them, but want all users with a user role that allows them to edit cards to be able to duplicate (save as) the card to their own overviews so that they can manipulate them.
-
Pivot table values on row or column
I didn't see any posts about this in the Analyzer Ideas section, so if there is already a post out there, I will upvote that if someone can send me the link. Anyway, pivot tables should have the same functionality as Excel where you can move the values to either rows or columns. The current solution is to create yet…
-
Beast modes with multiple datasets
Hello! Is there a way to make beast mode computations with different metrics from different datasets? For example, I have the below cards that, although the numbers are the same (I am building a reconciliation section of a dashboard), the datasets used to create them are different. Now I'd like to compute the difference…
-
Very Simple Question on how to get data
Hi, I am not familiar with how to retrieve data from a dataset. Ive tried taking premade bricks and trying to learn from that. The dataset I have is 1 row with 3 columns. I assume I would just create variable name and assign the value to the column. However, I have no idea how to get it to display. I am comfortable in HTML…
-
🏆️ Introducing our Newest Coach, DavidChurchman
It's time to welcome a new coach into the fold! @DavidChurchman has worked long and hard to attain this prestigious title and it has finally paid off. This is the highest rank a community member can acquire and is a sure indicator of Domo knowledge and expertise. David has been a member of the community for about a year…
-
Is there any way to hide cards on a scheduled report?
Hi All, I want to publish one of my dashboards as scheduled report however I have a few cards at the bottom of the report for validation - is there any way to keep these on my dashboard but to hide them in the scheduled report? Any help would be greatly appreciated!
-
Moved: Can I copy beast modes from one ETL to another without changing the names of them?
This discussion has been moved.
-
Tracking Cards with Errors
Hey All, Our organization is trying to find a good way to keep track of cards that are broken. We want to be able to address any card errors as soon as they come up. Right now it doesn't look like any of the DomoStats or Domo Governance datasets allow to report on card errors. Curious if anyone here has had a similar need…
-
Variables Smart Text - Chart axis + legends
I didn't see a feedback section, so I will just post this here. I feel like there is a big miss with the variables product. You can currently leverage smart text to allow your chart titles to change when you select different values for a variable. However, you are not able to utilize smart text for labeling chart axis or…