We have a 2dline chart (see below) that shows values in time. The chart shows a subset of the values in the pivot table (around 1000 rows?).
Is this a known limit? Is there a way to scroll in time?
Make a pivotgrid scrollable
Software Factory
Web and Windows GUI
Universal GUI
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Hi Andre,
Have you perhaps set the maximum number of records for the subject?
Hi@Jasper ,
The max_no_of_records is null for table and variants.
Can you share the query from the debug screen that is used to fetch the data for the chart?
This is the query from the debug screen.
select t1.[measurement_id], t1.[measurement_parameter_product_id], t1.[measurement_parameter_product_instance_id], t1.[type_of_measurement_id], t1.[production_order], t1.[product], t1.[product_type], t1.[product_type_sub], t1.[serial_number], t1.[measuring_device], t1.[type_of_measurement], t1.[measurement_date_time], t1.[production_order_no], t1.[product_code], t1.[measured_parameter], t1.[minimum_value], t1.[maximum_value], t1.[nominal_value], t1.[measured_value_numeric], t1.[nominal_deviation], t1.[minimum_tolerance], t1.[maximum_tolerance], t1.[type_of_tolerance], t1.[nominal_deviation_alfanumeric], t1.[nominal_deviation_alfanumeric_2d], t1.[device_no], t1.[active_ind], t1.[sequence_number], t1.[measurement_sequence_number], t1.[last_measurement_ind]
from [vw_measurement_cube] as t1
where (t1.[measurement_parameter_product_id] = 472)
and (t1.[last_measurement_ind] = 1 and t1.[active_ind] = 1)
and ((t1.measurement_date_time > dateadd(week, -coalesce(dbo.get_session_process_stream_value('measurement', 'number_of_weeks'), 26), getdate())
) )
The number of weeks is an session variable that can be changed using a task.
The chart is showing dates from 22-11-2022 to 5-1-2023. First date is 23-11-2022.
The cube contains dates from 23-11-2022 to 3-4-2023
It is a lot of detail information to show (measurements in time), but I would expect to have the possibility to show all values (scroll?).
Hi Andre,
Indeed, there seems to be a maximum of 1000 visible data points.
I have created a ticket to investigate this, including the possibility to scroll horizontally: 6610S
Hello André,
In our next windows gui, the 1000 max visible data points limit has been removed. It is now unlimited.
This release is scheduled at the second of May.
That's nice Edo!
Will it also be scrollable?
Hello André,
Unfortunately no, Making the max visiable datasource unlimited was quite easy, however making it scrollable isn't.
Also we see a scrollable pivotgrid more as a wish, so i will try to change this question to a wish.