-
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.
-
Current Year, Prior Year, and Budget on Same Card
Hello, I'm trying to build a car with Budget, Current Year Actuals, and Prior Year Actuals. I created the view I wanted (see attachment), however, I had to use BeastMode. I can't filter easily with the way I had to write the BeastMode. PROBLEM: Create a card with CY Actuals, PY Actuals, and Budget on one card with the…
-
Percent Change Month to Month
Hey everyone! Somewhat new to Domo and having trouble setting up a Percent Change formula for Month to Month. Below is the screen shot of the current card I am using. The claim count on the Y axis is already using COUNT(DISTINCT) but I am wanting to add more to the beastmode. For example Apr is 127 and May is 133 I am…
-
Can you create a Summary Number that shows a subtotal percentage?
Good afternoon, Is there a way to create a Summary Number that shows what percentage a subtotal represents? For example, if I have a table that is showing 10 rows out of 1,500 rows, and those 10 rows equal 20% of my sales for the month, how can I create a Summary Number that shows 20%? THanks!
-
WMS option for lat/long map background
I have a number of data points that are being displayed on a Lat/Long map but there isn't a lot of context to understand where they occur due to their disparate spatial occurrences and that zooming in to them removes all context of where they are. Is it possible to overlap the Lat/Long points over a WMS or other map tile…
-
Hide Appendix in Dashboard
Hi guys, is there a way to collapse the appendix of a dashboard, like in normal view? If so, how can I do it? Thanks in advance.
-
Pivot Table Value Columns
Hello All, New to Domo, but diving right in. I am working on a Pivot table and having trouble with formatting. I have multiple VALUES to display and by default it is laying these out in a columnar way under the dates I have setup (see attached). This makes it difficult to read and I would prefer they stack as ROWS instead.…
-
Hiding Page-Level Filter For All Users
Hi, We sometimes have several (9+) different data sets on a page.There are certain filters, like beast mode filters, that I would like to hide from all end users to avoid confusion and filter-overload. Is there any way to do this? Thank you!
-
Table Card not showing all columns
Hello everyone, I am building a simple (at least I thought) table card for my dashboard. The table only contains four columns, but when I save it, the card on the dashboard only shows three of them. I have played with editing the column width and the font size, but nothing helps. The card keeps showing only three columns.…
-
Adding a right scale to line graph and series not matching correctly
So I have a line graph with 4 series. One of the series has valuse between 14,000-25,000 and the other three all are 0-10,000. When I go to add the right scale values, the series are not matching to the correct value scale so it is hiding the data. I have attached two photos, 1 photo being the default value scale and the…
-
beast mode - counting text
I have a survey where the participants are able to select multiple options. For example: Why did you decide to not enrol? Answers: I cannot currently afford it I am not interested I cannot make the time Other When I try to visualise this, it does not group single answers with cases where there are multiple answer choices…
-
How to have multiple series for a trellis chart
I am trying to add multiple series to my trellis chart. I can add the second category with just the first Y-value, but when I add another series Category 2 dissapears and I cannot add a Category 2 unless I remove the additional series. This article shows a screenshot of a sample trellis chart that has several series…
-
Can we change order of columns in Pivot Table?
I want to bring values first and Columns after. I can't seem to do that.
-
Rearrange values on X axis
Hi, I am creating a view where I want to observe volumes base on a time of the day bucket. So have a variable: time_of_the day that I created using a timestamp variable. When I put the variable on the x axis, it starts with 10-11 AM first and and with the earliest value, 9-10 AM. I would like to organize the values in a…
-
How to fix the line to a particular filter selection element
Hello, I have a grouped bar + line card. there is also another Filter card that allows user to select inventory, gross sales, net sales.each of these needs to be shown as a grouped bar and inventory to be shown as line. This works fine when all of the filter elements are selected, but if user selects say gross sales and…