-
How do I create a rate with 1 row of data then filter it by unique cells of another row?
I'm pretty new to Domo and work in healthcare but essentially I have an excel style sheet of data. In 1 of the rows is the list of different admitting providers and in another row it specifies if the patient was inpatient or observation. There is a column/unique account number for every patient in this data sheet. I am…
-
Why is campaigns front end web development instead of PDF export of dashboard?
I'm confused as to why one must have front-end web development experience/knowledge to create a campaign report attachment. This just seems like a lot of extra work for no reason. Can't we just link to an existing dashboard that becomes a PDF based on the distribution filters? That just seems like it'd be a lot easier. Am…
-
Filter to show blank cells?
Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank. I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this? Thankyou in advance.
-
how do you open attachments entered in a form builder form
I have created a form in form builder with the attachment field type. I have tested it and output the dataset into a table with an ETL The File names show but I do not know how I would go about being able to open or view the files. How is the Attachment field type intended to be used and attachments viewed after submission?
-
Customising spacing in grouped bar chart
Is there a way to space out the bars in a grouped bar chart ?
-
Is there a way to create a dataset in Domo based upon a Salesforce Trending Report?
I have had this report trending in Salesforce for a few weeks. When I create my dataset in Domo, not sure if there is an Object, Report or other method to access this data. Has anyone been successful or have any suggestions? I know how to get the data into the Salesforce Analytics CRM system, but would prefer to use Domo.…
-
Date and time of last update on the Dashboard
How do I show the date and time when the data powering my cards was last updated on my Dashboard?
-
COUNT(DISTINCT CASE WHEN THEN)
I am not sure why this formula is working, it seems fairly straight forward but I am just becoming a regular SQL user and our company just adopted DOMO. Any ideas? COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled')
-
Case Statement with multiple conditions and excluding null values
I am trying to create a case statement where I have a new column that replaces a value in column1 with a value from column 2 but only if column 2 is not null. If it is null, then the value in column1 needs to remain the same. Sample table: I need it to look like this: So "Account A" is replaced with "name" from column 2…
-
An option to disable Domo everywhere and Publication
I would like an option to turn the following off: * Domo everywhere * Publication They've got some security issues so it would be nice if there is an option to disable it just like the report scheduler.
-
Best way to filter on trends in a chart
I have a chart with a very large set of series values. I want to filter to focus on members of the series exhibiting specific trends (uptrends or downtrends) based on the y-axis value. Does Domo provide any such filters? Or perhaps someone can recommend a Beast Mode calculation I can reuse?
-
How to delete data of a domo dataset
Hello All, I have a domo dataset created from a source ( Teradata ) via some tool. That domo dataset having 4 weeks of data I found that one of the four weeks data is incorrect and would like to delete only that 4th week data. I checked all options in domo I did not find an easy to delete that week data. FYI, I have admin…
-
Empty plug in top left
Hi, I'm quite new to DOMO and all the videos online have had a large M logo next to the Domo logo in the top left of the screen. Is this a plug in that I can install? I also don't have the business in a box dashboard although I'm working within a small business account. Thanks
-
How should dataset be structured to create a simple line and bar graph?
I am not sure whether this can be done because I do not see in Domo's chart options a selection for a simple (vertical) bar chart with a single line. If such a graph exists, how should the dataset be structured? The objective is to show several categorical values in the bars and the line represents a goal that is…
-
User Activity Log
Does the user activity log count / track usage via the mobile app or just the web app? Trying to hold users accountable and want to make sure that "no activity" reported in the activity log, truly means "no activity".
-
DomoR vs RdomoSDK
I have been handed an r script that has is using an accessToken to connect to domo and extract a dataset using a dataset ID. My end goal is to translate this to Python, as I have an existing pipeline in python that needs this dataset. Initially using the naive approach I tried to connect to Domo using pyDomo but was…
-
salesforce api method?
I'm diagnosing a Salesforce performance issue. My SF admin has asked me to identify which API methods DOMO may use to access salesforce, i.e. Bulk, Soap,Rest. can anyone shed light?
-
Case statement help! :)
Hi all! I'm not really new to Domo, but definitely new to the community here. I'm trying to build out a case statement to bucket some of my values together. If I do something such as when `xx field` like '%canada%' then 'canada' when `xx field` like '%growth%' then 'growth' If i have values that are something like Canada -…
-
Can I tag Domo Pages
Can I tag domo pages like datasets..... I like to flag all pages created by my category.. Can I tag pages?
-
How to group rows and make columns that count specific values?
Hi! This is a difficult one to give a title but basically, here is what I am trying to do: I have a dataset that combines a dataset of user profiles and a dataset of our assets that are assigned to each user. What this does is make it so every single entry for a user's individual assets gets its own row. So basically, if…
-
Beast Mode - Multiple functions
I've created a beast mode which is correct to add 2 working days to a date. However I want then be able to group this new date into calendar weeks. I used WeekofYear Beast Mode which came out as valid but when I graph this then drill into the week is the first date for the week is Thursday not Monday. I assume that based…
-
No Domo Actions returned via /v1/domoactions API
I published a Domo Action which was approved by the Connector Team and was able to add it to my API Accounts in the Domo UI. When I query the domoactions API, I get no results. 'https://api.domo.com/v1/domoactions' -> [] Also when I try to get the list of accounts to retrieve my account id, I get the following error…
-
How do I turn off an alert on data loads?
Early in my Domo learning, I turned on an email alert that triggers when a dataset fails to load. Now, weeks later, I want to turn it off, but I cannot find the setting for this particular alert, and documentation has not helped. (So I also no longer remember how to turn on these alerts). The alert reads: The DataSet <X>…
-
HTML Table with Numbers
Hello, I was wanting to have more customization when making my tables in analyzer since text cannot change much. I am having trouble making the html work for my numbers though since everything gets formatted as text. I was wondering if anybody had any ideas to set up this code? I found some solutions on the web, but was…
-
Can I take the Data Specialist certification with only a little experience outside of the training?
I've been through the Data Specialist training a couple of times now but haven't had a lot of time using our production Domo instance. Is it reasonable to believe I can take and pass the certification? I'm concerned that I might be in a 'What comes first? The chicken or the egg?' paradigm. I can't get the access levels I…
-
What level of access do I need to take the Data Specialist certification?
I am looking to take the Data Specialist certification. I am curious what level of access I need to take this. My understanding is that part of the certification requires using Domo for a project or something along those lines.
-
Data Permissions - Restrict Access to Underlying Data
I know that there are ways to limit access to certain data in a dataset, through personalized data permissions. However, is it possible to provide somoene access to a card without allowing them access to ANY of the underlying data, so that they are just able to see it in aggregate in the card?
-
Dashboard question
Hi, I'm new to Domo dashboard and want to know whether there's a way if you click on one bar in the bar chart it will switch the dashboard to a new dataset. Like here if I have a dataset that is the overall of the months(2010-Jan ~2010-Dec), and I have separate dataset with more detailed info about each month.. I want the…
-
simply question
How do I delete a row of data that is incorrect. It has passed through staging and is has populate my card. I don't know how to remove it as i have no reference . Thank you
-
Count snapshot data (for HR Turnover)
I am trying to find a way to count number of rows per month (spanning over 3 years and counting) to get the total number employees for each month in variable form. The data structure is set in a way that the number of rows should be equal to the number of active employees as of a certain snapshot date. I am not sure if I…