-
Step chart showing rogue values across multiple days
I'm charting event based data using a step line (chart). If looking at a week of data, the chart is filling in the line from midnight (start of the day) to the first recorded data point on that day. I'd prefer it to continue the value from the prior day through until the event. For example, on Wednesday the last value of…
-
Nested Filters
Hi all, I’ve run into a puzzle on a dashboard and am wondering if you have advice. (See screenshot for dummy data to illustrate the issue). All charts in the dashboard are filtered by the “State” column. Initially, we were going to just have the user select their “State” in a filter. The issue is that “State” is kind of a…
-
Sumo Table - turning column values into percentages of the whole?
Good afternoon, I'm working with my first Sumo Table and have 3 columns of values as well as a 4th column with the total of the other three columns. Is there a way to convert the totals in those first three columns into percentages of that fourth column? Example below. Thank you! -Joe
-
Dynamic "Series" in a line chart
Hi Folks, Let me try to explain this as clear as I can since the subject title is sort of not clear. For context, my role is card builder within my organization. I am putting together a dashboard that is related to SEM Competitive insights using google auction insights data. This is my default view of my line chart. Here I…
-
Number Format in a Table
I have a table that shows different number formatting within the same column. Is there a way to keep the different formatting? Example: Row 1: Percentage Row 2: Whole Number Row 3: Number with two decimal points I am not seeing any articles on this.
-
How can I rearrange the order of the cards in the Appendix of a Domo Stories dashboard?
When I edit the dashboard and try to move a card in the Appendix of a stories dashboard, it only shows a screen with "Move to appendix" and it doesn't let me rearrange the order of the cards. How can I rearrange the order of the cards in the Appendix?
-
Dynamic texbox value update based on date range
Hi I have a Domo dashboard that utilized a few dynamic textboxes with a summary number and change %. Right now, my table only has current month and same month prior year data (update on the back end) to utilize the Dynamic textbox's features for first and last values. How can I use this chart or any other chart type to…
-
Data with more 5000 row not updating correctly
Hi, I have more than 5000 rows of SQL data that will not connect in Sales Force. How can I make those it make it work. I'm fairly new to DOMO. Thank you.
-
design view in slideshow
Dear all, can anyone suggest if I can publish Design View dashboard as slideshow to be shown same way (as a collection of cards on each screen rotation)? I'd like to have it constantly displayed in our office, but they way it been displayed now (a single card per screen) seems to be a bit outdated, once we have an awsome…
-
Create bar chart summing multiple columns/categories
I am new to Domo. So please bear with me. If I have a dataset such as this. I would like to end up with a bar chart such as the one I have (badly) drawn below. Where the "TRUE" values are counted along the y-axis. My problem is that I am unable to figure out a way to get three columns to show on the x-axis. (I know that…
-
Gauge - Set Maximum as Target Value
I am working on a Filled Gauge, I want the maximum to be dynamic and reflect just the target value. Any ideas on how to accomplish this?
-
Load default Filters whenever we refresh the Page
Hi All, I have a dashboard with default filters set. When I add few more filters or choose an option from a default filter everything is fine. But when I visit the dashboard after refreshing the page, I see all the filters I had set last time. But I want dashboard to reset to the default filter every time I refresh the…
-
Date selector presets not working in pages
All of a sudden, the date selector presets selections ("This month", "Last month", etc) are not working in all my pages. The calendar date selection still works. Anyone else have similar issues? Is this a bug in the new Domo update? Thanks in advance. Bharath.
-
Date Filter Calculated Field
I want to create a filter card to be applied over the Domo Page, where the filter card shows 2 checkboxes/radio-buttons with values: 'Last 7 Days' and Lat 30 Days' On selecting any of those boxes/buttons, the data for the rest of the page should get filtered accordingly. (Selecting 'Last 7 Days' check box should show only…
-
How to add date to the scale marker to indicate current date
I Have a scatter chart holding the Month in X scale and amount in Y scale.i want to add a scale marker which indicates the Current date . The option i have is to select "Line" , "Manual" and Value, I am not seeing the scale marker moving to the current date .can you please guide what is the format i have to enter to set…
-
Show labels on pie chart even if it's too small
I am using a pie chart. I have 2 slices. One is 90% and the other one 10%. But the 10% one is too small to show the label. Is there a way to force this? As I don't mind it overlapping the 90% chart as there is enough room to show the label there.
-
Dynamic date in dashboard textbox
Hi, I need some help in creating a dynamic date in a dashboard text box. i'm looking for the date to display yesterdays date. Also can this dynamic date be used for a summary number in a text box? Any guidance would be greatly appreciated.
-
Beast Mode - forEach
Hello. So I have this dataset where I get item, work order and the quantities both planned and actual. This is to calculate manufacturing absorption %. Is it possible, via beast mode, to tell the function that for each distinct work order, it sums its quantity and displays it as the total of Actual production? If I do an…
-
How do I create this simple pivot table?
Looks very basic, how do I do this in Domo, TY.
-
Use Gauge : Target + comparison
Hi all, I am using the Gauge to show my sales results. But I want to show both a target point and compare it to last month. Normally the line from previous month is the targetpoint but I want to adjust this. Is this in any way possible? I also looked at the Comparative Fill Gauge but doesn't seem like the way to go. Thanks…
-
How to use Line + Stacked Bar Chart
Hi Dojos, Looking for some advice on how to use a Line + Stacked Bar Chart in a specific way. Currently my chart looks like this: I want to add a line which indicates the number of clients by region. My dataset is structured as follows (only relevant columns shown): "Operational Places" is grouped by "ACPR Name" and…
-
Add date filter 'with presets' to page
I want to add/show the date filter with presets (as is available on card builders) on the page level - on the filter section. I know that custom filters can be added selecting the date field dimension and then filtering out the required dates and other option is to build a date filter card and add it to the page. But what…
-
Need to add a date axis to a flex table
How can I visually add the dates to the X axis on this flex table?
-
Display Photo based on the selection of a name in Filter
Hello All, I am building a POC for a healthcare case management and I want to know how to display a Patient Photo based on the selection of a Patient Name from the fitler. In Tableau or Qlik, I used to load a file with the Name and Location (Path to the photos) and I can use some OOTB function that will display the picture…
-
Funnel Chart Summary total to top of chart?
Hey team, i'm hoping someone can help me here; i created a Parameter allow me to create a lead source funnel based on a filtered report. The filtered report gives me a total number of 861 leads (represented by the top left summary number). The parameter created basically states "IF this THEN category"; which gives me 3…
-
Concatenate values to http: to make a link
I have a dimension called URL which multiple values which look something like: //en.wikipedia.org/wiki/Lake I want to take this value and concatenate Https: to it so it will show: Https://en.wikipedia.org/wiki/Lake and create a hyperlink to the web page. I've tried this: CONCAT('<a…
-
Drilldown filters on different chart types
I am adding drilldowns to a dozen or so cards on a page, all built from the same dataset. Most have filtered as expected -- if I click on a category it drills down with that category set as a filter. But one will not -- If I click on a category, it goes to the drilldown view, but does not filter. If I click on a datapoint,…
-
Move page to a sub-page
I am unable to move a page to a sub-page of another dashboard. This knowledge article may be out of date because I have a different experience on the admin>pages section. There is no checkbox by the page and no "move page" options I can find. There is a side pane with the list of pages and then a window with users and…
-
How to adjust size of the value in the single value card?
Hi, I am using single value cards and would like to adjust the size of the value (font size) inside the card (not of the card) but I'm struggling with that. I know for other cards you can adjust that under General, but there is no option for that in a single value card.
-
Beast mode - Age buckets / grouping
Hello everyone, I am having trouble with a beast mode grouping outstanding records by age bucket. I am looking to calculate the number of days a record has open and then place the record within a range. Below you will find my existing beast mode which is an "Invalid formula". If someone could assist with the formula…