topic Re: How to show only last month - but give the user the possibility to filter other months in SAS Visual Analytics

How to show only last month - but give the user the possibility to filter other months

Filipvdr — Thu, 11 Jun 2015 14:33:01 GMT

Hello,

I want my DropDownList to show always the latest month by default. But the user should still be able to pick an other month. I don't want to resave my report each month to have the latest month there.

Any tips?

Filip

Re: How to show only last month - but give the user the possibility to filter other months

PeterWijers — Thu, 11 Jun 2015 14:57:10 GMT

Discussed this with SAS Development, during a user meeting 2 weeks ago. Its a new request but not in yet.

The idea is to have it parameter controlled, so a parameter could calculate the defaults for an object. (or two for a slider slider bar) etc.

I also face the same issue to often.

There is the option to make a DropDownList depending on a parameter (to reduce selectable options) but thats not what you expect. (as far as I understand)

So you could automaticaly only have the dates from the actual month present.

Greetings

Re: How to show only last month - but give the user the possibility to filter other months

avvy — Fri, 12 Jun 2015 07:48:05 GMT

Hi,

To get the feel what you want, you have to add one "list object" in obove snapshot of the report.

May be this solution could help you :-

1) Create a calculated Item "Month Number" as" Month(DatePart(calldate))"

2) Create another calculated Item "Present Month Indicator" as :-

IF ( Month Number = Month(DatePart(Now())) )

RETURN 1

ELSE 0

3) Create a Custom Category "Month Name" based on "Month Number" created in step 1 and create 12 labels as jan, feb, mar etc and assign the corresponding values from "Month Number" distinct Values.

Now in the design part of the report :-

a) Add list object and assign the category as "Month Name" that we created in step 3 and apply a advanced filter as "present month indicator <> 0".

b) Uncheck the "Required" in the properties of list object.

c) Now simply give the interaction from "List object" ----> "Drop Down List" and from "Drop Down List"----> "Treemap".

So whenever the month changes, that particular month will be displayed in the list and the drop down list will contain the "calldate" for the same month.

Now if user wants to pick from other month, they can just uncheck the month name in the "List object".

Hope so, this helps you if I understood your requirement correctly.

Regards,

Abhishek

Re: How to show only last month - but give the user the possibility to filter other months

Explore_SAS — Thu, 16 Jul 2015 15:15:23 GMT

make the dropdown as required field and then right click and sort it by descending order.

That should be able to show the latest month on the top.

Thanks

Amol

Re: How to show only last month - but give the user the possibility to filter other months

MirjamvanMoll — Thu, 08 Dec 2016 11:00:14 GMT

Hi Abhishek,

I tried your solution but still have one problem. Maybe you can help me out with this last issue.

I have a "list filter month number1" that is filtered by the present month indicator as you mentioned.

Also this "list filter month number1" filters a second filter "filter month number2". "Filter month number2" filters the object.

The "filter month number 1" does not change immediately into the new month (for example last 1 december) as the present month indicator changes. It still gives the old month (november) and the user has to click the filter to change it into (december).

If the end user still has to click the filter that he/she can also use a 'normal' filter and choose the last month.

How to make sure that the end user does not have to click the first filter?