topic Re: How to present different time dimension in one Graph in SAS Visual Analytics

How to present different time dimension in one Graph

fj181 — Thu, 18 Feb 2021 11:59:52 GMT

Hi all,

I have a request to present a Line Char with different time dimensions, and give the possibility to user to choose between them.

Anyone have any suggestion?

I try to create a custom graph with two line charts, with one share role to measure between them, and category role independent.

And my intend is to filter the graph just showing one time dimension when the user choose between dimension.

I tried to use a if then statement with a parameter but VA did't accept variable in date format.

Thanks in advance,

Kind Regards,

Re: How to present different time dimension in one Graph

Sam_SAS — Wed, 24 Feb 2021 14:37:00 GMT

Hello,

I am able to get this working on a VA 8.5 deployment using the same approach you are using.

My expression looks like this:

When you created your parameter, did you select the Multiple values box?

Also, try changing the list control in your report to a button bar or drop-down list.

Sam

Re: How to present different time dimension in one Graph

FredrikE — Thu, 25 Feb 2021 15:49:53 GMT

I think the date format is the problem.
Is it possible to create two text objects containing day/week and then use them and the format string?
//Fredrik

Re: How to present different time dimension in one Graph

fj181 — Wed, 03 Mar 2021 22:14:18 GMT

Hi Sam,

I tried what u said and still could't make it. 😞

I'm working with VA 7.5.

Re: How to present different time dimension in one Graph

fj181 — Wed, 03 Mar 2021 22:18:47 GMT

Hi Fredrik,

I had the same thought the error pointed out to date format 😞

Can you explain me your idea?
"Is it possible to create two text objects containing day/week and then use them and the format string?"

Thanks in advance

Re: How to present different time dimension in one Graph

Sam_SAS — Wed, 03 Mar 2021 22:28:49 GMT

I was able to get the same expression working on a 7.5 deployment. Maybe Fredrik is right about the date format being an issue? To troubleshoot, you might want to try using some different data.

Sam

Re: How to present different time dimension in one Graph

FredrikE — Fri, 09 Apr 2021 14:25:11 GMT

Sorry for late answer, you might already found a fix, but anyways:

Create a textvariable for weekday:

IF ( DayOfWeek('date'n) = 1 )
RETURN 'Sunday'
ELSE (
IF ( DayOfWeek('date'n) = 2 )
RETURN 'Monday'
ELSE (
IF ( DayOfWeek('date'n) = 3 )
RETURN 'Tuesday'
ELSE (
IF ( DayOfWeek('date'n) = 4 )
RETURN 'Wednesday'
ELSE (
IF ( DayOfWeek('date'n) = 5 )
RETURN 'Thursday'
ELSE (
IF ( DayOfWeek('date'n) = 6 )
RETURN 'Friday'
ELSE 'Saturday' ) ) ) ) )

and one for date:

Format('date'n[Raw], 'YYMMDD8.')

And use them instead of the date variables, should work 🙂

//Fredrik