topic Re: Display all values including repetitive Dimension values in a Scatter Plot? in App Development

Display all values including repetitive Dimension values in a Scatter Plot?

mrthomasshelby — Tue, 25 Apr 2017 10:17:21 GMT

I have a dataset as shown below:

Month Stock Price

2 A 21

2 B 33

2 A 46

2 C 54

2 D 59

2 C 63

2 E 72

I'd like to show these values on a Scatter plot: With Stock as the dimension, Month as the X-axis and Price(without any aggregation) as Y-axis. I've tried this but the Stocks A and C are not being shown in the plot. Is there any way to show A and C, twice in this instant with their different prices in the Scatter plot? If not please suggest a different but similar chart where I can show all the above points.

TIA.

Re: Display all values including repetitive Dimension values in a Scatter Plot?

OmarBenSalem — Tue, 25 Apr 2017 15:47:18 GMT

As dimension:

Stock

As measure:

1) Month

2) =AGGR(NODISTINCT sum(Price),Stock)

result :

Re: Display all values including repetitive Dimension values in a Scatter Plot?

mrthomasshelby — Wed, 26 Apr 2017 06:25:37 GMT

Hello omar bensalem,

Thanks for the reply. But you see I don't want to Sum the Prices. I want to display each and every point in the dataset above. That is I need A to be shown as two points: One point with price 21 and other with 46. Similarly, C should be displayed twice: one point with price 54 and the other with price 63. Is there a way to do so? TIA.

Re: Display all values including repetitive Dimension values in a Scatter Plot?

OmarBenSalem — Wed, 26 Apr 2017 08:19:17 GMT

I don't know how to do that; stalwar1‌? vinieme12‌ ?

Re: Display all values including repetitive Dimension values in a Scatter Plot?

vinieme12 — Wed, 26 Apr 2017 08:49:31 GMT

Group your Data by Stock and the instance of each Price that occurs and use the new Field as Dimension

LOAD *,Stock&'-'&AutoNumber(Stock&Month&Price,Stock) as Stock_New INLINE [

Month,Stock,Price

2,A,21

2,B,33

2,A,46

2,C,54

2,D,59

2,C,63

2,E,72

];

Re: Display all values including repetitive Dimension values in a Scatter Plot?

vinieme12 — Wed, 26 Apr 2017 08:56:10 GMT

Check the attached

Re: Display all values including repetitive Dimension values in a Scatter Plot?

OmarBenSalem — Wed, 26 Apr 2017 08:59:18 GMT

That's brilliant and correct; but suppose we do not have access to the script; and we had to make this directly within the scatter plot? How should we proceed?

Re: Display all values including repetitive Dimension values in a Scatter Plot?

vinieme12 — Wed, 26 Apr 2017 09:06:54 GMT

Don't know, but me let try me a few things and get back

Re: Display all values including repetitive Dimension values in a Scatter Plot?

OmarBenSalem — Wed, 26 Apr 2017 09:18:58 GMT

Is there any way of generating autonumber-like numbers directly within the charts?

The ponly way I could think of is using a dimension like this:

=Stock&'- Month'&Month&' Price :'&Price

Re: Display all values including repetitive Dimension values in a Scatter Plot?

vinieme12 — Wed, 26 Apr 2017 09:25:38 GMT

You can use Rowno()

=AGGR(Stock&'-'&Rowno(),Stock,Month,Price)

Attaching updated app

Re: Display all values including repetitive Dimension values in a Scatter Plot?

mrthomasshelby — Wed, 26 Apr 2017 09:37:05 GMT

This works for me as I can edit the script as needed. Thanks a lot Vinay!

Re: Display all values including repetitive Dimension values in a Scatter Plot?

OmarBenSalem — Wed, 26 Apr 2017 09:37:45 GMT

Great ! Thanks

Re: Display all values including repetitive Dimension values in a Scatter Plot?

mrthomasshelby — Wed, 26 Apr 2017 09:39:10 GMT

Thanks Omar for taking the time. Appreciate it!