-
How to Remove Duplicate rows in analyzer?
I have used the LinkedIn connector to export the stats. I see duplicated rows. How do I avoid them?
-
What is the best way to calculate?
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…
-
UI/UX changes implementation
Hello Team, Hope you guys are doing a great time. I have recently observed that there are changes made across Domo UI/UX. I welcome the changes but have observed that fellow Domo user getting confused due to sudden UI/UX change. I would suggest adding hints across the whole instance where the changes are made. For example,…
-
Merged: Silent Updates
This discussion has been merged.
-
Removing Item when building a card & New Beast Mode window
Can you please return the feature that allows me to simply click the 'x' next to the item when building a card. In order to remove a dimension or metric I now need to select it and open up the properties and select "Remove". Half the time the configuration doesn't even open, or I have to wait an incredibly long time for it…
-
Add tooltip fields to the predictive modeling chart type.
Please add tooltip fields to the predictive modeling chart type. We have a customer request to have additional data displayed on the hover text. This data is not plotted on the chart, therefore it is not available to add to the hover text. Adding tool tips would allow for this information to be made available to the user.
-
Date Filter Card Will Not Toggle
Hello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card filter for my org. The one used at the moment does not toggle. So if I select the 30-day card filter, it will stay at the 30-day filter if I deselect the check box or slide the slicer. It will only go back to default if I clear…
-
Only show unique values of a column in table
Is there a way, in analyzer or ETL, where we can only display one row for each unique value of a column corresponding to a key column? For example, I would want this: ID Num 1 4 1 4 1 5 2 4 2 5 2 6 3 6 3 7 3 7 to become this: ID Num 1 4 1 5 2 4 2 5 2 6 3 6 3 7
-
Is it possible to add context to legend entries
Is it possible to add context to legend entries? For example if my legend breaks things down as: pending, in-transit, out for delivery I want to be able to add hover text that says something like: pending: at the warehouse, pending shipping label creation in-transit: with delivery partner, moving between shipping…
-
Is there way to extract week of quarter from a date column?
The default week() function extracts the week number from the start of the year and runs 1 to 53 or 54. I need to show week number within the quarter, running 1 to 13 or 14 within each qtr. Is there a way to do this using beast mode or using the formula tile in Magic ETL ? Thanks!
-
Fiscal calendar - select like other date-related filters, bulk enable on cards, apply to beast modes
We want to use custom fiscal calendars in our subscriber instances, so our customers can have their fiscal calendars. However, a few limitations of the fiscal calendar in its current form will prevent this from being useful for our published content. We want users to be able to choose if they want to view a visualization…
-
How specific can I get with dynamic scale markers?
Hi all, I'm working on a year-over-year card where I want to add a goal line that represents a 10% reduction from the previous year. However, this is a card that I have a slicer for, so I want that line to be dynamic as the data changes. Is that possible? The furthest I was able to get was to create a percentage scale…
-
Period over Period - Specific Date Field instead of Current Date
We want to use the Period over Period charts since they make comparisons between different periods very quickly. As you know there are some requisites to build a PoP chart and one of them is the "Date Range". We noticed that this field takes into account the current date so, for instance, "This Year" today it will give the…
-
Analyzer - Filters get rearranged alphabetized after saving.
Hello, I noticed recently that after I save a card and go back in the analyzer all the filters used to filter my data to build the card are getting rearranged alphabetized. I rearrange them and hit save..BOOM! rearranged again. This is not how it always has been and is becoming very annoying. Is there a new option that I…
-
Report to show how many cards use the same specific dimension
Hi Dojo - Good Day! Just wondering how I can create a report in DOMO to show how many cards use the same specific dimension in one dataset. for example, I have a Employee Information Dataset and I want to know how many cards use the dimension employee ID Thanks In Advance!
-
Beastmodes getting turned to Text
Hi, So I have been having this problem lately, all of the inputs of my beastmode formula are numbers, but it keeps classifying the beastmode output as Text. All of my columns are classified as floating decimals, there is no text in it, all the nulls are classified as zeros, yet it still keeps it as text even though the…
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
How can i write this sql statement in domo?
where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '2020-07-01') Statement below is a column I use for an sql query.. ROW_NUMBER() over(partition by a.Customer order by MIN(a.InvoiceDate)) as OrderNum I am getting an error while trying to convert this statement. I am not sure how to…
-
Conditional LIKE Statements, Does not Contain, NOT LIKE: Beastmode Only
Hey guys, To organize my blox_section column I created a beastmode formula under the Data tab in the Analyzer tool to create a new column called "Content Topic": My Case Statement is the following: (Case WHEN `blox_section` LIKE '%crime%' THEN 'CRIME & COURTS' WHEN `blox_section` LIKE '%sports/high-school%' THEN 'HIGH…
-
Beast Mode to add two values from the same column
I have a column that is showing different periods. the column breaks them out in 0-10,11-30, 31-60. Then there is a column called 'values' with the correlating value for those periods. What I am wanting to do is just add together the 0-10 and 11-30 periods together using a beast mode.
-
Best option for YOY comparison showing where we are now to that same period last year?
I am trying to show a comparison for total revenue for where we are now compared to where we were end of February 2021. toying around with different graph options isn't allowing me to slice and dice the way I want. It either is a line graph YOY by month or a progress bar that is using all of Last year and comparing it to…
-
Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue: I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using…
-
Hide Legend on Funnel Cards
On the funnel card, there is currently no option to hide the legend completely. This would be a useful feature.
-
Anything like Difference matrix, Difference between two pivots, difference within the value field?
I've searched around but haven't had any luck finding what I need, but I am not sure if I've searched the best way either so please refer me if this is a duplicate. I'll use dummy data to ask my question, but effectively I need the difference between two values across a couple of dimensions. The goal is different from our…
-
Beast mode difference shows blank even when using coalesce
@MarkSnodgrass and @GrantSmith, you both helped me with my last question and for the most part, it gets me in the right direction. The problem seems to be that a null value completely nulls the whole result (like in sql), even when using ifnull() or coalesce(), whereas excel does evaluate it correctly, albeit with its own…
-
Recommendation for best way to create this visualization
I have 2 columns 'years old when moved in' and 'Length of stay in Days' What I am looking to do is create a card (histogram?) that will take the ages and put them in buckets then show an average length of stay in days for each of those buckets. I already used the histogram to show the distribution of ages as a count, and…