-
Tab Autocomplete Messed Up
For years when pressing tab on the keyboard when in a DOMO code editor it has functioned like an auto complete or a tab space entry, however recently this functionality has broken. Tab no longer autocompletes nor does it allow to add quick spacing for code readability. Instead, it moves to the next element in the beastmode…
-
Create Bar Chart with Current Month Vs Previous Month?
Hello, I have a data set of invoices that I want to compare in a bar graph where one bar is March and the other bar is Feb. I think I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
-
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.
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…
-
Looking to create a benchmarking bar chart showing +/- % from prior year
I am wanting to create a bar chart similar to below. I want the +/- % to be based on prior year CPM. I am not seeing a bar chart that would operate similarly to this - does anything have any experience with this? Thanks
-
Is there a way to "freeze" data in domo to compare net new information to previous information?
For example: I have Promo X that has been running from Jan – Dec 2023 and I can see the impressions for that time frame with no problem by filtering to that date range and looking at the data for that date range. | I’m now running Promo X in March 2024, and want to look at net new impressions to this promo in March 2024…
-
Clear all fields option in Analyser
Could we have an option to clear all fields in Analyser? Whenever a new card is created Domo 'guesses' which fields to include, this is never what we want so a quick way to remove all measures and dimensions would be a big help. Alternatively an option to diable the automatic population of data into the worspace would…
-
Early noob questions and frustrations around filters in analyzer
I'm experimenting with Domo and I'm trying to recreate some powerBi reports. I have successfully connected to our Jira instance for issues and I'm now trying to create some visuals and reports based on the "issues" database. One of the charts I'm trying to build requires me to filter based on a date field containing a…
-
Tab Functionality in Beastmode Editors Broken
For years when pressing tab on the keyboard when in a DOMO code editor it has functioned like an auto complete or a tab space entry, however recently this functionality has broken. Tab no longer autocompletes nor does it allow to add quick spacing for code readability. Instead, it moves to the next element in the beastmode…
-
Can I show positive (instead of negative) numbers in red?
I have a table that shows YoY comps as a percentage for four different metrics. For three of the metrics, negative is bad and positive is good. For the fourth metric, negative is good and positive is bad. I found the option to "Show Negative Numbers in Red", which works correctly for three of the rows but not the fourth.…
-
Ability to color code the "Other" Category for Pie and Donut Charts
Somewhere in the settings for pie and donut charts it would be great to be able to hard-code a color for the "Other" category that gets created when there are many items in the series. We have a lot of color rules setup for various fields and it is annoying/hard to read pie charts when the "Other" category's color keeps…
-
Reuse Beast Mode field in another calcuation
Requesting to allow Beast Mode field created in a card to be used in another calculation. This feature is currently available in the "Add Formula" function in Magic ETL but not for beast mode calculations done in Analyzer.
-
Beast mode to generate Batch Date?
Is there a Beast mode that can generate Batch dates? A colleague of mine has a dataset that updates monthly, but does not include a date column. The internal clients who view the report would now like to see a breakdown by date. Is there a way to use a beast mode, or some other tool, to create a batch date calculated…
-
Add a condition on line plot to toggle between AVG and SUM conditions
Hi, I have a column in my data 'Volumes' and I am using that as Y-axis of line chart which is currently set to aggregate as SUM(Volumes). I have a problem with it where I want it to perform AVG(Volumes) when one condition is met and perform SUM rest of the times. I am trying to perform this logic using calculated field,…
-
Add Table Design Param to Allow Setting of Table Borders Color/Weight
I get a number of requests for sprucing up our tables/visualizations so that they align with our company style guide/colors; including questions on whether Table borders can customized a bit [or removed in some edge cases—to me that woiuld just mean, set them to #FFFFFF if I had that as an option]. Effectively what this…
-
Organize values on X-Axis
Hi All, I am trying to sort my x-axis values on roles (see screenshot attached) not on the default sort options available in Analyzer. I read a previous note from 2017 that told me to use CASE to sort, so I did: CASE split_detail WHEN 'CEO'THEN 1 WHEN 'Head of Business' THEN 2 WHEN 'key management personnel(KMP)' THEN 3…
-
Bullet Chart Additions: Trellis, Choose which Data-labels
I would like to be able to trellis a bullet chart. Bullet charts were designed to show progress towards a large number of goals at a glance, but without the trellis, it functionally limits the number of goals that can be practically displayed in a single card. Also, the labeling on a bullet chart gets very busy when trying…
-
Average Length of Stay in Beastmode
I am trying to get the average length of stay using our admission date till our discharge date. I tried using the datediff function and got an error when validating, "Calculation error: whoops! something went wrong." I have flipped the discharge date and the admission date and the same error comes up. I feel like I am…
-
Issues with Hovering for Plots Once It is Embedded
Hello, I created a hovering feature for one of the plots with linebreaks via a beastmode. The hovering works fine within the Analyzer feature but once I try to embed the card, the linebreaks are removed and I see the '\n' that indicates where I placed the linebreaks. Is this a common embed problem and if so, how can I move…
-
How do I get percent of total on pie chart?
How do I get the percent of total on a pie chart? I added pie name and pie value, then change the pie value format to a percent. Rather than giving me a percent of a total, it is giving me the percent. For example, one of my numbers is 799. When I change the format to a percent, I get 79,900%. What am I doing wrong?
-
HeatMap Chart Colored by Columns
Please add the ability to color the heatmap by columns, instead of just all cells. Thanks!
-
In App Editable Data and Real-Time Visualizations
Hi Everyone, If users wanted to be able to edit the data that goes into a visualization, and then see how that edit impacted a visualization (and all of it's great metrics), what would be the idea way to do this in Domo? I was thinking that you could use a Domo Webform to let users plug in new data/edit data, and then use…
-
Smart Text - Add "Limit Rows"
It'd be cool if the "Limit Rows" value was available as a smart text - so you could have a card that's "Top 10 Customers" but if someone changes the "Limit Rows" it could update the title or description of the card.
-
Remedying Data Recording Issues on the Front End in Domo
I have a dataset with item names. These item names have a preassigned "price" to them that is not in the source data (although I know what they should be). What has happened is that some people (not all people) record their transactions all at once, combining what should be multiple revenue values into a single one.…
-
Can I omit certain values on line graph from being calculated in avg line?
I have an interesting case here, I have a cost per lead value being graphed by week for the past 9 weeks. Only problem is that when there are no leads the value is blank and the line breaks. I can fix the problem by using a beast mode to say when there are no leads to just zero out the Cost per Lead value. When I do that,…