-
Help With Creating % Of Total Column
Hello! I have a similar following dataset: Group | Claim Amount: A | $75.00 A | $20.00 B | $100.00 D | $200.00 C | $100.00 C | $30.00 A | $400.00 Total: 7 Claims I am trying to figure out how I can create a beast mode that will give me a percentage of total claims by count. So, trying to add a column that would output the…
-
Assistance With Creating a Bar Line Graph
Hello, I am trying to figure out how to create a line graph / bar line that will give me the variance change year over year based number of claims per year. I am not sure if there is an easy way/setting in Domo to automatically create a percent change YoY for me, or if I need a beast mode to do this. I have tried the…
-
Need Ideas/Help for Creating a Card
There are orders (non-unique) that can have multiple services assigned to them and can also have different vendors assigned. Trying to identify a way in Domo to weed out some orders that fit these criteria: If an order has 2 or more services under the same order number and if the order has at least one service code ‘GB’…
-
What does 'Last 3 Years' mean?
Hello, When Domo uses 'Last 3 Years' for a date range, does it mean data from 2018, 2019, 2020, and to present date in 2021, or 2019, 2020, and 2021? Or is it April 15, 2018 - Present Date? I am having some data that I expect in my results, but there is some data missing and I think it is because I am using the 'Last 3…
-
Help with Beastmode on Count with Condition
Hello, I feel like this should be a simple thing to do, but am stumped. I am trying to do a count of order numbers where there is a condition to be met. Is there a if function that I can follow to do this? For example, there is a list of vendors, some of which have registered and some have not. I want to count the # of…
-
Extra Spacing from Exporting to Excel
Hello, I have this issue where when I export to Excel, there is about 6 extra spaces at the end of each result.. When I export a card into Excel and click on a cell in the FirstName column, it'll show for example, "Max__", where _ = spaces. Is there any way to get rid of this?
-
Combining Different Rows into a Single Row
Hello! Was wondering if there is any Domo function/beast mode that can be utilized to combine results of a column across multiple rows to display in a single row. For example, if I had company name and office locations: Row 1: XYZ | Pittsburgh Row 2: XYZ | Fresno Row 3: XYZ | Dallas Could I have it so Domo shows 1 record…
-
Adding Column to Calculate Difference Between Weeks
Hello, I am trying to add an extra column that will calculate the difference in order volumes from week to week. See attached screenshot for details: Week 1 -> Week 2 difference is 7394 Week 2 -> Week 3 difference is 53 Week 3 -> Week 4 difference is 452 Basically using the current week's number and calculating the…
-
Adding a New Column to Calculate Difference From Week to Week
Hello, I am trying to add an extra column that will calculate the difference in order volumes from week to week. See attached screenshot for details: Week 1 -> Week 2 difference is 7394 Week 2 -> Week 3 difference is 53 Week 3 -> Week 4 difference is 452 Basically using the current week's number and calculating the…
-
Are Card Placements Unique to the User on a Page?
Hello, Does each user have their own unique view of how cards are displayed on a page collection? For example: User 1 sees: Card 1, Card 2, Card 3, Card 4 User 2 sees: Card 3, Card, 4, Card 2, Card 1 How can I get it to have User 2 to see what User 1 sees?
-
Are There Sometimes Visual Bugs on Cards?
Hello, I have been recently been seeing visual bugs on some cards that I am using and am wondering if anyone else has experienced this issue as well. Is there any way to prevent this some occurring? Wondering if it is a browser cache issue or Domo related. I have a few cards that show me a distinct volume of orders, and…
-
How to Display Distinct Order Numbers in Edit Path
Hello, I am in need of assistance of how I could display only distinct order numbers while drilling down on a card. I am able to to get my summary number and chart to show me 4 distinct order numbers, however, when I drill down on the chart, it'll show me a total of 5 order numbers. This is what the chart looks like:…
-
PowerPoint Export Issue
Hello, I am trying to export a powerpoint from a Domo card, but I am missing data when it is exported. I am only getting 24/27 of the rows from my card to display on PowerPoint. I've tried readjusting the size of the image, but it just enlarges it and does not show any missing rows. Does anyone know how I could fix this?…
-
ETL Missing Data - Assistance Needed
Hello, I am in need of assistance on trying to figure out why my ETL is some data. (I have tried a Data Fusion as well) I have two tables/datasets where it is from tblCoverage left joined to tblProfile. Both tables are linked by a unique vendor code. tblCoverage has a column named 'State' where it shows what state a vendor…
-
Creating a Distinct Column Name and Showing Last Completed Order
Scenario: There are thousands of customers that are placing orders on a daily basis, which include repeat customers. I am trying to build a card that will: 1) Show the customer's name once on my card 2) Show the last time they placed an order. Is there a way to make the 'CustomerName' column a unique value without creating…
-
Changing a Column from Measure to Dimension
Hello all, I am seeing if there is a way I can convert a column named 'isActive' from a measure to a dimension. Currently the values show as '0' or '1' as a measure, but I want this column to be under the dimension field and display as 'True' or 'False.' I am trying to avoid a beast mode calculation because the dataset the…
-
Is there a way to view all of my filters being applied to a table column?
Is there a way to view all of my filters being applied to a table column? I currently have 30 filters applied, but it only shows me 20 of them selected and 'and 10 more...'
