Displaying effort per day
My Task Management data contains 1 row per User Story. Each row will contain start date, end date and estimated effort (which will likely be less than the story duration, e.g. Story starts on Monday, ends on Friday and will take 10 hours to complete). A row would look like:
¦ Program ID ¦ Story ID ¦ Start Date ¦ End Date ¦ Total Effort ¦
Each story is associated with a Program, of which there are many.
I wish to visualise the total effort per day for each Program (where Program will be a filter) on a timeline. I cannot conceive of a way to achieve this without transforming my data from one-row-per-Story to multi-row-per-Story, where each row is one day in the life of the story that contains the average, so it looks like this:
¦ Program ID ¦ Story ID ¦ Date Day 1 ¦ Average Daily Effort ¦
¦ Program ID ¦ Story ID ¦ Date Day 2 ¦ Average Daily Effort ¦
¦ Program ID ¦ Story ID ¦ Date Day 3 ¦ Average Daily Effort ¦
and so on.
Can I achieve my goal creating a new dataset?
Answers
-
@harropda - Are you looking for help in creating the new dataset? Or just if anyone has other ideas on how to accomplish this task? From what you have described, creating that new dataset should allow you to create the analysis you are lookin for.
Ultimately, if you want your graph to display daily data, your dataset will need to be set up with 1 row per day. In this case, one row per day for each Story ID as you have described.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive