May 16 2023 09:05 PM
Hi! I’m trying to chart scatter the following info: x val (volume) y val (unit price) over time (quarterly). The aim is to visualize the scatter of achieved volume @ x unit price per Q
May 17 2023 01:24 AM
Please provide more detailed information, preferably with an example of what the data look like and what you would like the result to be.
May 17 2023 12:24 PM
@HansVogelaar Sure!
Product | Volume | $ per unit | Q |
A | 100 | $ 15.00 | Q1 22 |
B | 150 | $ 13.50 | Q1 22 |
C | 190 | $ 18.00 | Q1 22 |
A | 120 | $ 14.00 | Q2 22 |
B | 130 | $ 13.50 | Q2 22 |
C | 180 | $ 18.00 | Q2 22 |
A | 140 | $ 14.00 | Q3 22 |
B | 130 | $ 13.50 | Q3 22 |
C | 200 | $ 16.50 | Q3 22 |
A | 135 | $ 15.00 | Q4 22 |
B | 135 | $ 13.00 | Q4 22 |
C | 190 | $ 17.00 | Q4 22 |
A | 120 | $ 18.00 | Q1 23 |
B | 160 | $ 15.50 | Q1 23 |
C | 210 | $ 19.50 | Q1 23 |