mjaitly Tracker

Range Slider Date Help

mjaitly — Fri, 21 Nov 2014 07:30:13 GMT

Is there any way the range slider date control can get automatically refreshed. We update data daily for the previous day. So supposed I view my report today, I have to manually click on the range slider (the small clock icon) and choose the rigth hand side date as 20th Nov. I save the report. When tomorrow I login, again I have to choose the right hand side clock date as 21st Nov. I want this to happen automatically. In other words as soon as the data is refreshed and I log into the report I should see the end date (meaning the right hand side clock date) as 21st Nov, instead of having to manually choose it.

Thanks

Manish

Re: Rolling Dates

mjaitly — Fri, 21 Nov 2014 06:15:54 GMT

Peter

Can you put up the written code instead of the visual. I am a little confused about the betweeninclusive..where to put exactly?

Thanks

Manish

Re: Rolling Dates

mjaitly — Fri, 21 Nov 2014 05:39:18 GMT

Hi Peter

Belated thanks for sharing this however when I give the below formula it does not work or in other words dates do not roll..they freeze. My idea is to set dates rolling for the last 7 days in my daily report. However when I logged in today the data still shows from 14th Nov to 18th Nov. Genration_Date is a field in the LASR table and is the date of transaction. In my daily report I want to see by default (that is when I log in every morning) data only for the last 7 days but the below formula in a calculated item does not work.

IF ( DayOfMonth('Generation_Date'n) >= ( DayOfMonth(DatePart(Now())) - 7 ) )

RETURN 1

ELSE 0

Please let me know what is wrong with this.

Thanks

Manish

Re: Rolling Dates

mjaitly — Thu, 30 Oct 2014 07:17:33 GMT

No not yet. I will need the code in the calculated field. By default I need the last 7 days or months from Jan'14 however if the user wants he should be able to choose the dates from the range slider control.

Re: Rolling Dates

mjaitly — Thu, 30 Oct 2014 07:01:45 GMT

Hi Peter

Thanks for your reply. Can you please let me know the code if possible? I am tied up real ad with several reports so am not really having the time to experiment.

Thanks

Manish

Rolling Dates

mjaitly — Tue, 14 Oct 2014 07:01:35 GMT

I need some help with dates. I have put up the range slider date controls however I want it in a way such that whenever I open the report, it should automatically show me the data for the last 7days or for last 7 months (in monthly reports). Can anyone let me know the code for this? Also is there any other alternative for date controls other than the range slider (I feel it occupies too much space).

Thanks

Manish.

Conditional formatting on Cross Tab

mjaitly — Wed, 10 Sep 2014 07:51:35 GMT

Please see the attached snapshot. I need to do conditional formatting (display rules) on the fields In_time, Out_time and login hours. I cannot convert them to numeric as there are other problems occuring then. Cross Tab report does not allow display rules on category variables but only on numeric.

Thanks

Manish

Tranwrd function

mjaitly — Mon, 01 Sep 2014 06:47:27 GMT

