Profile Picture

missing values in XY scatter

Posted By chriz de coster 9 Years Ago
Author
Message
chriz de coster
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 4, Visits: 15
Hi,
I can't seem to plot all my values.
Disabled cluster mode.
Is there another setting/property that limits the number of points?

Regards,
C

Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
Can you provide additional details regarding your problem?


Best Regards,
Nevron Support Team



chriz de coster
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 4, Visits: 15
My dataset returns almost 2000 rows.
A Microsoft scatter chart plots all those 2000 values.

The Nevron XY scatterchart just plots 30?

Chart Area: Sub Type: XY Scatter
Cluster Mode: Disabled

1 Value field: Y= Fields!Measure.Value, X= Fileds.Age.Value
1 Category field: Group By: Fields!Age.Value
           

See screenshot below, both charts side by side and based on the same dataset. Right is default SSRS scatter chart.
https://www.nevron.com/forum/uploads/images/9156d6fa-6190-4ab2-a88e-e6ad.png


Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
It looks like you are missing something in the configuration of the XY scatter chart.
Can you please send us your sample data (in Excel spreadsheet) and possibly the current RDL for review?


Best Regards,
Nevron Support Team



chriz de coster
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 4, Visits: 15
Hi Support Team,

Please find attached a zipped .RDL file. 
I scripted the data to be inserted in a table variable, so no need to import CSV.

I suspect indeed a configuration issue.

Thanx in advance.
Tips on adding a trendline are welcome as well :-)

Chriz

Attachments
Scatter_POC1.zip (635 views, 12.00 KB)
Nevron Support
This post has been flagged as an answer
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
Hi Chriz,
What you are missing in the Nevron Chart (compared to the ms chart) is the Series grouping:
=Fields!Measure.Value

Also, in order to replicate the ms chart and add the "Trend" series, you need to switch the chart to Combo -> XY Scatter
Your first series should be Point and the second one Line.

You can review the modified RDL and let us know if you have any questions.


Best Regards,
Nevron Support Team



Attachments
Scatter_POC1.zip (610 views, 11.00 KB)
chriz de coster
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 4, Visits: 15
This is indeed the solution.
Not very straightforward though. One would expect that series are used to contain groups in the dataset, nevermind.

But performance wise it is not an improvement.
Average response from the SSRS component is 1,5 seconds, your Nevron component takes about 22 seconds.
Can we speed this up?






Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
Hi Chriz,
There are a number of properties that you can use to fine-tune the performance of the control.
You can also turn on Statistics in order to review what takes most time. Our test shows about 2 seconds in total.

Please, take a look at the updated RDL sample and let us know if you have any questions.


Best Regards,
Nevron Support Team



Attachments
Scatter_POC1.zip (672 views, 13.00 KB)


Similar Topics


Reading This Topic