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

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 328 views
  • 0 likes
  • 1 in conversation