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

How to work on only today() date for daily reports

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

How to work on only today() date for daily reports

Hi friends .

 

I have query , request help .

 

I need to prepare a report which only shows data of the current day .. i. e

 

Suppose today is 12/12/2015 my report should show only show today's sales data like that , the report has to be giving the data for the current day going forward ,which formula needs to be worked on to achive this on daily basis instead of filtering the report daily.

 

Regds

Soman

 

 


Accepted Solutions
Solution
‎12-18-2015 03:53 AM
Regular Contributor
Posts: 172

Re: How to work on only today() date for daily reports

Hi Soman,

please consider using a data querry with the date filter of today, running every morning in job.

this way, the data read into lasr memory only consists of the data of today, so you do not need to worry about any further report filtering.

greetings Peter

View solution in original post


All Replies
Regular Contributor
Posts: 196

Re: How to work on only today() date for daily reports

Hi Soman,

Usually I use "Date = As on date" in filters...
Contributor
Posts: 41

Re: How to work on only today() date for daily reports

hi teja

 

can u gude me in detail step by step , as iam not able to get u

 

rgds

Soman

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

Hi Teja ,

 

And also i think  date= as on , gives the total till that particular day , where as iam looking only for the single day .

 

example ,

 sales report for 12/12/15

brush - 2

paste-1

comb-0

sales report for 13/12/15

brush - 6

paste-0

comb-3

 

like iam looking for a single day report which will be generated daily .. for this how can i use the filters.

 

pls guide me

 

rgds

soman

 

 

 

Regular Contributor
Posts: 196

Re: How to work on only today() date for daily reports

[ Edited ]

Hello Soman,
No it gives or shows only as on date values...

Can u share historic to as on date sample r dummy data...


Thanks & Regards,
Teja Surapaneni.

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

HI Teja ,

 

Can u pls guide me step by step to work on date = asondate

 

 

rgds

soman

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

Dear All,

 

Pls awating for help on the  question ..

Regular Contributor
Posts: 196

Re: How to work on only today() date for daily reports

Hello Soman,

sorry for the delay Soman...Man Sad

 

Let's take one example:

 

Date                 Sales

10/12/15            200

11/12/15            150

12/12/15            300

13/12/15              0

14/12/15            100

 

You want only latest Date(As on date) value(100).

is it correct ?

 

If yes.., Create as on date (System date) using calculated item.

 

Date part.png

You can achieve in two different ways.

1. Creating new calculated item.

2. using object level filters.

 

1. Creating new calculated item (As on Date Value):

 

AS ON VALUE.png

from the above you can create new column with as on date values.

You can refer below example how it looks

Ex.png 

 

2. Object level filter

3.png

 

Hope this will help....

 

please let me know..

 

It will work when your data will have as on date (14/12/15).

if your data latest date is (12/12/15). the above examples will not work.

So it's Better to create Max Date column in backend data.

 

Thanks & Regards,

Teja Surapaneni.

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

HI Teja

 

Date                 Sales

10/12/15            200

11/12/15            150

12/12/15            300

13/12/15              0

14/12/15            100

 

as per the above expample , i need to make automated reports which will be scheduled for each day .

 one report will shoot on 10/12/15 , showing the sale of 200

next morning second report 11/12/2015 will shoot showing the sale of 150 in this way..

 

rgds

soman

 

Regular Contributor
Posts: 196

Re: How to work on only today() date for daily reports

hello,

 

Can you share what is the latest date in your data.

 

 

Teja Surapaneni.

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

Hi Teja ,

 

I really thank u for trying to help me . i will try to explain u in detail

 I have data set which gets updated daily of the sales hapening in the company. i have to now send a daily sales report of the sale updated in the dataset through SAS VA.

so today that 14/12/2015 my system is showing the below sales

item                      qty

tooth brush -         1

paste          -          0

soap          -          1

pen           -           3

 

So i have to publish this report tommrow morning projecting tha sales of 14/12/2015

 

in the same way i have publish reports everyday i.e 15/15/2015 , 16/12/2015 , i have write a code where system picks data for the single day.

 

rgds

soman

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

Hi Teja ,

 

Thank u very much for u r support on the issue i have raised , have worked out on IF then else to stick on to the fixed date .

 

Rgds

Soman

Solution
‎12-18-2015 03:53 AM
Regular Contributor
Posts: 172

Re: How to work on only today() date for daily reports

Hi Soman,

please consider using a data querry with the date filter of today, running every morning in job.

this way, the data read into lasr memory only consists of the data of today, so you do not need to worry about any further report filtering.

greetings Peter

Contributor
Posts: 41

Re: How to work on only today() date for daily reports

Thank U Peter ..

 

Done with the isuue ..

 

 

Rgds

Soman

Post a Question
Discussion Stats
  • 13 replies
  • 766 views
  • 0 likes
  • 3 in conversation