SAS Visual Analytics Schedule Chart error

[mm84]

Hi community,

I have problems trying to show data in a Schedule Chart in SAS Visual Analytics. My dataset has data simmilar to the following:

PROC SQL;
CREATE TABLE WORK.MYDATA
(Project char(10), 
 Dataset char(10),
 StartDateProject datetime format=datetime18. ,
 EndDateProject datetime format=datetime18.
);


INSERT INTO WORK.MYDATA
VALUES('Project1', 'Dataset1', "26jul2019:08:10:20"dt, "26jul2019:08:10:50"dt) 
VALUES('Project1', 'Dataset2', "26jul2019:08:10:20"dt, "26jul2019:08:10:50"dt) 
VALUES('Project2', 'Dataset1', "26jul2019:10:10:67"dt, "26jul2019:12:10:50"dt)
VALUES('Project2', 'Dataset1', "26jul2019:10:10:67"dt, "26jul2019:12:10:50"dt)
VALUES('Project2', 'Dataset1', "26jul2019:10:10:67"dt, "26jul2019:12:10:50"dt); 

QUIT;

 In SAS Visual Analytics I have an Schedule Chart where I want to show Projects and its Start and Finish DateTime.

However it does not show anything because it says there si too much data to show.

I assing Project to Task, and Start/EndDateProject to Start and Finish fields.

Can anyone tell me what am I doing wrong?

Thanks,

[Madelyn_SAS · Accepted solution]

In SAS Visual Analytics on SAS Viya, the limit for Schedule Charts is 3,000 result rows, which are the rows returned from the query itself. Could your actual data be exceeding that limit? You could apply a filter, maybe a slider, and keep adjusting to see if results show up. Depending on your release, you might have an Override system limit option for the object.

[mm84]

Hi @Madelyn_SAS ,

Thanks for your answer. In effect, my dataset has more than 3000 rows, however I thougth that this chart will group the values, taking into account that the selected task si the column Project that only has 8 different values.

[Madelyn_SAS]

The limit is on the number of unique rows returned from the query and not data that will actually be visualized in the chart.