-
Join based on filter criteria
Table A (Completed Evaluations w/ dates & locations) Table B (Locations Universe, all available locations) Table A has all the same location columns as Table B. Table A also has completed dates and evaluation data, We want to show locations with completed evaluations for a user specified date period (i.e. using a date…
-
Running Total Group Bar - keep running total but show only current month, possible?
Hey all I have an end user that is requesting for a running total graph to only show current month but still retain the running total. When I filter for current month, it does exactly that, filters only to current month so the running total from the previous 2 months is lost, as I expected. I'm wondering if its possible to…
-
Avoid BeasMode Duplication in Bulk Switching cards
Hello everyone I want to try Switching all cards powered by a DataSet in Domo. This dataset is a really important one which has around 5000 cards, and many of our important reports and beastmodes are there. So I don't want to mess it up!. I created an identical dataset with same column names and I read in Domo Knowledge…
-
CustomApp - Dashboard & OtherCard
Hi to all, We developed a CustomApp to get "custom" data from AA and ee wish use a card build on this app in some Dashboard. We need that the CustomApp's card knows what are the other card that are on the dashboard to appropriately filter the query that the CustomApp's code make on AA. We can't set this constraint on…
-
When duplicating dashboards, is there an easy way to update the prefix of all duplicated cards?
When duplicating dashboards, is there an easy way to update the prefix of all duplicated cards? When I duplicate a dashboard, all the cards are duplicated as 'Duplicate of [card name]'...but I want it to be '[New Dashboard Name] - [Card Name]'.
-
104 Weeks as option in Multi-Value card
With so many industries moving to a 2-year CAGR in addition to their regular YoY comparison numbers, it would be great if the Multi-Value card allowed for a 104-week option as a quick way to build the change value.
-
General question on data from different datasets on the same card.
I have a card that is on a finished page. There is another metric that I want to add to a specific card that already has data displayed from a single dataset. This new metric is in a completely different different dataset that isn't attached to this page at all. Is there a way to pull in this metric to this card without…
-
Tableau-like Parameter actions
I am trying to allow a user to filter a chart that uses an aggregation. My data looks like this: I want a user to be able to choose 'Apple' and then the ensuing line chart would show percentage of items each day that were apple (40% over 1/1, 30% over 1/2, and 60% over 1/3). In tableau, I would set up a parameter (p_fruit)…
-
Exporting live cards to ppt.
I want to export a live card/ card table that is long and keeps updating as the dataset updates. The problem I am facing is whenever I am trying to export this card it only exports the snapshot of the card and not the whole card also since it is only the snapshot, it does not updates as the card in my domo instance…
-
Issue with Beast Mode Calculation not displaying on the card.
I am trying to find the conversion % for two different marketing sources. What % of those that inquire in either the walk in channel or the phone channel actually rented. I wrote this beast mode calculation, but nothing is displaying: SUM(CASE WHEN 'lead_source' = 'Walk_In' AND 'unit_rented_c' = 1 THEN 1 END)/SUM(CASE WHEN…
-
Market Share (% of Total) and % Change/Trend Calculations
Is there a way using beast mode, or some other functionality, to create the following two equations in a DOMO card — to display on graphs as well as in a table/pivot table. 1) Market Share as a percent of total. In other platforms like PowerBI with DAX this would be achieved with something like the following random…
-
Data Labels Font Color
I have some bar/column graphs that I would like to apply data labels with white font, instead of the default text color, for better visibility. Is there any way to do this? Thanks! Jamie H.
-
Pivot Table to show values on a row as opposed to a columns
Hi With regards to pivot tables. In Excel you can pivot the value to show this as a row or a column. But the option on a Domo Pivot Table card forces the user to create all of the measures as columns. Here is my scenario, I have targets as a beast mode for each region. I want to pivot a table by region as columns and…
-
Percent/Absolute Change WoW as a Beast Mode Column
Hello, I am a cardbuilder for my organization and I am having a tough time getting a Week over Week beast mode calculation correct. Our calendars are set on an admin level so the fiscal week is Monday - Sunday. In the screenshot attached, I want to show the % change WoW for the metric "Clicks". I want it so it will…
-
Pivot Table Average Summaries instead of Totals
Hi all, With the new pivot table card designs we can add Totals and Sub Totals which is great and sums values into collapsable groups. I can't seem to see a way to set a similar summary using a different aggregation like average, count, min and max. For example, I have data showing a number of staff working hours which are…
-
To Date Period over Period Cards - Flawed due to leap year?
When using the "to Date" cards, with a daily date grain, I'm noticing they show variance spikes due to shifting the dates 1 day, regardless of selecting YoY or 52 weeks as the comparison to, and I think this is due to the Leap Year. Another way to explain it is that the "align by day of week" option is aligning Mondays for…
-
Remove sum of row in card
Hi, I am building different cards (HTML, Filter) and everytime there is a sum of rows in the left top of the card. But the number doesn't add any value to the overview. Here is one example, and I would like to get rid of this information. (See example)
-
Domo Stories: Passing page filters through when linking to another card
Does anyone know if it is possible to pass page level filters through when your interaction with a card on a dashboard is to link to another card? From I can tell it does not look like it is possible. I also have visual bugs when using a slider filter and a checkbox filter concurrently has anyone else seen this?
-
Table Card not showing all columns
Hello everyone, I am building a simple (at least I thought) table card for my dashboard. The table only contains four columns, but when I save it, the card on the dashboard only shows three of them. I have played with editing the column width and the font size, but nothing helps. The card keeps showing only three columns.…
-
Add a PoP % change data label to a Period over Period Chart?
Good afternoon, Is there a way to add the Year over Year percentage change to the data label in a Bar Line Period over Period chart? For example, in the screenshot below is there a way to add a second line so the data label reads something like:0 This year: 2020-Apr: 8,710,963 +71% Thanks!
-
Card Details View - Links showing I didn't add
I have noticed that I have links showing up at the bottom of the Detail View that I didn't add there. Is there some other function in Domo that is doing this automatically? The only thing I can think of is that when I duplicate a card using the Save As function, is that what's making them show up as a Linked card?
-
Filter Out Current Week in WoW Card
Hi, I'm creating a Period Over Period card that displays number of tickets created as a week over week comparison. I'm running into an issue: I don't want to include the current week since the results are incomplete. * When I use Date Range = This Year, Graph by = Week, and Compare to = 1 Week ago: The Card includes all 52…
-
Pivot Table Card Collapse/Expand
The documentation on the Pivot Table card shows the ability to collapse/expand rows and columns as functionatlity but I cannot figure out how to do it. Can someone point me in the right direction? Here's the documentation I'm referencing:…