-
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:…
-
Create a card with variance
Hi Dojo Team, I'm new in domo and started to explore it. I need your help while creating a crosstab chart or Table chart like below image. I have three column which inlcude Date, Additions, Depreciation. From all these three column, I want to calcualate variance between two months like below table.…
-
Card and Beast Mode to Isolate Best Performing Stores
Hi all, I need some ideas and help in trying to isolate best and worst performing stores based on say a monthly or YTD YoY ratio. I don't know yet where to start but I would like to have an option to look at YoY differences for the month or for the year and then develop a ranking type chart of best and worst performing…