Create a helper column to combine data

New to this :-)
My data consists of two things, created date and closed date.
I received 45 tickets for week commencing 05/26 and closed 68 tickets for the same week.
The tickets received were created same week however the closed tickets are combination of tickets created same week and in the past (backlogs).
When I create a visualization (group column chart), I can't find the right way to combine this numbers.
When I use created date as a category, it will only show the numbers created and closed for that week
When I use close date as a category, it will also show incorrect numbers.
The only solution I can think of is to create a helper column to combine this data
Any suggestions?
Best Answer
-
@Mojoe - @GrantSmith has a great answer to this question. You can check that out here.
Another potential option that won't require you to restructure your data, is to just use 2 cards, one for open, and one for closed.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Answers
-
@Mojoe - @GrantSmith has a great answer to this question. You can check that out here.
Another potential option that won't require you to restructure your data, is to just use 2 cards, one for open, and one for closed.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive