topic Re: Problem exporting from a line graph to Excel using a date slider as section filter in SAS Visual Analytics

Problem exporting from a line graph to Excel using a date slider as section filter

Frank_Boekamp — Tue, 09 Feb 2016 13:18:44 GMT

Hello,

We got a dataset with multiple datapoints per day, grouped by a category. If we use a date slider with quarter/year range as a section prompt and select a quarter/year as start point and the same quarter/year as an end point then exporting data to Excel from a line graph is resulting in an dataset with only one date (the first date of the selected quarter). Exporting the same data to Excel from a table is resulting in a correct dataset. Exporting data from a linegraph when two consecutively quarters are selected is resulting in a correct dataset.

Are we missing something?

Thanks for your help.

Frank

Re: Problem exporting from a line graph to Excel using a date slider as section filter

Sam_SAS — Tue, 09 Feb 2016 15:24:54 GMT

Hi Frank,

Could you share a screenshot of your line chart and the prompt?

Thanks,

Sam

Re: Problem exporting from a line graph to Excel using a date slider as section filter

Frank_Boekamp — Tue, 09 Feb 2016 15:53:10 GMT

Hi Sam,

Here is a printscreen:

Re: Problem exporting from a line graph to Excel using a date slider as section filter

Sam_SAS — Tue, 09 Feb 2016 16:16:37 GMT

Thanks Frank. I can't seem to replicate the issue you are seeing but there could be a bug.

Out of curiosity, do you get the same issue if you export to a .tsv file or another format?

You might want to contact SAS tech support with this issue. Possibly they could offer a workaround or tell you whether the problem has been fixed in newer release.

Re: Problem exporting from a line graph to Excel using a date slider as section filter

Frank_Boekamp — Wed, 10 Feb 2016 11:01:55 GMT

Hi Sam,

We get the same issue exporting to csv files.

I will contact tech support.

Thanks, Frank