-
Create a cars to show Domo Email Interaction/Engagement
Hi Guys I`m looking to to create an "engagement" report based on Domo Email. We`ve created a number of automated reports that are sent out at periodic times. My theory is that the end users are getting the information that they need from these email, causing logins to decline..... and therefore are the users licenses…
-
Domo card total columns is correct, but rows are incorrect
The total figure of 361,646 is correct, but the totals for each month are incorrect and clearly do not add up to 361,646.
-
Need variable past/future daily date range with ability for user to adjust
I have a number of cards where I need to present daily data with a range of past and future dates. I've found that I can easily fix the date range, and this then still gives users the ability to modify the dates when using the card. This last part is where I am having trouble, as I know I can use a beast mode to create a…
-
Different Date Label on a single chart
I am trying to show a monthly/quarterly trend chart showing actual and forecast numbers. Is there anyway to label the date for actual and forecast differently? For the year of 2020, Jan through June would be labeled a regular date, but July 2020 and forward will be labeled something like July-2020(F) and so on. Thanks Juan
-
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…
-
Filtering on Checkbox "Not In"
Hi there, I've gone through the Filter Cards properties in the Knowledge Base section, and doesn't mention about a "Not In" option. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Slicer%2C_Checkbox%2C_and_Radio_Button_Cards I'm building a Story Dashboard about Transport Carrier…
-
Calculate Average and Standard Deviation with missing dates in time series
When calculating the average usage and standard deviation for a list of parts based over a time series the results are not what is expected. The problem is not having a complete list of dates for each part number. I would need to generate the missing dates for each item number with a value of zero for the equations to work…
-
Changing colors on a treemap
I have a set of server applications which I want to track the status on the dashboard. Each application should have it's own square with a color associating with the status. My data looks like the below: app_name | status | color app1 | ok | 1 app2 | not ok | 3 app3 | warn | 2 The only way I found to create equal sized…
-
Use pfilter to limit data to 50 rows
For an embedded card, we want to limit the used rows for the visualisation to eg 50. We use PFILTERS to filter the data for a specific client, so that data is already filtered. Is there a way to limit the data to the most recent 50 rows? (the card is already sorted by date column)
-
Why I can't drag column to analyzer
When I drag a column named "Created" to x axis, but nothing happens, the column is not applied to x axis. How can I apply columns to x/y axis. And it seems like that all the "Drag column here" are not available. Could you help me?
-
Creating a Distinct Column Name and Showing Last Completed Order
Scenario: There are thousands of customers that are placing orders on a daily basis, which include repeat customers. I am trying to build a card that will: 1) Show the customer's name once on my card 2) Show the last time they placed an order. Is there a way to make the 'CustomerName' column a unique value without creating…
-
Does anyone know which chart-type has been used to make these cards in the Domo COVID dashboard?
Does anyone know which chart-type has been used to make these cards in the Domo COVID dashboard? (See screenshot attached) I'm especially curious how the heading is center left, and changes from prior days are shown with arrows
-
Is it possible to hide a transposed column in Mega Table?
-
Data Aggregation issue in the Beast Mode Calculation while using Sub-Total and Header Row.
While we use the CASE statements the Aggregation in DOMO first performs SUM and then looks at the condition inside the CASE statement. This means that the following two conditions will provide similar results on the row level, but when the data is aggregated the 2nd condition will only look at the bigger value post SUM()…
-
Escalation levels
If it is possible i need to use a checkbox selector to show an esccalation level and the problem im having is that i need it to select multiple at once instead of one by one For example the values are 1 to 5 and when 1 is selected i need all the bigger numbers selected to or if 3 is selected i need 3,4 and 5 selected Is…
-
To Date Period over Period Cards - Flawed due to leap year?
When using the "to Date" cards, with a daily date grain, I'm noticing they show variance spikes due to shifting the dates 1 day, regardless of selecting YoY or 52 weeks as the comparison to, and I think this is due to the Leap Year. Another way to explain it is that the "align by day of week" option is aligning Mondays for…
-
Chart Type
Hi, I am trying to build a card that mimics an Excel report (See attached). User could select 1 and (only 1) building number from a Filter, and the data would populate accordingly. What is the right chart type to achieve this? TIA
-
Filter card: selecting more than one item
Hi, I am using a filter card that affects another card. Now the filter card is set up in a way that I am allowed only to pick one item on it. How do I adjust the filter card, such that I can select several items (ex: several teams, instead of one only)?
-
Show data of last 10 weeks
Hi, I have a dataset that shows data year to date. And I am using an HTML card to get a table view. Is there a filter or setting that can be set, to always show the last 10 weeks of data as time goes by? I have week column and to not overload the table, I always only want the last 10 weeks data.
-
building a date time card for a specific timezone
Hi All, Well im trying to have a date-time card so that it is like a clock visible on domo dashboard. So there are few issues that i am facing 1. the date and time are required for different time zone . i want to show central European summer time zone (utc+2) 2. i am using the NOW() function , and i want the format in it a…
-
Remove sum of row in card
Hi, I am building different cards (HTML, Filter) and everytime there is a sum of rows in the left top of the card. But the number doesn't add any value to the overview. Here is one example, and I would like to get rid of this information. (See example)
-
Problem with Shape map
Hi ! I'm trying to build a map showing the density in French train stations by zones. However, once I add the svg file I can't see anything. Do you know why ? Thank you in advance for your assistance ! Flo
-
How to remove the week that is become zero when I drill path from month to weeks?
I am new in DOMO, I am trying to remove the Week 18 in my card when I drill path from Month of May to Weeks. Either I remove it or just give me the week 18 data which it show when I select the Month of April.
-
How to read users selected date interval in the beast mode?
Hi Dojo Masters, I have a card that allows you to select X period of daily stock, however, we want to allow users to select whatever period they want. It could be 7 days, 30 days, 171 days and I need to be able to get the "period in days" selected so we can then in beast mode do calculation of similar sorts: sum(items) /…
-
Changing a Column from Measure to Dimension
Hello all, I am seeing if there is a way I can convert a column named 'isActive' from a measure to a dimension. Currently the values show as '0' or '1' as a measure, but I want this column to be under the dimension field and display as 'True' or 'False.' I am trying to avoid a beast mode calculation because the dataset the…
-
Domo Stories: Passing page filters through when linking to another card
Does anyone know if it is possible to pass page level filters through when your interaction with a card on a dashboard is to link to another card? From I can tell it does not look like it is possible. I also have visual bugs when using a slider filter and a checkbox filter concurrently has anyone else seen this?
-
pivot table column percentages
Is there anyway to display percentages in pivot tables, in terms of cell count vs total column count? I have attached an example. In each cell with 'XX.XX%' I want to display the percentage of the count for that cell divided by the grand total for that month. E.G. the percentage cell for "2020-Apr, In SLA" should show…
-
Is there a way in Domo to plot date and time against a *fixed and gapless* x-axis?
Is there a way in Domo to plot date and time against a *fixed and gapless* x-axis? When we plot by hour, we want all 24 hours, not just any that are present in our DataSet. For the gaps, we would like a 0. I set up a simple dummy DataSet, and can't find a way to make this work. I found this thread from four years ago:…
-
Image into table card redirect
Hi everyone, I've been searching the community and support knowledge and no luck so far, so I am forced to request help here, hope you can help me. I have a table (not HTML, just normal table) card in my dashboard with this structure showing my instagram posts Likes | XX Image | media(beastmode) Comments | YY I use a…
-
Frequency Over Time Chart Type
Hi, does anyone know of a way to create a chart that looks like the attached? Custom chart? I want to use a chart like this to represent the # of tech support incidents getting created over time. I know a line chart could work. I like how this chart categorizes them in bands. 0-10, 10-100, 100-1000, etc.