-
Comparing year on year figures
Hi, I'm looking to compare yearly figures from ‘Contractor Completion’ from 2019-2023. We'd like to know the percentage change for YoY and comparison by month too. The flex table or line chart looks like a good way to show this. What would be the best way to do this?
-
Top Sales Week by Closer
The objective is to get the closer's best week of sales without creating an ETL as we want this to be dynamic with the date range selected on the card. We have a list of sales (each have a unique opportunity Id) with project sale dates and closer names. I had thought this formula may work but I'm having issues: RANK() over…
-
Schedule Report - Weekly data report every Friday
I am trying to schedule a weekly report that would be sent out every Friday morning for data between the previous Friday and Thursday of the current week (7 days/1 week). For example, data range is 3/3/2023-3/9/2023 for this week's report, whereas next week's report would be data range 3/10/2023-3/16/2023. Is there a way…
-
Magic ETL Joins - include table name as prefix
Hi All, When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns? Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.…
-
Writing a Case Statement select another field value if primary field value is blank
So I am trying to write a Case statement to select a different field to pull a value when the primary field has a blank value… Something like: CASE Parent Carrier ID WHEN 'null' THEN Carrier Name ELSE Parent Carrier Name END I don't know what to enter as a valid term for ‘null’ to represent looking for empty values?
-
Cards - BeastModes Need to Know the Dates that are selected by the user (card/dashboard level)
I am always trying to find a way to detect what the user has either selected for a date on the card or the dashboard when building my BeastModes. Can Domo not find a way to pass this in as say a Macro or something. And I am saying Macros for both the card and dashboard level date selections
-
Export to PDF error - images
I have a dashboard that displays information with a field containing a person's id. On one of the cards, I display an image of the person. The card uses an html table to display the person by calling an image url. When I try to export the dashboard to PDF, the export fails. If there any way to tell Domo to ignore a card…
-
How to hide columns in table report which are not having any values
Hello Team, I have a requirement in the table chart where columns are months like Jan, Feb,Mar,.. , Nov, Dec. I need to hide column months which are not having any values inside it
-
VIDEO TUTORIAL: How to calculate Percentile Rank (for A/B testing)
Percent ranking answers what "% of values were less than Y." Kudos to @GrantSmith for the question. This is useful for comparing test results in two populations. Imagine 67 respondents tested 75% or les whereas in group B 99 respondents scored 75% or less. To calculate % rank, you calculate the rank and divide each rank by…
-
Need to chart 2 timestamps for a status time and graph the whole day
I am looking for ways to take 2 timestamps, a start, and an end timestamp, and chart them to account for a user's activity that day. I am using call center agent status times and want to have a bar chart for each agent that shows their status for the day and then plot in the calls that came in with wait time and talk time.…
-
hide and show card on the dashboard based on the filter selection
I want to hide and show cards on the dashboard if user selected any filter then hide some cards and if user remove that filter then card should be visible.
-
How do I view the last activity for a card (and dashboard)?
Last year someone asked whether there is a way to see the last activity for a card, but it did not get directly answered. So I am asking here. Specifically, I need to do a major clean-up of old cards and dashboards that are no longer used. To do this, I need a report on the last activity date (the last view). Currently, I…
-
Beast mode to select all the slicers
I have a column that populates the below 7 options, I would want to have another option 'All' which displays numbers of all 7 cases instead of manually selecting all 7. I am trying to write a below beast mode for the same but the 'All' option would not include all of the cases. case when combination = 'desktop' then…
-
Is there a way to create a dark or black border around a card?
the users want the tables and cards to stand out better form the Wite background of our company logo but the only way I know how to is to change the collor. they just want a border or a shadow to make the card stand out
-
Percent Change Beast Mode Calculation
I cannot figure out how to do the beast mode calculation for this. I would like a percent change column for the most recent month to the current month? How would I do this? I've tried watching videos and this data seems to be set up differently then those videos.
-
Date selector calendar autorefreshes
Is there a way to keep the calendar view on the Date Selector filter to keep from auto-refreshing to the present month when dates are selected? I would like to keep the selected month in view. I'm sharing below a gif of the issue I'm encountering. Thanks!
-
Is it possible to show labels on "small" cards in dashboard?
It seems that no matter how big the actual graph element (e.g. pie chart), if you have more than 4 cards in a row the data labels will not show. Weirdly, the pie charts themselves in the 5 card row are considerably bigger than ones above in a 4 card row due to being tall cards…..for both rows, data label size is set to…
-
Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state. E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No” in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No” What graph/table would you use to display this in…
-
Beastmode not recognising exisisting column
Hi All, Two columns that have been added are not being recognised in the beastmode I've written, Please let me know if I'm missing something or if it's a bug. Kind regards
-
Number of Posts Published
Hello, Trying to figure out the best way to show posts published for x period of time. I believe I need to use some kind on minimum date so the post would only be counted once but have not had any luck. This would help understand the number of posts needed to see consistency and gain increase in engagement.
-
Defining Custom Color Palettes
It would be nice to be able to define custom color palettes to choose from. I don't mean the ability to set color rules on datasets or cards, or the white label features in embedded analytics. I mean adding your own palettes to the color picker for internal dashboards. Right now, having to use hex codes for everything is a…
-
Disable slicers from being displayed as filters on top of the dashboard
Hi, I am using slicers in the dashboard but since the page is too long, I plan to duplicate these slicers and use them in the 2nd half of the page as well. However, I do not want to display these slicers on the top of the page as filters. Is there a way to disable the filtered view for slicers?
-
Custom Sort in bar charts
I followed Domo tutorial to create a custom sorting https://www.youtube.com/watch?v=QAKgsoRweQM but mine it's not working as I expect Firts I created a beast mode to transform my column like this: DATE_FORMAT(`Snapshot`,'%b') and then I needed to sorting by month so I try to create another beast mode like this: (CASE WHEN…
-
Is it possible to define a color rule for data point 1 based on its value relative to data point 2?
I have 2 different lines with symbols on a graph. One line represents the target value and the other line represents the actual value. I want the symbol on the actual value line to be red when above the target value and blue when below the target value. I understand that I can change colors based on whether the actual…
-
Antithesis Filtering on Dashboard
Hi all, When filtering on a dashboard - traditionally, my process is to have a few filters at the top of the dashboard, which are my top-level generic page filters. This process works great for me, and it's standard across our dashboard offerings that our audience understands. I've now started building a dashboard where I…
-
"Jump" button that scrolls to section of dashboard
Hello, I have a dashboard that has a hefty amount of cards that are organized into sections marked by headers/borders. Is there a feature in Domo that allows me to add a button that users can click to automatically scroll down to a section? And in the same vein, perhaps a "back to top of page" button? This would make…
-
How do i fill in the date gaps?
I have a start date and an end date. How do i have those dates in between appear? (ETLs/Codes)
-
Multiple Event Types on a Calendar Card
Hi all, I've been working on a release and defect calendar card and have encountered some limitations with the current calendar card - I've managed to map all defects onto the card with no problems; however, I want also to include a separate event type in the same calendar for a version release date. Effectively the story…
-
How can I color the bar based on a beasmode not directly shown in the chart?
I am trying to color the 2nd (Appointments) bar based on the ratio (Appointments/Target) However, it does not seem possible via the Color under Chart Properties - Is there any other way?
-
How to get WoW comparison by changing global date filter?
I'm using the comparative gauge chart type. But it only gives me last week vs. 2 weeks ago. If I change the date filter to another month, this comparative gauge chart won't work. Current chart: What if I want to check 2nd week of Jan. vs. 1st week of Jan., the card won't work. last week : 2 weeks ago: How to fix this?