-
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?
-
Checkbox Selector not showing all values?
Good morning, While trying to create a Checkbox Selector to use as a filter, I've run into an issue where the card is only showing some values instead of them all. It's not even a massive data set; it's 15 values. However, when creating the card I see the dreaded "Warning: Not all data is shown" message (14 of the 15 are…
-
Magic ETL Dynamic Pivot
Hi All, Is this the only solution for dynamic pivoting? : https://domo-support.domo.com/s/article/360042923454?language=en_US Hoping for a simpler solution. Kind regards,
-
Beast Mode Calculation
Hello - I'm trying to calculate a Beast Mode so that it only shows the stats for completions if the date is not greater than today. After checking out some questions and responses in the community I tried the below, but it doesn't work 😕 Clearly I'm doing something wrong and would appreciate some guidance. CASE WHEN…
-
Updating a Webform from magic etl?
Is there a way to insert a new row into an existing webform from within an magic etl?
-
Heatmap in 30 Minute Intervals
I've created a heatmap based on the timestamp of records with the day of week on the Category 1 axis and the hour of day on the Category 2 axis. However, the business is asking for a version that breaks things down into 30 minute intervals. I'm currently using the HOUR function on the timestamp to extract the hour, but I'm…
-
Single Value Card - No numeric abbreviations
Is there a way to turn off abbreviations of numbers in Single Value card? I have a card that has the value of 1023. It shows as 1.02K (I have it set to 2 decimal places). I can't find anywhere to tell Domo not to use the abbreviation on this card. (ether in the card settings or the value display settings).
-
PowerPoint Plugin
How can I get the current filter on the Domo dashboard to apply when using the PowerPoint plugin? I just downloaded the PowerPoint plugin and the dashboard/page I need have filters for different clients. I filter the page in Domo with just the client I need but, when I go back to the PowerPoint plugin to download the cards…
-
PowerPoint Plugin
Hello, I have downloaded and installed the PowerPoint Plugin. I find that I am unable to connect to my Domo domain. After I add my company's domain via the Connect to Domo tool I click the Authenticate button and nothing happens, it just spins. I am a privileged user. Any thoughts?
-
US$ showing on Summary Total for Card
I've created a pie chart card in DOMO with a summary number showing the total amount. When I view the card, I only see $ with the amount, however when another user views the card, he is seeing US$ with the amount. He only started seeing the US$ recently. Is there a way to change this back to just $ ?
-
build a project timeline
Say we have data that looks like this Project, start date, end date, Total hours Task A, Jan 2023, June 2023, 50 Task B, Feb 2023, July 2023, 100 If we assume a smooth work schedule where work to be done in a month for a project is total hrs/number of months. How can i lay this out, so we know how many hours of work needs…
-
How to display data labels for data points outside limits in a process chart
-
Can I change the font size?
I am having trouble changing the font size on the legend of a generated report. Is there a way to do this? Do I need to do it in the card? Or do I have to use the PDF editor?
-
Card filtering in analyzer
Hi, I have a table with null values in some columns. I want to show only the null values. When I filter in the null values in analyzer nothing shows up. Beast mode also doesn't work. Any ideas?
-
Is there a way to force a column header to be blank?
When formatting a column "Data Label" in a table chart from the formatting drop down where you would format justification etc. - you are able to override the column name with more plain english. However, in some instances, I've wanted to override the column name with nothing, i.e. have a blank column header, especially if…
-
Filter is removing nulls plus specified value
Hi All, Question: I am using a Magic ETL filter with: level = 2 status = 'Blue' The filter is removing 'Null' values in the status field as well as the Blues. What's the potential cause here? Context: Both fields are string dtypes (abc) I've tried: level = 2 AND status <> blue -- in one formula status NOT IN('Blue')…
-
How do I build a percent completion pie chart over time?
I'm trying to building a pie chart that shows the percentage completion for a survey that never closes. Respondents are both added and surveys are completed over time. Some of our surveys have been running for years. Any way you do this is flawed, but we feel the best way to do this is to add up the number of respondents…
-
Can you fill null pivot table cells with the previous non null value?
I'm building a pivot table with a running total. The running total is working well, but the data is leaving some null cells. I would like to fill those null cells with the last previous non null value, is this possible? It would make the table much easier to read and it would just look better. Here is an example of what I…
-
Glitch in bar charts- anyone else experiencing replicated categories?
Not sure if this is something I can fix or if it's a glitch. Recently, I am struggling with making bar charts because the axis categories are repeating multiple times rather than showing up once on the axis. I can't figure out how to get them to display properly. They do display correctly if I turn into a table so it's not…
-
How can I show % change summary # for Period over Period chart?
We have a lot of cards tracking current year vs prior and the period over period chart type works for the visualization, but is there a way to get the summary number to show the % change period over period? From what I can tell, if I set the date range to current period and then compare to prior period that limits my…
-
How to Include Subtotal Percent in Pivot Table?
When in the analyzer, I selected a pivot table Next, Chart Properties --> Subtotals --> check the box for "Show Subtotal Rows" This gives me the subtotal for each subcategory. Is there a way I can also show the percent total for each subcategory?
-
getting the %_name on donut chart slices
Can somebody please, please, please tell me what I am doing wrong with this donut chart??? I want the chart to show the name of the value followed by its count. Like the donut shows in this instruction - https://domo-support.domo.com/s/article/360043429693?language=en_US I can get the count in with %_value... but for the…
-
How do I drill down from one card to a different card that is based on a different dataset?
I would like to create a drill-down from once card to another existing card that is based on a different dataset. How do I make this happen.