-
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.
-
Toggle series in bar chart
Hi, I have a bar chart that has a goal as the y axis and then a current total as the series (as well as the difference between goal and total. We also have another field in the data that has a different calculation of the total. I was wondering if it is possible to have a card on the dashboard that allows us to toggle…
-
Change default "No data in filtered range domo" message
Hi All, Is there a method for customising the 'no data in filtered range' text? In some cases having 0 is a good thing so I want that to be reflected All support appreciated Kind regards,
-
Roll up rows in table chart with similar fields
I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times. Thanks
-
Failed to parse text - Connector error
Hi All, I'm appending a dataset via a Smartsheet connector and the user has entered a string inside a date column. I'm now getting this error: How do I filter/replace these entries from within the connector? Kind regards,
-
Dropdown selector filter card not displaying all values
It's not that many, not sure why there not all populating. Thanks.
-
Restricting Access to card based on Criteria
Hello, I was wondering if there is the capability to restrict access to parts of a card based upon who is viewing it. For instance, could I share a card with a certain individual with one specific filter that is not able to be changed? Thank you for your help.