Dear Metabase User,
I am struggling to find an visual answer to the question: how COVID pandemic affected total sum of transactions performed by each client in the dataset?
In the Transactions table I have:
| transaction_timestamp | amount | client_name |
| 2020-01-01 08:00:00 | 5.95 | Apple |
| 2020-01-01 08:05:00 | 0.75 | Google |
| 2020-02-01 08:15:00 | 4.25 | Apple |
(continues for ca 100 clients and 10 months of 2020)
I want to:
- know how much each client spent per month
- plot all clients into one chart (X=Months, Y=Sum_of_Amounts), so one line represents one client, and I can see the trend (growing or declining or staying same).
I assume I need a Line chart, but I can’t construct it using the GUI. In fact, I’d like to get something similar to this chart (https://www.metabase.com/docs/latest/users-guide/images/visualizations/area.png) but using lines, not areas.
I will have ca 100 lines, so probably I will add a filter to bin clients into segments by consumption, or any other criteria I may have.
Please help how to build it. Thank you!