topic Re: Visual Analytics - Comparing lines on table in SAS Visual Analytics

Visual Analytics - Comparing lines on table

Rogerio_Alves — Wed, 28 Feb 2018 21:37:07 GMT

Hi, I'm migrating an excel report to SAS Visual Analytics. On the report there is an KPI that is calculated comparing results using the first line as reference:

price diff

10 0

20 10

30 20

The challeng is that there are a lot of filters and this first number will change when the filters are used on report.

Thanks!

Rogério

Re: Visual Analytics - Comparing lines on table

FredrikE — Fri, 02 Mar 2018 08:11:44 GMT

Maybe the aggregate function FIRST can help you?

//Fredrik

Re: Visual Analytics - Comparing lines on table

Rogerio_Alves — Fri, 02 Mar 2018 09:43:55 GMT

Thanks to answer!

Will it running inside of VA? Do you have some example?

Thanks.

Re: Visual Analytics - Comparing lines on table

FredrikE — Fri, 02 Mar 2018 10:57:39 GMT

Hi!

This is an example using sashelp.class:

Might help you 🙂

//Fredrik

Re: Visual Analytics - Comparing lines on table

Rogerio_Alves — Wed, 07 Mar 2018 13:24:39 GMT

Thanks to answer, it works for me!