Hello, My backend data in excel has over 50,000 rows and one of the column is #ID shown in the below screenshot. I am searching for an existing ID "9996", but it just shows the 3 values. And I see the note below the search bar which is confusing, and not sure how to filter the page to see all matching unique values. Please…
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
Hello. I'm wondering if anyone has ever had a similar scenario/concept and have come up with good ways to achieve the desired outcome. I've attached a screen shot of real data. The goal is to get the submitted date of 7/5/2024 (A6) linked to orders in rows 7 and 8. The story of this data is that order id 16403748 was…
Greetings, I have aggregated transaction data using the Group By tile to produce the following schema: Project ID (GROUP) Amount (SUM) Labor Cost (SUM) I then join this dataset to a list of transactions which are also grouped by Project ID. Left table = = Transaction dataset Right table = = Grouped dataset from above…
I think the answer to the title is you can't, but to get to the point, I'm trying to go from this input to this output: A Group by on Requestor Organization, and another on Phase works as intended on the Preview, and I am then doing a Pivot on the Requestor Organization to turn it into columns, but I'm still not sure how…
I have a singular dataset that includes Live dynamic data, and historical fixed data. For each ProjectId, I need to SUM the PlannedCost of the historical data with a specific timestamp, and SUM the PlannedCost of Live data, so that I can compare the two in Analyzer. Below is an example of the Input dataset for a single…
When joining datasets, Domo alerts you to any conflicts in the naming. Specifically, any common field names have to be renamed. It defaults to using the name of the originating dataset as a prefix. We use longish, descriptive dataset names, and the narrow, static width of the editing line makes renaming very tedious. Is…
Hi, I have a column name 'Order' with 1 to 6 values in it. I need to calculate the percentage of order 1 and show this percentage on a card in the dashboard. This percentage should change dynamically when the data gets refreshed. I am taking unique count of orders having 1 divide by total count of orders. when i am…
Reposted here: Can't get Group & Join to Work — Domo Community Forum
Hello DOMO - Good Morning! Recently we have new people in our group that we have appended (Trainer) in their names. and we want to update their DOMO names as well. but in DOMO, after sometime, there are names that revert and goes back to just their names without (Trainer) appended. and there are some that don't. We just…
It looks like you're new here. Sign in or register to get started.