BookmarkSubscribeRSS Feed
dstephens22
Obsidian | Level 7

Hi:  I have a report and I am trying to create a dashboard with current month metric and % change from prior month.  I was using the Key Value for a clean look but now I am using a Text box.  

 

The issue seems to be the calc .  I am trying to use the 'treat as' and display the number in the box.  Cabn't seem to get it to work.

Again I would want two metrics:  Current Month voulume and % Change from previous month.  I don't want a list table or cross tab.

 

The other issue is the filters at the top will also cause errors with the metric so I have to somehow disassociate them. 

 

Thanks for any help.

 

Dave

 

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 466 views
  • 0 likes
  • 1 in conversation