Scatterplot over time

[JMelo]

Hi,

on this example i have 3 producs with different prices each.

Could anyone give me a hint?

Lets say:

Jan

Product 1 - $100 

Produc 2 - $200

Produc 3 - $300

Feb

Product 1 - $50

Produc 2 - $55

Produc 3 - $60

I need to plot a scatterplot time over month, without summarize Producs. I want to see Product 1, 2, and 3 distribuited in that month

Example:

[jthomson]

Should be trivial to convert a data set in order to give you what you want, but without knowing what your data actually looks like it's hard to suggest how to do it

[JMelo]

Month	Product	Price
Jan-19	Shirt	167
Jan-19	Jeans	229
Jan-19	Shorts	201
Feb-19	Shirt	105
Feb-19	Jeans	205
Feb-19	Shorts	196
Mar-19	Shirt	213
Mar-19	Jeans	209
Mar-19	Shorts	163
Apr-19	Shirt	236
Apr-19	Jeans	55
Apr-19	Shorts	200
May-19	Shirt	205
May-19	Jeans	120
May-19	Shorts	121
Jun-19	Shirt	250
Jun-19	Jeans	246
Jun-19	Shorts	72

Thanks,

this is the dataset, would it help?

[jthomson · Accepted solution]

You don't need to do anything with it then, just drop the fields into the scatter plot...