-
Multi-Value Gauge Showing 0 Change
I'm working with a dataset that is organized by date and account name and for each date and account name, there is a total number of subscribers. I'm trying to show the total number of subscribers over all accounts for yesterday and the value change from the day before. The value for yesterday is there but the value change…
-
Dynamic dates in dashboards
Hello, I am trying to include the date up to which data is included in visualizations in a dashboard but I am having trouble finding the function in smart text. All I can find is the timestamp in which the dataset powering the cards was last updated. Would greatly appreciate the help!
-
HTML to color cell green or red
Hi, I am using a pivot table and I am trying to color the cell either red or green if its greater than the goal %. I just need help with the HTML on how I would do that. Would I write it in a beastmode? The following code I have is as followed. CONCAT(CASE WHEN ((SUM(Empty Miles) / SUM(Total Miles)) > AVG(Goal)) THEN…
-
How to add an empty row in my table?
Hello! Is there a way to add an empty row in the table? Below is an example of the row names: Metric 1 (last year) Metric 2 (this year) (empty row to separate) Metric 3 (last year) Metric 4 (this year) —I only found this video which is not what I am looking for. I am just looking for a way to separate different section…
-
Indicator in Pivot Table
Hi, Is there a way to add an indicator, like you can in excel, to a table in DOMO? (For example, Like the green and red dots in the excel picture below)
-
Way to Have Static Average Compared to Dynamic Aggregation
I am looking to show the Utilization rate for customers over a period of time. I have a dataset that has all customer utilization data and want to be able to show how that stacks up to the whole company average for that period. My goal is to have the utilization value be the aggregated utilization value that can be…
-
How to add a filter - match values - contains to a dashboard?
Hello! I have a card with a word cloud containing a filter - match values - contains, where I can type a keyword and filter all the words that have this keyword. I would like to have the same filter functionality in my dashboard. How can I add this type of filter to a dashboard? I don't see this option in the filter chart…
-
Is it possible to pull in animated images (GIF) to a table card?
I have a card where I pull in images. I have links to the images in a google sheet which I connected to Domo. Most images are being pulled in. I noticed that the ones not being pulled in are animated GIFs. Can these be pulled in at all? Here is the HTML I'm using: CONCAT( '<img alt="img"…
-
How Can I Reassign Scheduled Reports In Bulk for Former Employee
We've had an employee leave and they had some scheduled reports on some cards. I've tried looking around but haven't yet found a way to reassign the scheduled reports in bulk. Has anyone found a way to do this?
-
Use year selected from card filter
Hi, I'm using a dropdown list that selects year values, I want to use the value selected to created a calculation. Is it possible to use the year selected? For example if in my dropdown list I selected year 2023, then use this value to do a year previous revenues sum thanks
-
Beast mode help with div codes
I have a existing beast mode - CASE WHEN `Actual` >= `Goal` THEN '<div style="text-align:center"><img height="30px" src="https://—-my.sharepoint.com/:i:/g/personal/ABC/EfUFaTLrpHdIvaH4PFDHXIMB0_xo9cIMKVAvSca9bxWQ8A?e=f8YHjw"></div>' Else '<div style="text-align:center"><img height="30px"…
-
Bar Chart Beastmode
Hi, This problem has been given me issues for awhile now and I am completely lost. I have a bar chart that uses a specific beast mode. CASE WHEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)- avg(DATAllinAvgCPL)) > 0 THEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)-avg(DATAllinAvgCPL)) Else 0 END The issues arises on the bar…
-
Has anyone had issues with Microsoft office Connector
Hi - Just curious if this is affecting others or if there is a work around. Currently when we pull cards into Word, we cannot resize or move the card around. It is stuck in the content block. Seems to work fine in powerpoint Is anyone able to put a custom card in an office document and run a filter? We are being told we…
-
Is there a way to use DropDown Cards to display text or tables?
Hello! I am trying to allow users to select a dropdown for a data dictionary. The idea is to allow users to select the terms they want to understand, and for a description to populate below. For Example: When the user selects 'Cost per Session' from the dropdown, I want the card to display the definition directly below…
-
Radio button Filter
Hi, Is there a way to make the radio button filter always select the current date by default? Or would using a drop down filter be better for the user so that it displays the current days data without the user having to click anything.
-
How to disable interaction from a card without disabling general options (like scroll bar)
Hi Everyone, I have a "Table" type card on a dashboard and I don't want interaction from that card. When I do "Change Interaction" —> "Disable Card interaction" it also disables the general properties, functionalities & options for e.g., I'm no more able to see "Expand", "Card options" or even scroll the card! Is there a…
-
Make the Flex Table the GOAT Chart it can be
Update: I meant to post this in the ideas exchange. It's there now, so please upvote it if you agree 😀 I feel like the Flex Table has the potential to be the Domo GOAT chart, but it's so locked down, I end up never being able to use it. Here are my suggestions to unlock its potential: Allow for multiple series, so you can…
-
Connecting Microsoft forms data into domo.
I have a Microsoft form. I usually download the result of the MS forms in excel form and then start working on it by uploading it to domo via file connector. If it is possible to directly have the Microsoft form data from a particular form available in domo. I have a limitation that I cannot give access to all users for…
-
Bring Null Values to the top of filter lists
A recent changed moved the 'blank' (null or empty string) values in filter drop downs to the bottom of the list instead of the top. This is now makes it quite difficult to find to exclude those values in cards. I would like to either have that moved back to the top or to have a secret keyword to be able to search for null…
-
Can I show positive (instead of negative) numbers in red?
I have a table that shows YoY comps as a percentage for four different metrics. For three of the metrics, negative is bad and positive is good. For the fourth metric, negative is good and positive is bad. I found the option to "Show Negative Numbers in Red", which works correctly for three of the rows but not the fourth.…
-
Keep Filters from one dashboard to another
Hi all, I created a main dasboard with dates and orders. In the main dashboar the info is aggregated, but I created a page to see order per order whats happened. But when I "jump" from main dashboard to the paig the filters are reseted, is it possible to keep these filters to another pages? Thanks Eduard
-
Alerts are not being triggered even thought the condition is met
I created some alerts based on a summary number, the Rules are being met but the status in not triggered I don't know what I'm doing wrong. In this example: Rule Summary Number: Shipments Is greater than or equal to (>=) 1, I have tried also greater than 0. If you see even in the card is says summary number is currently…
-
create a card to display a number ranking
can anyone point me in the right direction on how to create a card with a number ranking that will auto update? we give the sales people a score based on their activities. the one card will put them in order based off their activity score total. how do I create a separate card to just populate their Activity Score Rank?…
-
I am seeing the shield icon on my dashboard, how can I hide this?
-
Smart Text - Show Actual Year Value, Rather Than Date Range
I am working on developing an annual report for our department. I wanted to find out how you go about showing the actual year value, rather than the date range value, like "Previous Year", on the cards. In this example, I would rather show the year, "2022", rather than "Previous Year".
-
How can use Domos filter to remove response rates less than 15%?
Hello, I have a data set containing all response ever recorded for several different surveys. I would like to build a dashboard that allows the user to select a question and see the response rates for that question (accomplished this by creating a variable and using case statements). The backend > grouped rows by survey to…
-
Export to Excel: all available rows, regardless of "show only x rows"
Applicable especially to tables when to save space developers choose to show only a limited number of rows. However, it might be benefic to have the option to show all rows for exported files.
-
How Do I achieve below output based on data provided?
I want to transpose the below input format into expected output as below. Please suggest. Input : Month SEGMENT SITE Values Oct-23 Segment1 Site1 1000 Oct-23 Segment2 Site2 984 Oct-23 Segment3 Site3 234 Nov-23 Segment1 Site1 1100 Nov-23 Segment2 Site2 228 Nov-23 Segment3 Site3 2200 Output Oct-23 Nov-23 SEGMENT Segment1…
-
Difference of % of column total
I have two column where I use % of column total to calculate the Share of Markets now I wish to get the difference of the percentages for example 31.91% - 31.10% will give me 0.81% difference. I just cant simply do that, any Idea how to implement this?
-
Does anybody mind sharing what their marketing campaign dashboard looks like?