Creating a running percentage chart

KieranVinomofo
Member
in Archive
Hi All
I have a dataset, which is broken up into 4 populations (which is my series). I am trying to create a chart (or table) that shows the percentage of each population that had made their first purchase by a given day after signing up as a member (ie- % that bought for the first time by day one, then cumulative percentage that had bought by day 2, day 3) until eventually at some point each population would be showing 100%.
I'm trying to manipulate a Running Total Line chart to make it a running percentage, but I'm having no luck. Can anyone suggest another way to approach this?
My data is set out as follows:
Customer ID | Days to Convert | Population |
1 | 1 | Prior Year |
2 | 1 | Group 1 |
3 | 5 | Group 2 |
4 | 6 | Group 3 |
5 | 2 | Prior Year |
6 | 2 | Group 1 |
7 | 2 | Group 2 |
8 | 4 | Group 3 |
9 | 3 | Prior Year |
10 | 10 | Group 1 |
11 | 5 | Group 2 |
12 | 13 | Group 3 |
13 | 4 | Prior Year |
14 | 8 | Group 1 |
15 | 9 | Group 2 |
16 | 16 | Group 3 |
Any guidance would be appreciated.
Thanks
0
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0
This discussion has been closed.
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 74 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive