-
How to subtract sales tax from certain rows for sales revenue dashboard?
I'm not sure of the best way to go about solving this, so I'll do my best to describe my issue below. Any assistance would be appreciated. I'm trying to create a pie chart showing total sales YTD and breaking it down by rep. I have it mostly made but my numbers are a little high. I looked at my dataset and my TotalPrice…
-
Default Setting to Pin Dashboards Side Panel for All Users?
It's not entirely intuitive that it exists for new users, so I'd like it pinned by default for all users. If this is possible, could someone direct me to the setting for it please?
-
How to use value from beast mode as a value for all?
Hi, I am trying to figure out how to best solve my issue. I currently have a calculation in my dataflow attached to a certain account code for our organization. That value changes daily but I need to use that value to divide the rest of our account codes by so I can't just add a constant value. Because it is attached to…
-
Projected monthly total based on current progress in current month
Is there a way to project the month-end value based on the current month's progress in a bar chart? So if there are 10 days of data totaling 1M widgets during September (9/1-10), it will project 3M widgets for the current month (1M will be solid and 2M will be striped to signify striped). I see a whole bunch of options in…
-
Grouping 'Last Connection Time' by month
Looking to create a Beast mode that will break MAX(`Verizon_Last_Connection_Date`) into chunks by quarter. Example below. I am able to validate the calculation, however it does not seem to work when I add this formula to the series. It just displays '1 month' and 'over year'. CASE WHEN DATEDIFF(CURRENT_DATE(),…
-
Employee count by month
I've been asked to build out a card that shows employee count by month, this seems easy enough until you try and factor in the termination date. What is expected is to show in each month the total active employees, so if employee A is hired on Jan 1st and terminated Feb 15th he would show as a count of 1 in January and a…
-
Filter a table with aggregated rows on a dashboard with a filter card
Hello, I have table on a dashboard that is displaying aggregated rows based on on a larger data set. The table has two columns 'parent company' and 'spend', with spend being the sum of all spend at the parent company level. I want to add a range selector filter to the dashboard to filter the rows of the table based on the…
-
3 Key Features Missing in Gantt Charts
Vertical Scroll Bar. Currently, when we have a lot of data to display, we are forced to have huge Gantt Charts so that the text is readable, or we are forced to keep the Gantt Charts smaller, but accept that text will not be readable. The ability to add additional columns to the left of the Gantt Bars. It should be…
-
A more flexible way to do Period over Period comparisons
Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in…
-
How do I reflect team member on Team A before date and Team B after date.
I have a team member that has moved teams on a specific date. I need this person to be still reflected in Team A prior to 8/1/23 and also on Team B on and after 8/1/23. All other team members will remain in their current team. Trying to use beast mode but getting an error. Any help would be appreciated. case when Date >=…
-
Using a Dashboard Filter to generate Purchases From 12 Months Prior to start date
I have a dataset that shows details from received Purchase Orders (inventory) that our company buys. If for instance a user sets up a date filter on this data, we also want to show the received purchase orders for the same vendor for the receipts starting 365 days prior to the Start date of the Date filter on the…
-
Dataset Groups
I would love to see a more organized way to group datasets together and limit the number of datasets that are in view during a search. We have too many datasets with similar names and it gets difficult to find them sometimes unless you remember and search the full name.
-
How do I use data in one column to replace data in a different column in Beast Mode?
I need to create a new column that pulls data in from one column but changes only certain cells to another value based on a value in the same row from a different column. This is what I have tried: CASE WHEN 'column A' = "xyz" THEN 'column B' 'abc' ELSE 'column B' END CASE WHEN 'column A' = "xyz" THEN 'column B'='abc' ELSE…
-
Allow formatting for "Grid Lines" Properties
Regarding the Calculated Line specifically that can appear in bar charts () - please allow formatting or auto default to an abbreviated scale so we don't see 16,000,0000,000.00 taking up real estate on a chart.
-
Support for having reusable ETL Logic
We are trying to redesign our existing ETLs (Magic ETL) whereby we want to have two identical sets of ETLs one for Full Load and another for incremental Load. Since the ETL is complex and there are number of ETLS that will adapt same pattern, we would like a functionality in Magic ETL where we can store entire Business…
-
Understanding Gantt Chart Dates, and Date Filters
I'm struggling with this more than I think I should be, but as always, I probably need an ELI5 version :) I have a Gantt chart where my Start/End Date is my Project Start/End Date. My first question is simple; how do I have my Gantt chart start at today, regardless of what the Start date is? I want today to the last end…
-
How to use Triggered reports with Alerts?
I have tried using the dataset option and it works fine. When I try to do the same using Alerts the Enable button on top does not work. Has anyone faced the same issue? Also, are we supposed to disable the alert?
-
Application upgrade tracking
I am tracking an application update on devices. I have a dataset that looks something like this. I would like to: 1. Count # of devices that upgraded to the latest app (Column App1). Ex. is 1002 and 1004 that has 2 versions, I only need the latest which is in column App1. 2. Count # of devices with app1 and app2 3. Count…
-
WE WANT TO HEAR FROM YOU: Where do you go for information for and help with Domo?
Hello Domo Community! We'd like to hear answers to the below from as many users as possible: Where do you go for help, news, updates, or solutions about Domo? Are there any other Domo resources or external locations that you frequent for information? Even with our bias towards the Community Forums, we know there are other…
-
How do I restart automated report emails after an unsubscribe?
I was sending a report to a company Google group until someone in the group unsubscribed from the report. Apparently, that individual action unsubscribed the entire group from the report. Now, I am no longer able to send the report to the group. After I reset the report for sending, nothing happens. I now have to manually…
-
How do you remove some column data?
I have a column with true and false values for emails. I want to remove all the false values, but when I do, I lose the other columns (meetings and calls) in the table chart. How do I remove just the false values, but have it not apply or filter out all the other data columns?
-
Rename Filters? Persistent Filter Selections?
Hi all, Two questions today: It it possible to rename filters as they appear at the top of a dashboard? Some of the attributes I'm using for filters have ugly names, and then Domo also adds on the "_p" to the end, so the filters area doesn't look very good visually. Is there some way to have the selection options within…
-
Is there a way to pass in a body to an HTTPS GET request within the Domo Connector IDE?
In Domo's Custom Connector documentation, they talk about the 'httprequest.get(url)' funtion (see here: ). Unlike PUT and POST, there is no argument available to supply a body to the GET request. Is this a missing functionality, or am I supposed to pass in the body a different way? Without this, there are several API…
-
Failure to parse date/time
Any help on this would be appreciated, I can't seem to get rid of this error and I'm not sure what I'm doing wrong or what I need to check. I'm duplicating an ETL we currently use for a similar dataset, but this dataset is separated by day, rather than month.
-
Is possible to made a "not in" condition in PDPs?
Usually I use PDP giving access to some areas, but for exceptions I can not just give access to everything, like Employees of Area A but not access to a specific employee out of 300 is posible to use a not in for a PDP?
-
Distinct Count of Donations and Distinct Count of Donors with those Distinct Count of Donations
Essentially we would want the distinct count of donations to by the buckets and the distinct count of donors to by the Y axis. But we want to be able to do it dynamically so that we can adjust date ranges on the card level to whatever we want. So I don't know that I could do this in ETL without pushing it through each…
-
PDP: Using Not Equal To a Value
I have a column that needs to be used in PDP. There are 26 values in the column (that may get renamed or added to a few times a year). I have a group that needs all the Values except for 1. I am wary of adding the permission and selecting the other 25 currently available given there may be a change in the column values…
-
Switch Dataset Dynamically
Can we switch dataset (not database) dynamically while running report in Domo ?
-
Is it possible to schedule a report in less than 15 mins interval?
-
Issues with Hovering for Plots Once It is Embedded
Hello, I created a hovering feature for one of the plots with linebreaks via a beastmode. The hovering works fine within the Analyzer feature but once I try to embed the card, the linebreaks are removed and I see the '\n' that indicates where I placed the linebreaks. Is this a common embed problem and if so, how can I move…