-
When will we be able to gather the result of a DataFusion via the API?
Due to concurrency issues, we are unable to use DataFlows to update our final combined data. Thus we must use DataFusions to do so. However, there is no way to reach the result of that DataFusion via the API. In other words, the DataFusion doesn't create a DataSet - only a data card. Cards can't be accessed via the API,…
-
add manual target line
Hi, Now i have stacked bar. How I can add target line month to month and every month is ddifferent target.
-
Remove duplicates from large dataset
Is there a faster way than ETL to remove duplicates from a very large dataset?
-
Can we pull custom reports from Quickbooks?
Is there a way to get the custom reports from Quickbooks to Domo?
-
How can I search annotations
I am very interested in using Annotations for historical information to give feedback on the data. However I'm expecting that overtime I'll have many annotations on weeks/months. Is there a way that I can quickly search annotations to find what time period that annotation happened. An example is if i know i changed sales…
-
Browser Details column in Activity Logs of Domo Stats is web browser user agent
Hello DomoSapiens, I have looking into Domo Stats Activity Log table data, it's very handy and useful. However cannot really identify which browser is the user using as the Browser_Details column brings in web browser user agent details instead. It is very useful, but really hard to build cards and monitor the platform. In…
-
Last Updated Time on Card not visible to users
Hello, Is there any way to have the 'last updated time' show on a particular card so that end users can see how recent the data set is? I see another topic covering this as bug, as the suggetion from support was to enter a ticket through support.domo.com. That site is not working and I don't see any status on if this will…
-
Limitations on Data Fusion for data manipulations
I have been playing around with all the features available in Data Fusion and it seems like not only it's difficult to understand what function can go after what, and more importantly, a limitation on joining multiple linked functions within one workflow or to build a more complex workflow. Can we have the Data Fusion…
-
API Dataset Export Issue
I've been trying to use the below example to export a dataset from a browser URL bar. GET https://api.domo.com/v1/datasets/317970a1-6a6e-4f70-8e09-44cf5f34cf44/data?includeHeader=true&fileName=Q4_Sales_Data.csv Accept: text/csv Authorization: bearer <your-valid-oauth-access-token> I've put in my own dataset code and my API…
-
Laying a line over a stacked area graph
I have a stacked area graph visualization, and I want to overlay a single line originating in the upper left corner of the graph and ending at a particular point on the x axis. Is this possible?
-
Joining Datasets with different numbers of rows
We’re looking to analyze staff utilization data. There are two data sets: Data Set 1: Raw data from a timekeeping system with daily time entries from each staff member, there are multiple rows per person per month. Data Set 2: The total available hours per person per month, there is one row per person per month. We’re…
-
Top 10 Display
If I am working a simple card bar chart and only want to show the Top 10 (or Top X) of the data set, how can that be done? I look in Data Flow ETL and also card Beast Mode and don't see anything intuitive to accomplish this what I am guessing is a pretty standard query.
-
Is there a way to do this in Magic ETL?
I've got the following CASE statement in a beast mode now, wondering if there is a way I can do in Magic ETL so I can then use in card filters. CASE WHEN SUM(`Order Quantity`) > SUM(`Quantity Available`) THEN SUM(`Value Available`) ELSE SUM(`Order Value at 02 Slow Item Cost`) END Thanks in advance for your help!
-
DoubleClick for Publishers Revenue Inaccurate
Hi, For all of my cloud based DoubleClick for Publishers datasets, the "Revenue" column (`Column.TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE`) is always multiplied by 1,000,000. I've remedied this by just creating a formula to divide the revenue by a million, but do you know why this happens? Does anyone else have this same issue?…
-
how do I access a table built by a domo stored procedure?
I have created a dataflow that in separate transform boxes does the following: * Drops ta Stored Procedure * Creates a Stored Procedure * Calls the Stored Procedure The Drop and Create transform return valid sql and seem to be working fine. But the Call (step 3) fails indicating that the table that I created in the…
-
What's this about public data sources? When? What? How?
I saw a slide the last time I logged in to Domo about public data sources ... didn't pay enough attention to it until I closed the window and then wished I'd actually read it more closely. So what's the deal with public data sources?
-
For Salesforce Community data are there pre-built cards we can use?
We are migrating from Salesforce Customer Portal to Community. Are there pre-built cards we can use for Community metrics? Are there bnest practies we should be following? Are there Domo specialists with experience working with data from Salesforce Community who can guide us?
-
Percent increase/decrease
Hello, If I have many columns for ex: "2010 population" "2012 population" "2014 population" and I would like to show the % evolution between each of them on the graph how can I do it? Thanks!
-
Renaming Rows
I have a data set that has multiple rows all with the same name but different data for each row. I want a way to have a flow or beast mode that searches a column for all the rows with the same name and then if they have the same name it will append a number sequence to the rows name to distinguish it from other rows of the…
-
How can I know the volume of all my datasets stored in Domo?
I need to know the volume of all my datasets in Domo. Is there a way to filter my datasets and sum all their Gb? Thanks.
-
Card not showng last few rows of data from Google Sheets
I have a card connected to a simple google shhet where the first field is date. he card has a date filter, and My users have reported that they are not seeing data from October, which is the last 7 lines in the Google Sheet. Looking at the data source in Data Center I can see that the data has been imported, and other…
-
Beast Mode to Calculate Gains in Values
Hello, I'm trying to create a beast mode to calculate gains in values over time to be displayed on a single value summary card. We have both the values and their corresponding dates. We are trying to calculate the gain based on the difference between the lowest and highest value (given that the highest occurs after the…
-
Join 2 data sets based on multiple column
Hello, If I want to join 2 datasets, but the matching column can be multiple, how can I do it with ETL? When using join data and selecting "match another column" it is not working as an "or" condition. What I would like it to find all the matches between 2 columns, and then go to 2 other and do the same. Is that possible?…
-
Return values with condition on another column
Hi, I would like some help with beast mode as I'm very new to this. I have a list of keywords, URLs and their amount. There are duplicate keywords with different urls, one containing "/blah/" and one not. Keyword URL amount AAA xyz.com/aaa/blah/ 1 BBB xyz.com/bbb/blah/ 2 CCC xyz.com/ccc/blah/ - AAA xyz.com/aaa/ - BBB…
-
Setting up SFTP
Hello, I am working on a project- which requires 3 reports. And 1 report has to be dropped by another department, and they can not do it directly to the network directory(DOMO Workbench). They are looking for SFTP credentials. Can anyone please help me in setting up this SFTP. Thanks
-
Google Analytics Enterprise Connector unable to select views
Hi, I'm having some trouble trying to configure one of GA Enterpise connections. It seems to be unable to connect to my account and retrieve any data.I've tried resetting the client ID and Secret through the Google API console. My credentials always pass the verification step, but I can't even select which view I want to…
-
How do I filter zero's out of my card?
I've built a simple card that is pulling a Name and an Amount. But when I pull the amount into 'filter' and select 'not in: 0' and then save & close. All the zeros are still showing. Any advice? I've even created a beast mode calc. (Case when `Amount` >= -1.49 AND `Amount` <= 1.49 THEN 0 ELSE `Amount` END ) So that any…
-
Rate of change calculation
I've got a dataset (column) which is basic time-series dataset containing the volume of fluid in a vessel with observations every 5 minutes. I want to create a calculation to determine the average per-day rate of change of fluid in the vessel. I've uploaded an example of the raw data The basic idea would be: Rate of Change…
-
Parse out the domain of an email address
Hi Everyone, In a data flow, how do you parse out the domain portion of an email address so it can be put it in a separate field? Please let me know if you have had any experience with this. Thanks, Mark
-
Forecasting and Predictive Modelining
Hi All, I have to forecast data for next year. Is it possible to create using beast mode.