We would like to use a scatterplot for displaying
unit prices /
year_month /
sales order like the image shown below:

Does anyone have experience in using scatterplot in Targit for a similar chart? - And how have you solved the issue with scatterplot needing two calculated fields (I would like to have year_month "YYYYMM" on my X-Axis)?
In Excel there is a limit of 255 occurrences in data, does Targit have a similar limit?
And if I use YYYYMM as a parameter I can see some challenges if I want to display more years at once e.g. 201612 .... 201701 - that will return 89 "periods" with no information (201613....)
I have tried to use a normal line chart just showing points, but there I reach a limit of 1.000 occurrences. And my Targit freezes if I select much more data.
Thank you in advance:-)
Edited by user Tuesday, September 5, 2017 2:02:47 PM(UTC)
| Reason: Not specified