Community Forums
Community Forums
TMonty0319 Member
Overview
| Roles | Member |
|---|---|
| Badges | 2 |
About Me
| Geographic location | Boston |
|---|---|
| Country | United States |
Analytics
46
125
9
Reactions
Discussions
- I have data with Plants and Assets. I need to transform so i have data in each row and not multiple assets separated by commas in each row. How do I do this in Domo? Current Structure Plant Asset Shut…
- How do i do a beast mode formula to get the response value of a record that was completed most recently? If this is my data i want to just take the bottom row. My groupings cant be changed in magic et…
- Hi. I have minute level data i am dealing with. I am trying to get total minutes that a post is open during a day. It can be post 1, post 2, or no activity. I am grouping by Date (Day) and Post then d…
- I am trying to do an a calculation and having some trouble. The formula in my Average Daily Usage column is (Oil Usage / Run TIme Hours) * 24 I guess the formula is technically working when look at co…
- I have a column with different assets Tank 1 Engine 1 Engine 2 Tank 2 Tank 3 Engine 4 My question is I just want to take out the number from each and put in new column so can sort by just the number i…
- Hi, I need to create a Dashboard that calculates oil usage for Engines. Below is the excel table with calculation I need to recreate in Domo. Basically need to take the tank level and oil added to day…
- I need a beast mode so i can sort a column. I need to take the number out of this Engine column so then can sort in order. I have values like this Engine 1 Engine 2 Plant Engine 1 Engine 3 Plant Engin…
- Hi. I have data with Plants and Tasks and whether the tasks are complete are not. I need a formula so I can have a percent completed for each plant based on the number of Yes tasks they have compared …
- I am having a problem with a formula. I am trying to display Yes for a facility if they have a task event status in Completed or CompleteLate status. If they have a task in any other task event status…
- I have data with plants and tasks. Each plant has a few daily tasks assigned to them. If the status of a task is complete or completelate the task complete column needs to be yes. If it is any other s…
- I need to modify a formula. CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END I have plants with event status. Each plant can have 1-4 tasks to compl…
- I have dataset i am trying to reformat using a pivot table. I cant use the pivot chart because it only shows measures as values so i am trying to reorganize my data using pivot in etl. My data include…
- I am doing a group by tile in magic etl. i have different values for different ID's and need to sum up all the values in each ID. For some reason some of the ID's are not summing and I get null in col…
- Im trying to do a group by to get a new column with total sum of charges by bill ID. I want the total sum to be constant all for every day associated with Bill ID. When I do a group by I am not gettin…
- Im doing a join on billing ID's. Each billing ID has a start date and an end date. Im trying to return all dates between start and end date for each billing ID. I tried adding this formula to join. dt…
- I need a formula for taking just the month name from this format - Thu, 29 Feb 2024 11:59 PM. I need it in a date formatted column though. I can take the Month Name using MONTHNAME('my date column') b…
- What could be issue with me being unable to save a view? I know it's not permission or browser related
- I am trying to create a card that shows a burndown representation of my data. My data has to do with Courses, estimated time to Complete (Duration), and Actual Hours to complete. I think to create a b…
- I have a column with tasks and there are certain tasks I want to see if the current day is a weekday and if the current day is a weekend day id like to see other tasks. Could someone help me with this…
- Need a date format formula to take this date from 24-hour format to 12-hour format so my date and time goes from 11/02/2023 15:53 PM to 11/02/2023 3:53 PM. Thanks
- I have data that has reporting data for every day. I need help creating a quick filter on dashboard when i select it and see last 7 days
- Has anyone ever had issue with months not being in right order on X axis in bar chart? I created a custom formula just so I could Order in my card but for some reason March is showing after November o…
- I am trying to merge two sources in domo. I want the last part of email to be all lowercase. In one source some of the emails are name@TechCompany. I want everything after the @ to be techcompany and …
- Hi, I need to do a calculation so I can subtract previous months hours (4/31/2023) data from this month's hours (5/31/2023) data. This is how data is organized. This just a small example of how it is.…
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In
