-
Ignore some page filters in cards or pages
Is there a way , where you can set a card to ignore some pages filters but accept others . if i have one datasource and a card with a precalculated value at YTD filtered by a dimension. and a filter on country and i have another card that i want dynamic as MTD, o CTD depending on what the client pre selects. and country…
-
Query Based on a Value Between Two Date Columns
I've got a data set that includes job tickets with create_date and last_update columns. If the date range for a card is set to include a date in between the create_date and last_update, the ticket should be considered "open" at that point in time, and any tickets outside of the date range should be considered "closed" at…
-
I am trying to use a case statement with a Time field for a table but when
I am trying to use a case statement with a Time field for a table but when i do it the values come out to be empty
-
Updating a User
Has anyone had trouble recently updating a user's email? I have SSO enabled and one of my user's emails changed. Usually, I just go in and update the email, and it's fine but now every time I try to do it I get a pop-up error that says "Error updating user". I was able to do it via the CLI but it's happened to me a few…
-
April's Community Event Recording is Live!
April’s Virtual Meet-up, How to Create Composite Measures using Data Reduction Techniques" recording is now LIVE! Thanks to everyone who attended.
-
Card instantiation based on card templates
Current situation: We have a dashboard with cards showing the number of sales in a country. Then for each target country, that cart is duplicated, and its filter was modified to select the specific country and renamed to include that country's name. Now we have a lovely dashboard in which you can quickly discuss the sales…
-
Exporting Card to PowerPoint only Displays First Page of Data
When trying to export a card to PowerPoint, the export only contains the first page of data (see example).
-
Changing Dataflow Owner
If someone owns a dataflow they should be able to go in and change the owner from themselves to another person. Currently, only an admin or someone with the "manage all dataflows" grant can do this.
-
Facebook Advanced Ads Connector not returning Conversion Values?
Anyone having issues with Facebook Advanced Ads connector? We have been working with Support but we are not getting anywhere. I have these fields selected: “fields”:“account_name, adgroup_id, adgroup_name, campaign_group_id, campaign_group_name, campaign_id, clicks, conversion_values, conversions, date_start, date_stop,…
-
Chart showing a blank date as a day when graphing by week
I have some cards where single dates are shown on weekly breakdown. As you can see, it is listed by week, but there is a date right in the middle that is listed as one day, but it is blank. This should not be showing by day and it shouldn't be showing the date if it is blank correct? What am I doing wrong?
-
Possible to update multiple filtered dashboards from aggregate dashboard?
Hi all, I currently have a dashboard of about 40+ cards and am wondering if it's possible to create copies of the dashboard that filter the data (and doesn't allow for an unfiltered view). Essentially, the dashboard aggregates data from several partners but I want to create create dashboards for each partner without them…
-
Make the text style the same for card and variable control titles
Please make the titles for Variable Controls and cards have the same text style, since it causes the cards to be aligned differently. Here is an example of vertical misalignment with a variable control and filter card next to each other on a dashboard layout:
-
Finding averages based on selected ID (client)
The data I am working is at an asset level (example below) and I would like to find the average of all client ages accurately when looking at any segment of asset. Client Account Asset Age Client 1 Acc 1 Sec1 50 Client 1 Acc 1 Sec2 50 Client 1 Acc 2 Sec3 50 Client 1 Acc 2 Sec4 50 Client 1 Acc 2 Sec1 50 Client 1 Acc 2 Sec2…
-
Please do not use thousand separators in numeric filter values
When we click on the table chart on numeric values it prefilters other cards by adding value into page filters. However, that value contains always the thousand separator. This is an ID field, not a quantity field, so it looks odd to have a thousands separator in the filter bar. Please allow page deigners to disable the…
-
Card that will show if a Dataset has been updated
Hello DOMO - Good Day! I would like to know if it is possible to create a card that will show if a dataset has been updated? also, if it has been updated automatically or manually basically, a card that shows the dataset name, the date it ran, and if it is automatic or Manually ran. Thanks
-
Exporting Mega Tables
Do Mega Tables usually tell you if your export is missing data? I have a mega table with 100,000 rows but when I export, it gives me 50,000 but there is no error message saying it did not export all data.
-
how to aggregate nested average case statement
Business task: "what percent of this region's sites beat their target signups YTD"? So I want to take the average daily signup for each site within a region and see if it passes its target. If it does pass, it gets a 1, else 0. After this, I then want to aggregate it to the region level. So for example if 5 out of 6 sites…
-
Beast Mode - Checking data from a different row to generate result
I'd like to create a Beast Mode that takes a value and checks it against another row in my table. I have a bunch of human annotation data. I want to look at a content_id and then flag if that content_id has been in the QC job. I've made a rough sketch of how the data looks (apologies for the formatting. This is my first…
-
datediff at row levels
Hello, I'm doing analysis of our repetitive customers. I want to create a calculation that will show the days difference between order 1 and order 2 based on the company. Each order has its own row. I created rank column, that assigns 1 to first order, 2 to the second etc… How can I create a calculation that will subtract…
-
Dropdown filter only seeing a few options
I have a dropdown filter card that is not showing all available options that should be showing up. Here is the filter card: As you can see I only have 2 options in the dropdown, but if you look at the filter for the same column: You can see that there are many more that this filter should be seeing in it's dropdown. Why…
-
Bulk User Email Update
Hello, I have ~450 users that need to have their email address updated (company has changed to a new format). I know I can do a bulk update, but it uses the email address as the identifier for each account so if I change the email it will just import them as new users. I do not want to delete and re-create the users since…
-
Joining 3 different datasets to match zip codes
Hi, I have 3 datasets each with a column containing zip codes. I want to use ETL to create a new dataset with 3 columns, all containing the zip codes from each input lined up. Input: Dataset 1 Dataset 2 Dataset 3 1 2 1 2 3 3 3 5 4 4 6 5 Output: D1 D2 D3 1 1 2 2 3 3 3 4 4 5 5 6 Thank you
-
Sharing Filter Views despite dashboard page lock
We have a highly viewed dashboard that we have locked so that people can't change. People want to create filter views and then share them with other people. Unless you are an admin or have the grant of "Manage all cards and pages" (which is a security liability) then they can't share it. Therefore, I propose: The ability…
-
Anyone experiencing issues with the Alpha Vantage connector?
I have been getting the error: "Could not authenticate. Please check your credentials." for the past three days. Previously, the two datasets using the Alpha Vantage connector ran for three months without error. I just tried using a new API key and it did not work either. Is there a solution to this, or better yet, a…
-
How to connect to Citrix Xenapp Daas from Domo?
Looking for an API or Connector that connects to Citrix Xenapp Daas from domo
-
Domo Everywhere Editor Embed Cookie Issue
Hi, Anyone having issues with the Edge browser. Whenever our users access domo embedded they are greeted with this button without explanation. I think this is to do with blocking third party cookies.
-
Show average, count, and sum when selecting table card cells
When viewing a table card, it would be awesome to be able to select numerical fields and see a quick aggregation summary, similar to what Excel does below:
-
Rounding in column instead of only in Beast Mode
It would be extremely valuable to be able to set a column to show something like "12M" instead of "12,031,230" without having to create a beast mode for every single column. These options could live in the format section of the field options.
-
Splash Page for when page needs maintenance
Ever needed to make a few changes on a dashboard that is in production without having the users see behind the curtain? Small enough to feel like using Sandbox staging doesn't make sense? I think being able to toggle a "Splash Screen" with a few customizable fields to show that a page is under maintenance for a short time…
-
Beast mode formula
if "event type" is not equals to "current physical due" but the the "enrollment date" is still within 90days from today then its consider as pending and here is my formula: CASE WHEN Event Type <> Current Physical Due AND ABS(DATEDIFF(NOW(), Enrolled Date)) < 90 THEN 'pending' ELSE'' END but it's not working, please help!