Make a pivotgrid scrollable

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.

 

Unfortunately, this idea has not received enough votes. Because we want to keep the focus on ideas that are in high demand in our Community, we are closing this idea.