-
Freeze cards at top of Page
Is there a way to freeze cards at the top of a page. Like a header card that shows the date. When you scroll down the page, I would like to make it so the header card is still visible.
-
Auto Refresh a card from Federated source
Hello All, is it possible to configure auto refresh at certain time interval when we have card ( visual ) in view mode I am only talking about federated connections in DOMO.
-
Adding a line on bar-chart
Hello, I have the following bar chart, it has some metrics and a target line that was defined under the "Scale Marker" section. I would like to add another point of data in the form of a line but I am not sure how to. Ideally, the card will include this other point as below: (sorry about the ghetto and bad drawing) The…
-
Is it possible to add multiple image tags in a single table cell?
I want both of these images to show AND be clickable in a single HTML Table cell <a href="https://www.walshportal.com/walshintegrated/images/logo-white.png" target="_blank" rel="noopener noreferrer"><img height="20px" src=https://www.walshportal.com/walshintegrated/images/logo-white.png></a> <a…
-
Calculation for days between 2 dates
I have a dataset that has 2 dates auction date and last payment date, both are in the same format "2021-06-03 05:00:00 AM" I am trying to write a beast mode that will count the number of days between the last payment date and the auction date. I struggle with any date statements, any help would be great!
-
Demo Marketing Calendar added to DOMO-DOJO
Hi I'm Duncan Domo and I'm new to this!! So hopefully posting in the right place. Summary: I built a Demo Marketing Calendar added to DOMO-DOJO I had a problem and I found a solution thanks to a video/advice from @jaeW_at_Onyx Video: https://www.youtube.com/watch?v=UO9YUfkSh7I watch this if you want to get into complex…
-
Initial Card Selection Settings
Every time I create a new card, the card opens with a set of pre-filled settings (a chart type selection, X-axis and Y-axis variables selected, a Summary Number selected). I have to un-click these selections each time before I begin building my card Is there a way to turn off these auto-filled selections? I looked…
-
How to identify and visualize the Top N percent
Given a set of companies and a revenue number associated with each one, sorted by revenue in a descending manner, I'd like to visualize the subset of those companies that comprise the Top-10% of all revenue. For example, if the set consisted of 90+ companies... Company1 $5 5% Company2 $5 5% Company3 $2 2% Company4 $1 1%…
-
Comparative Gage - What's wrong with my query?
Using the Comparative Gauge, I wanted to display our performance by whether the number of impressions have increased or decreased. Only, when I use the following window functions, I get a blank card with a downward arrow. Current Month: sum(case when MONTH(`Created Time`) = MONTH(CURRENT_DATE()) then…
-
beastmode help. Nuanced conversion rate.
I have a conversion metric that I use a beastmode to calculate it it's pretty straight forward. Rentals/Inquiries as can be seen below in the calc. sum(case when `unit_rented_c` = 'true' then 1 end)/count(`id`) Now what I am trying to do is take these inquiries that haven't yet converted to a 'unit rented', but are in a…
-
Creating a static column that doesn't interact with the date filter.
I am working with Google Ads Campaign data. I want my 'Campaign' column to display all the campaign names and not remove any names when the filter is adjusted. other metrics such as 'click through rate' I do want to be able to interact with the date filter. How can I take my 'Campaign' column and make it static, so it will…
-
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…