-
Grouping by Cost, revenue and margin
Hey all, looking for ideas. I have a data set that has shipping lanes (Origin/Destination) and then a summed cost and revenue for each shipment on each lane. Then a margin based on that for each lane and shipment. I have each lane summarized into a monthly average, but I would like to be able to break that down a little…
-
Beast mode that looks at filters?
Afternoon, I have some metrics that I would like to change automatically when a filter is selected and wondering if there is a way to do that through a beast mode (or any other way)? For example I have lanes A to B and also A to C and I have one card that I filter on the destination B and C to see the percentage of…
-
Manual update and auto update?
Morning, I am looking to move a google sheet into Domo. My question is we have people inputting about 20-30% of the data and the rest is sitting in a couple other data bases within Domo. Is there a way to both update that sheet by tying it together with and ETL from other sheets yet still retain the ability for user to…
-
Most recent event, multiple columns
Hi all. Appreciate all the help in the past. I am trying to get to show on a card the last/most current status of a shipment. I have the columns below. The port columns A,B,C are connected to one source and D,E,F,G are pulling from another source, but are joined into one sheet in Domo. What I am trying to do is find the…
-
Return most recent row/date
Good morning. Been running down the rabbit hole for a day or two on this and trying different solutions from previous Domo questions without much success. I have a sheet that has multiple entries for each equipment number and in the end I would like one row for each piece of equipment that is the most recent EVENTTIME.…
-
Weeks one week different
Afternoon, Working in a data set and I have three dates 10/4/22,10/5/22,10/6/22 and when we build a graph card and set the display to week it is showing these dates as week 41. But these should be week 40, last week. Just to test it we put in todays date of 10/10/22 and it says week 42, which is next week. Seems somehow…
-
Add formula syntax error
Hi all, I am brand new and trying to swim in the deep end and don't have knowledge of SQL so struggling with how to write a case/formula for one of my ETL transformations. I want to create a column with a constant based on values in a column, essentially: If the value of column A equals ONEY or CMDU than 45, if not than 30…