BookmarkSubscribeRSS Feed
Filipvdr
Pyrite | Level 9

Hello,

In my dataset i've got a date field which represents the date of the ticket.

I want to show on top the max date, so the users will know which was the last refresh date.

Any suggestions?

I tried with a stored process, and this works, but when printing the report in PDF, it uses a whole page for the stored process.

Filip

5 REPLIES 5
MichelleHomes
Meteorite | Level 14

Hi Filip,

If you are using SAS Visual Analytics 7.1, have you tried to create a parameter and use this?

You may find this blog post useful to see how parameters can be used - http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics/

Also there has been some other posts on parameters you may find helpful such as https://communities.sas.com/thread/63739 You may find other posts if you search within the Visual Analytics community.

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
Filipvdr
Pyrite | Level 9

Hello Michelle,

Thanks for the reply, but I can't really see how this can be usefull.

I'm using 7.1 and i'm trying to send a summary report by mail. But i want it to include the last refresh date. So no user interaction is possible.

When i select a parameter, i can only select char, or numeric. No dates.

Filip

MichelleHomes
Meteorite | Level 14

Hi Filip,

Yes parameters cannot be dates. I was thinking you could use functions to convert it to a string so that it is a formatted date as a character. Then you could use it in a text input control box with no interaction so that the date appears in the box. I'm not sure whether a parameter can be within a text object so this is an alternative.

Let us know how you go.

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
Filipvdr
Pyrite | Level 9

Hello,

Thanks for the input. I have created a small table with 2 fields: tablename, and last update date. I'm also using this table now to send if the job did run correct or not.

I loaded this into VA and i used a list table to display the last date.

Filip

BO1
Fluorite | Level 6 BO1
Fluorite | Level 6

Hi Filip,

 

I think I have more or less the same requirement as you had and I am hoping you can share some information with me 🙂

 

We have scheduled around 25 Teradata tables to be loaded into the LASR Server on a daily basis. Now my requirement is to create a Monitoring Dashboard where the Service Desk can see whether the data sources are loaded. Therefore I want to output the MAX Timestamp of every SAS Data Source.

 

Would you be so kind to elaborate on your solution? Where did you create that small table? Is the information in that table coming from SAS or from your DBMS?

 

Thank you in advance.

 

Regards Bart

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 5 replies
  • 2418 views
  • 1 like
  • 3 in conversation