-
Combining Disparate Data Sources on a Card
I know it's not possible to create a card that pulls in data from multiple databases unless you combine them with a dataflow / ETL. But I have a scenario where that approach doesn't make sense as the data is VERY different in structure. Basically, one database has detailed individual end-user records which I'm totaling…
-
Case statement in beast mode
Hi, I have five columns in the dataset named Product1, Product2, Product3, Product4, and Product5. I want to find out how many products have been sold in 1 transaction. All columns have value 'Y' and 'N'. To find out the combinations of 2 products bundle, I am using: (case when (`Product1` = 'Y' and `Product2` = 'Y') or…
-
Flex Table: Multiple change percent columns
I'm trying to build a flex table that can analyze both % change against the first value in my data as well as the penultimate value in my data. Flex table does not seem to have any functionality to allow different calculations of change percent for multiple columns. Any suggestions on what I might be missing? Thanks in…
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
highlight top defects
I have a dataset where I want to count how many times a distinct "defect alias" field appears and highlight the top 5 distinct ones. I.e. - Highlight the top 5 reoccurring defects. I tried to get a count, but doesn't work..
-
Period-Over-Period % Change in Multi-Value / Single Value Gauge
Hi all, Still new to DOMO (4~ months) so just learning the ropes. Please point me in the right direction if this is posted incorrectly or if im possibly not understanding something! I'm trying to accomplish a simple Period-over-Period % Change calculation and it looks like this is an ongoing question/problem and I…
-
DP22 - Using Beast Mode to Build Data Storytelling - Sales Pacing Graph
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case: We needed a way to display and estimate in real time how well our sales were pacing…
-
DP22 - Using Beast Mode to Build Data Storytelling - Adding Business Days
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case When evaluating different carriers for performance we needed a simplistic calculation…
-
DP22 - Using Beast Mode to Build Data Storytelling - Formatted Time Duration
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case We wanted a way to display how long an invoice took to process in a more human readable…
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the wrong data), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this post…
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
-
Build Top 3 Card
I have multiple contributors in my Db and I'd like to create a card where I can display who are the Top 3 contributors sorted by rank. I have tried using a dynamic text card and the adding the categories with the Text Macros but this solution won't work once I have more than 3 categories. Is setting the amount of rows…
-
Showing less time scale on line graph chart
Hi everyone, I would like to see more dates with this button. But I couldnt find where i could add button which i linked with a screen shot below. Thank you
-
Check which cards have 'Use fiscal calendar' checkmark ticked
One of our operation companies is evaluating if it should adopt regular calendar in lieu of current 5-4-4 fiscal calendar starting next year. Is there a more efficient way, other than manual checking, to identify which cards have ‘Use fiscal calendar’ ticked in Date Range? I don’t see such attribute in any Domo Governance…
-
How to reset dataset color rules?
I adjusted the name and data type for a column previous used to set dataset-level colors. Now my colors aren't working and when I try to reset them in the dataset, I get nothing but JS errors in the console. Is there a way to force the dataset to reset the colors without having to delete everything and start over? Thanks!
-
Common Card Building Questions
Once you are logged into the Help Center, you can move seamlessly between Domo University Training, Knowledge Base, Community and Support (using the head navigation menu) . Knowledge Base articles are a great resource to answer many general questions. KB articles answering the most common Card Building questions: * Card…
-
Summary Number Beast Mode - center align
Look for help on this I wrote a beast mode for a summary number Everything works but center alignment. Is this not an option for a Summary Number? CONCAT('<div style="font-weight:Bold;font-size:60px;color:Black;text-align:center;">', (CASE WHEN (COUNT(DISTINCT `Cost Center Level 0`) > 0) THEN CONCAT('As of ',MAX(`Current…
-
How to add last year's values to a waterfall graph? (YoY comparison)
Hi, I created a waterafall that shows the flow from opportunities to sales for 2019 and I would like to compare it to the year before. In my data, I have the 2019, 2018 and the difference between these 2 years, which I would like to add at the top or the bottom of the 2019 bar. Any experience/ideas on how to add this…
-
How to remove the summary bar in waterfall graph or move it to the beginning of the flow?
Hi, is there an option to remove the summary bar from the waterfall graph? As an alternative, I am looking to move the summary bar to the beginning of the flow instead it showing up at the end. Thank you!
-
Re: DOMO Dataset : Adding new column to the existing schema.
To add a column to an existing dataset, you would either need to add the column at the source of where it is coming from (i.e. via Workbench and SQL query) or create a dataflow with Magic ETL and add the new column there. If you haven't created a Magic ETL before, I suggest reading this KB…