-
Load Domo Bricks Form with values from Existing Dataset
Hello, I'd like to load a domo bricks form with data from an existing domo data set. I see I can use the domo.get method: domo .get('data/v1/sales') I expected the string value to be a domo data set id, but from reading it seems I need to set up a manifest.json file to map each dataset to a convenient name. Where do I set…
-
Fixed Function At Two Levels (Or nested Fixed Function)
I have a data set that includes duplicate rows for products. I'm using a fixed function to de-dupe an aggregate sum of product prices because I only want one product row to contribute to the total. The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID) However, now I need to…
-
Multiple Level of Detail Tables From One Dataset
Hello, I have a product data set that has product sales with fields for store and city. From this data set, I want to create three tables at each level of the hierarchy, product, store, and city. The only way I can think of doing this is by creating a bunch of aggregate beastmode calculations for each field. For example,…
-
Flexible SUM Aggregates With Duplicate Values in Dataset
Hello everyone. I have a data set that looks like this: This data set shows product purchases at the customer level. Thus, product IDs are duplicated in the data set. Here's the challenge. I want to show the total value of products, counting each product value only once in a SUM. I've added a Product Rank column as a…
-
Filter by Section of Dataset (Bonus point question!)
Hi Everyone, this is a bit tricky. There is a need to have an aggregate table that shows counts, sums, and averages for different sections of the same data set. But subsets of these sections are defined by matching filters on the dashboard. I know that doesn't make much sense, so here is an example of a simple table.…
-
Excel Sheet to Domo
Hi Everyone, Happy Friday Eve. I have a shared Excel workbook with multiple sheets that are appended together via power query into a master list sheet. I'd like to set up a Domo connector to pull from this master list sheet only. Is this possible? What is the ideal connector for this, and where is the ideal place to store…
-
In App Editable Data and Real-Time Visualizations
Hi Everyone, If users wanted to be able to edit the data that goes into a visualization, and then see how that edit impacted a visualization (and all of it's great metrics), what would be the idea way to do this in Domo? I was thinking that you could use a Domo Webform to let users plug in new data/edit data, and then use…
-
Dynamic Image for Users
Hi everyone - we're trying to create a page where a user can log in and see their own personal dashboard. Is it possible to add an image for this user to the dashboard that is dynamic in that it shows the image from a url that is for their user id? The url values would come from a domo data set that maps to the user id.
-
Reduce ETL Processing Time
Hi Everyone. I'm looking for strategies to reduce the run time of Magic ETL 2 data flows. I'm working with several left joins in sequence on about 17 datasets of 1 million rows each. Beyond this, the ETL performs no other operations. I'm curious if anyone has experience with these options: Data fusion Adrenaline Redshift…
