-
How to create variables in beast mode?
How to create variables in beast mode? even do not find the training video. thank you very much
-
Possibility to tag alerts
It might be useful to have the possibility of tagging alerts, as is possible for Datasets and Dataflows
-
Calculation of previous dated values
I am trying to calculate trailing period (previous period) calc. I have year(variable selector), month(dropdown selector chart using column from table) If i select Year = 2024 and Month = Feb, I should get the data for 2024-JAN. Tried this formula but failing to get the correct figure. RecordDate(date format col) is…
-
can I change the pivot table chart like this? help please
Here is my design in DOMO. below is what I want. the difference is at value area, I want the figures of month (Jan, Feb, Mar…) on the left, then % of month (Jan, Feb, Mar…) on the right. that is to say, I do not want the 1st column at value area in Number, the 2nd column at value area in %, I do not want this because it is…
-
May Community Forum Highlights
Hello Domo Community! It's June! ☀️ Which means it's time to post the May Community Forums highlights. Follow the discussion, ideas, and user links to contribute to May's hot content 🔥 Leaderboard Top 3 We love seeing the monthly competition. @david_cunningham knocked @GrantSmith and @ColemenWilson out of the top spot for…
-
Multi value comparison
Hi, I am configuring a multi value comparison card. I have Sales column which is being configured in Gauge Value. In Comparison Value, I want to input the value of Sales Column itself but of previous year. I want this comparison to be dynamic because on my dashboard I have dropdown filter (Year, Month, Quarter). So if I…
-
Drilldown tables on cards displaying info from multiple dates
I have a card that uses variables to display info from different date ranges - some columns show metrics for a custom date range (defined by the variables) and other columns show metrics for the current month. When I add drilldown tables the date filters seem to get confused - it keeps picking the current day, even though…
-
GROUP_CONCAT function in Dataset View vs MySQL Dataflow
I have created a MySQL Dataflow where I was able to successfully use the GROUP_CONCAT function. It is preferred that I use a Dataset View in this circumstance since the underlying data is coming from AppDB and therefore updates every 15 minutes if there is new data. I have copied and pasted the exact query that is…
-
Dynamic data comparison
Hi, I want to perform QTD, YTD without using Domo inbuilt features dynamically. Like, I will have a dropdown for Year using dropdown chart using the Year column from dataset. And variable selector for QTD, YTD. User may select any of the variable selector and any one year from the dropdown. Example: Variable Selector : QTD…
-
Is there a way I can log in as a user?
Many of the softwares I manage allow admins to log in as users to test them, troubleshoot, see what they see, etc. Is there an option in Domo to do this? Specifically, I have a page with multiple PDP'd datasets. When I select the policy at the top, it doesn't filter all the datasets, only the one that informs the first…
-
Identifying what data came from which connector on a card.
Hello all, and thank you for any help. I have my magic ETL flow built out so a report is pulling information from two different connectors. There does not seem to be a batch ID or file path as options for me to select, which I thought would be the method to identify which system they pull from. Does anyone know how to…
-
Median Value in Total Column
Hey all I'm creating a heatmap visual that compares our engineers' ticket cycle time against projects and uses the median value. When I add a total column to the graphic, the column sums the values above instead of calculating the median across all projects. Can the visual be adjusted to calculate an overall "Median"? ref:…
-
Problem with Workflow
This is my first work flow project and I ran in to some problem while I try to create an alert on cards, and when I try yo attach the action, it shows me an error message
-
Filtering Against "Potential" Field Values
I'm trying to create a dashboard filter view for a set of field values where some values are not in the current data set but could be in time. Right now, it seems I can only filter based on available data and not able to set up a filter for potential field values. Is there any simple way to establish these potential values…
-
Having both horizontal and verticle marker on a Line Chart
Hi guys, As in the title, is there any way to add two reference lines, one verticle and one horizontal in a DOMO line chart? The solution can be DDX or the default line chart. From that, is there any way to add the third horizontal… if there are ways… Thanks, Long
-
Improved filter interactions
As of right now the domo filter bar (screenshot below) allows you to natively filter a date through the menu to the right. Said filter,however, only affects cards within a dashboard and does not affect whatever dimension you are selecting from the bar itself. In the screenshot you can see a City dimension. That dimension…
-
how can i design this kind of chart in DOMO?
x axis is the month left Y axis is the stacked bars. each stacked bar is 100%. blue one is for normal order. orange one is for sampling order. they are both in %. they are the percentage each order type takes and are calculated based on the corresponding order quantity of each type. right Y axis is the lines. blue line is…
-
Display state selected
Hi, I have a map card which has the values populated for all states. I would like to display the selected state name in a text box. However, I noticed, when no state is selected, the text box displays the state name which is in the first row of the data which is misleading. It should either be blank or print some message.…
-
why doesn't my pivot table chart show % when I select show value as % of parent column?
Your help is really in need! pivot table chart For values 发货单数，when I select show value as % of parent column, DOMO doesn't show %, why?
-
Displaying 1 to many records in a table
I have created a custom app for my users to be able to add notes to Invoices that are in collections. The relationship is 1 Invoice to many notes. Initially, my plan was to display the Invoice details in a table card ( Customer, Invoice #, Contact, Invoice Date, Invoiced Amount, Total Due, etc.) and the note data would…
-
Using Sum Distinct in Domobrick query
Hi, How would you go about fixing this error? When I remove Sum(Distinct) it works but I just want to add up the distinct values. Am I writing this wrong? The column name is called TotalProgress.
-
Count transactions AND sum quantity on specific transactions by type
I have a card that counts the transactions type by month. Some of the transactions have a quantity so I need to sum the quantity instead of just counting that transaction one time. I'm not quite sure how to go about that. I need to be able to say if it is this type of transaction then sum the quantity otherwise count the…
-
Can you import multiple tabs in an excel document using the email connector?
I have a file/data set that is updated weekly by using an email connector. Is there a way the file can have multiple tabs at the bottom and have all tabs imported?
-
Sorting Items in a Checkbox Selector filter
I have a Checkbox Selector filter that has fiscal weeks for a client to choose from. It currently looks like this: How can I get the weeks to appear in order left-to-right instead of vertically?
-
SFTP server connection error
Has anyone else received this error that Domo is ready, but could not connect to a server? Our IT partners said there are no server issues from the third party system we're connecting to. This connection has been set and running for several months, but started displaying this error 3 days ago and not uploading new data.
-
Beastmode Timediff Errors
Hi all, using the following to calculate time differences between requested and actual drop off times: TIME_TO_SEC(TIMEDIFF(Actual Drop-off Time,Requested Drop-off Time)) / 60 Seems like the math isn't panning out (first column should be ~25 in the time difference column but instead is showing 1415.80). Haven't used the…
-
Add Card in Mobile Layout and Hide in desktop layout
Curranty we can add cards in desktop layout which we can hide in mobile layout as it cannot be viewed in small screen. Similarly If we can add some cards specific to mobile view which can be hided from desktop view.
-
Formatting for Quick Filter Values
I'd like to be able to apply different formatting to the values in a Quick Filter list, just like I can change them in the visualization. Example use case: my report users are in Europe, so they use date format MM/DD/YYYY. The dataset date values are in DD/MM/YYYY. I can easily update this in a visualization, but the Quick…
-
Disabling email notifications for users in a certain group?
Is this possible? What options do we have to restrict emails that get sent when sharing dashboards / cards or alternatively can we setup special rules to restrict which groups can share and be shared to?
-
How to edit the bottom chart to look like the top chart?
How do i edit the bottom chart to look like the above chart? I need to make it tall and show the x axis.