-
Remove duplicates but keep null
Is there a way to remove duplicates but keep nulls? I need to keep null values because that indicates a certain client hasn't reached a stage of our onboarding yet, but if data needs to be run twice in one day for some reason I don't want it to remove the nulls or else that defeats the purpose. Anyway, thanks!
-
Is there a way to use conditional formatting where you compare two columns?
Is there a way to use conditional formatting where you compare two columns? Thank you!
-
Quick Filters
Hello, For some reason when I edit a card my quick filters change from "In" to "Not In". Whenever I edit a card I need to verify my quick filters have not changed. Anyone else seeing this behavior and is there a way to prevent it from happening when a card is edited? Thanks in advance for your answers!
-
Overview problems
-
Magic ETL join limit
Is there a maximum number of joins that you can do in a Magic ETL data flow?
-
What is the best way to find a card/page by it's number?
Hi, I noticed that from the backend, there is no way to find a card/page by it's number shown in the URL. For eg: If someone sent you a link to a card or page, even as an Admin, you don't have access to that card form the frontend but can add yourself to the card from the backend. The issue is you can't simply take the…
-
Nest CASE Function in Beast Mode?
Hi, I am new to Domo and am trying to set up a "nested" case function in Beast Mode (similar to a nested IF statement in Excel and am running into some issues. Can anyone tell me what is wrong with the below example? Many thanks! CASE when `Car`= Red then '1' else CASE when `Car`= Green then '2' else CASE when `Car`=…
-
Lat Long map - Zoom in very close
I am trying to use a Lat Long Map to visualize bike station status for the Bay Area Bike Share. BABS has ~70 stations, and I want to visualize station status within the context of neighboring stations. One dot for each station, colored by "Good" or "Bad". Here is the first cut (without status colors): ...is there any way…
-
Is it possible to create drill down view while using power point plugin?
When using power point plugin, is it possible to create a drill down view for a card?
-
Is there a way to group column headers?
Similarly to Excel, is it possible to make a grouped column header view? I'd want to use this in a chart.
-
View Unfiltered Data in Drill Path OR Sum All Data (including filtered) in card
Hi, I have a card that I'm working on where I would *like* to filter by 'In Progress' but at the same time, would like to show 'Complete' only if 'In Progress' is greater than 0 for the specific column. If I can't do that, I know I can filter for 'In Progress' but when I try to add a drill down card, the 'Complete' don't…
-
Beast Mode as a quick filter (save issue)
I have a beast mode case when statement that doesn't involve any aggregation that I am trying to use as a filter. It is relatively simple and I am using it to try and look at one particular warehouse against all others. I am able to add this in as a filter and it works fine the only issue I am running into is when I try to…
-
Beast Mode for Calculating YoY % Variance
Hi there, I'm trying to create a grouped bar chart (retailers x-axis, sales y-axis, year series) and I'd like to add a line for variance between this year and last. The problem is I'm not sure how to create a Beast Mode to calculate a column for % difference YoY. Essentially, I want: (`Values` where…
-
Calculating Months Between Dates
Hello, I am attempting to calculate the months between two dates as precisely as possible. I don't want to just compare the months themselves, since that would make the consecutive dates of 4/30/18 and 5/1/18 (months 4 and 5) have 1 month passed. I know this can be done roughly by calculating the days passed and dividing…
-
can I use a "insert into' statement in redshift ?
i have multiple transformation stage in a redshift data flow. i am trying to use an insert statement in a transform by disabling the "Generate Table Output". is that possible in domo ?
-
MySQL query structure for merge update feature
We are trying to implement the merge update mode in domo (aka upsert), but I cannot find any documentation regarding how to implement it. Especially with regard to the query structure required to make it work. I understand that we need to identify merge key in our datasets and use them in a WHERE statement, but it still…
-
Is it possible to fix the line chart to show a line even when I don't have data
Is it possible to show data as a line instead of points in the line charts? I've run into this on a number of occasions where I'd like the line to show flat between datapoints (when there's no data for a date range) instead of disappearing and showing up as individual points (see image below). Does anyone know if there's…
-
Annualized Terms and Turnover
Good Morning, We have a turnover card that currently shows the YTD Turnover % along with the YTD terminations. When calculating the annualized projected terms and turnover, I have used the YEARFRAC calculation in Excel. I'm not sure what I will need to do to recreate that column here in Domo. Here's an example of the…
-
Workbench 4: Admin privilege required to run on local machine
Hi, Is there a way to run workbench 4 on local machine without the administrator privileges? Thanks, Sandeep
-
Select Widget - Bug?
There is no ability to make use of the "Select Widget" on my cards, can you please advise what I should do to power the select widget. See screens attached.
-
Can't add widgets on Domo Design Studio
I am a new user of the Domo Design Studio and am having some issues. When I try to add any widget, there is no "add widget" button. I have restarted the app and tried everything I can think of, but I am unable to place widgets on my design layout. When I click "Preview and Upload", my current widget is erased and nothing…
-
Is there a way to create a bar graph showing metrics measured in both $ and % at the same time?
-
Color rules not flowing to chart legend
Im seeing a wierd issue where I have a color rule on my card, but the legend doesnt seem to be updating to the new color. It holds the color of the default that the card was auto generated with. There is no logic on the color rule, just for this variable use this color. I tried hiding and then opening the legend, saving…
-
Determining the release date for updates/enhancements for our instance
Not sure if this is really the right place for this but I'm excited about this month's new releases and was wondering if there was a place I could find the date when I could expect it to hit my instance of domo? I'm thinking the range of first half of the month is a safe bet, but was wondering if there was a more defined…
-
Storing refesh token with access token
I'm woking with an API that uses OAuth 2 and a rediculously short token expiry period. Part way through getting the data the access token expires and I need to refresh it. A refresh token is provided at the same time as the access token. It's important this is used as without it a new token has to be issued that would…
-
Adding multiple images
Team, Need to add multiple images and logos in a card without using HTML tags and need to create a drill through on them that will open up a summary report. If its not possible can you please provide me the HTML script? Regards Ajith Shankar
-
Accesing Oracle database using VPN
Team, My Oracle database is in a separate server, so we try to access it remotely using VPN. How can we access the same using this tool as its erroring out when Iam giving DB credentials. Also I dont have privileges to install DOMO in the server environment. This is an urgent requirement. Appreciate your kind help on this.…
-
Label only certain values in nested bar
I need to show how the value of a selected group compares to the overall by month. I have a nested bar started but need some help with the formatting. I can theorize accomplishing this in a couple of ways but not sure how to accomplish either in Domo: 1) (preferred) - eliminate the 'Unique Submissions' segment which i have…
-
Domo Workbench Move users
Is thre a way that the data in Domo Workbench can be moved from one user to another? A colleague of mine is leaving the business today so I need to move all what she has in her Domo Workbench to my Domo Workbench. How can I do this? Many Thanks Simon Gillham
-
How do I filter out bots and spiders from past Google Analytics data?
Normally you would accomplish this by creating a view. However, views are forward-looking only. I want to filter past data for bots and spider hits. Has anyone ever tried to do this?