-
Creating custom year to date default range
Hi, I'm was wondering how to create a custom year to date default range without having to set any filters from a user experience. I wanted to take advantage of the 'This year' drop down feature logic that is built in, but is there a way to automatically default select 'This Year' rather than 'All time range' so that when a…
-
Can you import Adobe Analytics data, facebook, youtube etc using Workbench?
Can Adobe Analytics data, facebook, youtube, Twitter data be imported via Workbench? Thank you. Olivia
-
Why does Firefox not refresh my card when the Dataset updates?
I have a Dataset that updates very 15 minutes and displaying a card that directly connects to this Dataset. I was told that when a Dataset updates the card will auto refresh upon the data refresh, however, in Firefox this does not occur. Luckily this does work in IE.
-
Group By function appears to have broken in the ETL UI (but not the actual processing of saved ETLs)
I set up some ETLs a bit over a week ago that utilise the group by function to mind the max(_LAST_BATCH_DATE_) and then join that back up to allow me to filter for only the most recent version of the record. Since then: * the ETL was still running correctly and putting data through as expected * opening the ETL shows the…
-
I have a Google Sheet that pulls in the last 7 days of Adwords data.
I have a Google Sheet that pulls in the last 7 days of Adwords data. I am attempting to create a dataset that appends this data without creating duplicates. I would love it if someone can provide feedback on how to accomplish this. Thanks.
-
How do I change the color to a bar chart using App Design Studio?
-
Custom Summary Number using Beast Mode with Thousands Separators
Hello, I'm interested in using thousands separators in a custom summary number I built using a Beast Mode. The number to be separated is a summation using a case statement. For example, the number is 122435453.88 and I want the thousands separators. Thanks!
-
Week to date conversion
Hi Guys, i have a requirement to display weekly revenue data in a group of quarter and year like attached. How can i make it grouped with taking 2dimension in X-axis. Best Regards Bikash
-
Accessing data stored in domo
I have data stored in a MySQL database in Domo. I'd like to be able to have local SAS and R programs be able to access it directly via an ODBC connection. Can an ODBC connection be set up on our PC's to tap into the Domo database?
-
How to change owner on all datasets in DOMO in single click
How to change owner on all datasets in DOMO in a single click. Any HELP ????
-
Longitude/Latitude Map interactivity
Hello Community, I have built a Longitude/Latitude Map with all provided functionalities in DOMO, however the chart remains inactive for any input or selection. Further drill-downs cannot be attached to the card, as somehow it seems to be an inactive card in every way possible. Could you please help me if it is a normal…
-
Dataset via Email multiple files
I have a number of files that are exported and sent via email. There are multiple .csv files in the email. Anyone have any idea how I might be able to use a Regex to grab the specific file out of the email? Thanks!
-
How can I total individual elements of a table?
Hi, I have a card where I have individual country data calculated as such: The value of A is calculated simply as: SUM(`X`)/SUM(`Y`) The countries are in the same group, Europe. However the Grand Total is simply completing the same "A" calculation across the group. What I need is a simple sum of the indivdual country…
-
SUM, Percent
How to find the sum of two measures ? Eg : Created two fields in beast mode-> Old G/L = CASE 'Age in month' > 12 then Old Current G/L = CASE 'age in Month' >3 then Current . There fore, want to find the Total Entries= Old G/L +Current G/L secondly want to calculate percent of Old Entries = Count (Old G/L)/TotalEntries * 100
-
Margin Calculation
I am trying to calculate the average margin. I have two columns: margin for the item and units sold. For example: If i sold 50 units at 30% margins and 2 units at 50% margin, my average margin would be roughly 31% I need to do a summation of total units and total margin % If I do not have the summation my average margins…
-
Value Mapper doesn't find my Values
I am trying to change a row value named as you see in the screenshot into another value. The value does 100% exist. But the mapper doesn't change anything. Got someone an idea why or what I am doing wrong.
-
Combine two values to one
First of all Hello World, I am a newbie user of domo and would like to show my problem. I've got an input table with customers and turnover and I would like to show the turnover by customer. Some customers are the same but with different customer names for example : CC Factory Inc. and CC Factory GmbH In my chart I need a…
-
Integrating DOMO with Netsuite and/or Sage Intacct
Has anyone integrated Domo with either Netsuite or Sage Intacct? If so, was the process successful or were there any hurdles?
-
Can you upload a dataset from workbench and specify the owner.
I have workbench installed and we can upload datasets just fine. What we want to do is change the owner of the dataset when it gets uploaded. Specifing somone other than the user logged into WorkBench. Is this possible? Or is it such that the owner of the dataset is assigned to the logged in user of workbench when the…
-
How do I get my Histogram to display 24 bins on the X axis (one bin for every hour in the day)?
I have a dataset that includes a Date/Time Stamp showing when a delivery driver has arrived at their destination. I use a Beast Mode calculation on that Date/Time Stamp that strips away the date and displays a value for the hour of the day that the driver arrived at their delivery destination (see Beast Mode calculation…
-
Is it possible to get the status of a http request within the DOMO connector IDE without XMLHttpReq?
I am trying to handle various http errors in my custom connector and was wondering how to do that as XMLHttpRequest isnt supported. I need to status code values for my get requests. Thank you.
-
Pardot Prospect connection Fails
Recenly I'm trying the DOMO for connecting data in Pardot. I could connect with all other reports but always fail when try to connect to my prospect reports. How could I solve this?
-
Subtotals on a certain row in a Sumo card?
Is there any way to choose which row to have a subtotal in a Sumo card? Currently I can only get it to show subtotals on all rows, which isn't helpful if I have multiple rows for one date but only want a subtotal at the end of the date not at the end of each loaction.
-
Beast Mode validated but still shows error in card
Error message: An issue has occurred during processing. We are unable to complete the request at this time. Code: (case when `Make_It_Personal` is null then 0 when `Make_It_Personal` = 'N/A' then 0 else `Make_It_Personal`*1 end) The field name is "Make_It_Personal" and it's in text format. Possible values are (0-10, N/A,…
-
How to change owner on all cards in DOMO in single click
Hi All, How can I change the owner of all cards in an easy way? I know we can change for one by one card by changing the owner. But there are so many cards and I would like to change the owner in a single click. Thanks
-
Renaming columns in Blend after changes to the base tables
If I create a Blend of multiple columns, then the column names do not have a table name prefix unless there is a duplicate. However, after creating the Blend, if I add a column to the base table and then do a Preview again, then it does not let me rename the column and it is just too tedious to rename the columns everytime…
-
Create Dataflow With R
Hi, Is there any possible way to create dataflow with R without using R plugin (writing the script directly in DOMO just like sql)? If no, is there any plan to develop that? Thanks!
-
Business/working days MTD vs. Prior Months
Hello All, I am trying to figure out how to a MTD comparison between current month and prior months. I want to compare my February MTD results the the prior months results assuming they were at the same MTD period as my current month. Hence if I am only at the 10 business day of the current month then I want to see where I…
-
Personalized Data Permissions: Sharing datasets without email notifications
Is there any way to share the datasets with other persons or groups through Personalized Data Permissions in DOMO without spamming the recepients with notification mails?
-
Workbench Schedule Error
I just tried to create a schedule group within Workbench 4, and i got th ebelow error. My question is, the path at the end says C:\JENKINS\.. that isnt on my computer anywhere. [ERROR] [19292:30] 2018-02-22 15:16:20,549 - Could not create scheduled task 'Sched_Group1' with path…