-
Asana Connector - Get hours allocated to a task
Using the Asana connector I have gone through all the available datasets and can't find the hours allocated to a task anywhere. Use case: Use Domo to create a table of team members's resourcing levels by hours on a daily basis.
-
Facebook Ads Advanced | Store Visit campaign reporting
Hi I'm trying to get measurements on the new store visits objective from Facebook. Using the custom insights report none of the measured reported are the store visits. Documentation from Facebook is here https://developers.facebook.com/docs/marketing-api/guides/dynamic-ad/store-visits?hc_location=ufi#api In the Facebook…
-
Applying calculations to hundreds of columns in a dataset - best practice?
I have a dataset that has ~1,200 columns and I need to perform calculations on 495 of those columns (simple multiplication and division) and create a new column for each with the calculated value... Trying to do this in ETL will take forever to setup (would need 3 calculators, 2 of which will have all of the the 495…
-
Finding quartiles and outputting the data within each quartile
Hi I'm trying to break a dataset down into quartiles for Recency, Frequency, and Monetary (each data item will have a value for each). I then need to output the items that are within a given quartile in order to do further data manipulation. I know that box plot graphs can show quartile values, but they don't actually mark…
-
App Design Studio - app won't upload to Domo
Hi All Trying to buid my first custom card design with App Design Studio. I have the latest version of both Illustrator 2018 CC and the 2.2.8 App Design Studio plugin from https://www.adobeexchange.com/creativecloud.details.14699.html I was able to layout my widgets OK and the preview looks fine. When I click the…
-
Specify different date formats for multiple sources in ETL
I am combining a number of data sources with date columns using an ETL before performing other calculations on them. Some of the sources have Australian date format (DD/MM/YYYY), and others have US format (MM/DD/YYYY). The ETL gives me results in YYYY-MM-DD format, where it's actually incorrectly converted some of the…
