Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Visual Analytics - Comparing lines on table

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 7
Accepted Solution

Visual Analytics - Comparing lines on table

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

 

 


Accepted Solutions
Solution
‎03-07-2018 08:24 AM
Occasional Contributor
Posts: 7

Re: Visual Analytics - Comparing lines on table

Thanks to answer, it works for me!

View solution in original post


All Replies
Super Contributor
Posts: 391

Re: Visual Analytics - Comparing lines on table

Maybe the aggregate function FIRST can help you?

 

image.png

//Fredrik

Occasional Contributor
Posts: 7

Re: Visual Analytics - Comparing lines on table

Thanks to answer!


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

Thanks.
Super Contributor
Posts: 391

Re: Visual Analytics - Comparing lines on table

Hi!

This is an example using sashelp.class:

 

image.png

 

Might help you Smiley Happy

//Fredrik

Solution
‎03-07-2018 08:24 AM
Occasional Contributor
Posts: 7

Re: Visual Analytics - Comparing lines on table

Thanks to answer, it works for me!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 173 views
  • 0 likes
  • 2 in conversation