topic Re: How to work on only today() date for daily reports in SAS Visual Analytics

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

SomanDavuluri — Sat, 12 Dec 2015 03:36:29 GMT

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

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

TejaSurapaneni — Sat, 12 Dec 2015 04:53:28 GMT

Hi Soman,

Usually I use "Date = As on date" in filters...

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

SomanDavuluri — Sat, 12 Dec 2015 05:40:36 GMT

hi teja

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

rgds

Soman

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

SomanDavuluri — Sat, 12 Dec 2015 11:00:07 GMT

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

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

TejaSurapaneni — Sat, 12 Dec 2015 17:21:52 GMT

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.

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

SomanDavuluri — Sun, 13 Dec 2015 12:14:45 GMT

HI Teja ,

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

rgds

soman

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

SomanDavuluri — Mon, 14 Dec 2015 08:39:10 GMT

Dear All,

Pls awating for help on the question ..

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

TejaSurapaneni — Mon, 14 Dec 2015 10:50:28 GMT

Hello Soman,

sorry for the delay Soman...

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.

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):

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

You can refer below example how it looks

2. Object level filter

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.

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

SomanDavuluri — Mon, 14 Dec 2015 11:09:09 GMT

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

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

TejaSurapaneni — Mon, 14 Dec 2015 11:12:26 GMT

hello,

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

Teja Surapaneni.

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

SomanDavuluri — Mon, 14 Dec 2015 15:23:48 GMT

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

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

PeterWijers — Fri, 18 Dec 2015 07:31:04 GMT

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

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

SomanDavuluri — Fri, 18 Dec 2015 08:54:18 GMT

Thank U Peter ..

Done with the isuue ..

Rgds

Soman

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

SomanDavuluri — Fri, 18 Dec 2015 08:55:42 GMT

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