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

[SomanDavuluri]

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

[TejaSurapaneni]

Hi Soman,

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

[SomanDavuluri]

hi teja

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

rgds

Soman

[SomanDavuluri]

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

[TejaSurapaneni]

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.

[SomanDavuluri]

HI Teja ,

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

rgds

soman

[SomanDavuluri]

Dear All,

Pls awating for help on the  question ..

[TejaSurapaneni]

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.

[SomanDavuluri]

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

[TejaSurapaneni]

hello,

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

Teja Surapaneni.

[SomanDavuluri]

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

[SomanDavuluri]

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

[PeterWijers · Accepted solution]

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

[SomanDavuluri]

Thank U Peter ..

Done with the isuue ..

Rgds

Soman