I need to remove [" from the word say ["Mumbai"]. I am able to remove the [ and ] using functions like Tranwrd however I want to know how to remove the " as the function syntax itself has an opening " and a closing " and I am unable to remove the " (which is itself a part of the input). SAS does not seem to be accepting the " within the opening " and closing ". I will appreciate any help.

Thanks

Manish

Need urgent help with EG

mjaitly — Tue, 13 May 2014 00:38:37 GMT

Need some urgent help in EG.

I wish to send automated email reports (with excel attachment) to our top 200 customers - report will have data such as their last purchase date, amount, etc. I have a dataset that consists of data related to these top 200 customers. I want to make a program that loops through every record (one record for every customer) in the dataset, creates a list report in EG, and then pastes that list report in Excel and send it through email (outlook) to the customer. This entire process should be automated in EG. I know Base SAS language but do not know Macro programming. Can anyone please help me?

It will be great if someone can help me with the code.

Thanks

Manish

Adjusting Screen Resolutions

mjaitly — Tue, 29 Apr 2014 05:57:29 GMT

Is there any way SAS VA can automatically adjust to the user's screen resolutions. I have made the reports in my laptop with a screen resolution of 1600 * 800 and the reports are working fine. However, some parts of the screen appear hidden/do not appear properly in the screens of some users that have a lower resolution system (that cannot be increased to 1600*800). For some users, it works fine. I cannot keep changing the reports.... Is there any solution in VA whereby it automatically takes the screen resolution into account and displays the reports correctly.

Thanks

Manish

Re: Help Needed on MTD Aggregate Measure

mjaitly — Thu, 24 Apr 2014 05:42:43 GMT

Thanks a ton Peter!

Re: Help Needed on MTD Aggregate Measure

mjaitly — Thu, 24 Apr 2014 02:07:58 GMT

Peter

Thanks for your reply. It will be great if you show me a sample formula.

Thanks

Manish

Help Needed on MTD Aggregate Measure

mjaitly — Wed, 23 Apr 2014 07:41:52 GMT

I need some urgent help on an aggregate measure. I have an MTD report that shows data like 1st to 22nd April, 1st to 22nd March, 1st to 22nd Feb, 1st to 22nd Jan and likewise. It is an MTD like-for-like period monthly comparison report. In my company we upload data daily for the previous day. Please see the attached screenshot. In this aggregated measure, I want to know how instead of manually changing the date every day, I can set the date formula so that it automatically considers yesterday's date.

PS - There is another option in the field and that is TODAY however if I choose this option, figures will not appear correctly as for April (assuming I run the report today 23rd April) it will show data from 1st to 22nd April (as mentioned above we have data till yesterday 22nd april in our servers) but for Mar and preceding months, it will show from 1st to 23rd instead of 1st to 22nd.

Please...any help will be appreciated.

Thanks

Manish

Re: Display Rules and Alerts

mjaitly — Tue, 01 Apr 2014 14:10:03 GMT

Thanks Renato for your reply. I will try out your suggested solution and will let you know!

Passing Parameters Possible in VA?

mjaitly — Tue, 01 Apr 2014 14:07:20 GMT

I have a report in which I have names of customers and I DO NOT want to show their contact numbers together. I want that the user should click on the agent name and another smaller link report should appear that should show me the contact number of only that customer. Is it possible in the current version of SAS VA (I am using 6.3 and will install the version 7 when it arrives). What I am hinting is at a parameter pass through mechanism or any other solution that can be worked out.

Thanks

Manish

Re: Reports and Permissions

mjaitly — Tue, 01 Apr 2014 13:54:41 GMT

Thanks to both David and Michelle for the answers. I will have more questions on this topic though!

Display Rules and Alerts

mjaitly — Sun, 23 Mar 2014 13:11:33 GMT

I am tracking sales of different states in India and User_State is a column. I want to know if it is possible to state a different display rule for every state. Sales targets are different for different states so I cannot make one report level display rule for all the states. Same question for alerts. If sales on a particular day fall below a certain level, the state head must receive an alert. As targets are different for every state, I cannot make one alert for all states.

Column Displays and arrangements

mjaitly — Sun, 23 Mar 2014 03:36:36 GMT

I want to display the KPI's in my report in a manner that the same KPI for different months appear adjacent to each other. So If I have two KPI's says Sales, User Count, I want two groups, Sales (that will show Sales in columns for Jan, Feb, Mar,etc.) and another group User Count that will show this metric for Jan, Feb, Mar....in a continuous manner. This type of arrangement is possible in Excel Pivot tables but I am not sure about SAS VA. As of now, I show data like for Jan and under this Sales, User Count adjacent to each other and then again for Feb with the same kind of arrangement and so on. This kind of arrangement makes it difficult to "trend read' a metric over a period of time especially if there are many metrics. I would like each metric to appear together for all months.

Also, is it possible to give a distinct background color to every column (read metric) in the report.

Thanks

Manish

Reports and Permissions

mjaitly — Sun, 23 Mar 2014 03:15:59 GMT

I have implemented SAS VA in my organization. I want to know that if I have a report with multiple tabs (sections), can I give tab based permissions for user access? If out of say 8 tabs, I want a person to be able to view only 3 tabs, is there any way I can do this?

Regards

Manish