JPinkman Tracker

Re: unexpected behavior year_to_date function?

JPinkman — Thu, 26 Mar 2015 13:09:16 GMT

Thanks!

Unexpecte $hex format assignment

JPinkman — Thu, 26 Mar 2015 12:51:33 GMT

Hi all,

I have a dataset with a seemingly normal string type category in SAS VA (it contains first and last name of employees, separated by a space). Somehow this category is assigned the $hex format. I cannot change it and it makes the category useless in the report since it displays the content in hexadecimal format.

Can anyone share some insights on this?

many thanks!

dual axis line bar chart combined with stacking in stead of clustering

JPinkman — Thu, 19 Mar 2015 18:30:37 GMT

Hi,

normally when I use a regular bar chart I use the 'grouping' option to stack category items. Now I need a dual axis line bar chart . I have created one using the custom chart option, and replaced 'clustering' with ' stacking ' in the bar chart properties. However, when I use this chart in a report, the category cannot be added to a grouping option. Is there another way to do this?

Thanks for your input

Re: How do you use SAS Theme Designer for Visual Analytics? SAS wants to know.

JPinkman — Thu, 19 Feb 2015 11:26:45 GMT

Hi,

We've been trying the theme designer out a few days now and notice a mismatch between the applied theme settings in a report and the theme itself in the theme designer: we keep seeing a red colour in scroll bar and the slider object, even though this colour is not applied anymore in the theme. It was there in a previous deployed version, but not in the latest deployed one.

Also we noticed when applying the custom theme as default theme in sas va preferences, theme settings are visible in current reports, but the theme setting in the report itself is still on 'SAS light'. When manually selecting the custom theme in the report as well, it seems like another subset of the theme settings are in effect.

Is it by design to keep the theme setting to 'SAS light' in the report? It seems confusing. Why is a part of the custom theme settings available via the default theme setting and another part of the same custom theme via the theme selector in the report itself?

unexpected behavior year_to_date function?

JPinkman — Thu, 19 Feb 2015 10:55:48 GMT

Hi all,

Been experimenting with this function a bit on a data set, containinig several rules per date. There's 12 dates per year, one for each month. In the report these lines are aggregated automatically . Somehow the ytd function works as expected for only the first to months of each year.

Does anybody have an idea why this is happening?

Thanks

Re: section link between cross tab and list table

JPinkman — Thu, 19 Feb 2015 10:45:10 GMT

Hi all,

I've discovered the error occurs when adding a column total to the cross tab. Would anyone be interested in trying to reproduce? I'm still waiting for an answer from tech support.

Re: section link between cross tab and list table

JPinkman — Wed, 04 Feb 2015 14:31:31 GMT

Hi,

when I double click values in the cross tab on section 1 the screen turns black with a

Show details button is not responding. I cannot even close the error and continue in sas va. I have to completely restart the website. I guess I will contact the sysadmin first ;-).

By the way: section1 and 2 use different datasets. They were mapped automatically during creation of the section link ..

We are using version 7.1.

Keep you posted. Thanks!

- error has been forwarded to Sas support

section link between cross tab and list table

JPinkman — Wed, 04 Feb 2015 13:18:30 GMT

Hi,

I would like to realise the following:

In section 1 there's a crosstable. This will be filtered by 4 dropdowns, 1 interacting with 2, interacting with 3 ect. The drop downs are in a container in the same section as the crosstable. The filter settings of section 1 also have to apply to the contents in the list table in section 2. Therefore I added an interaction between the cross table and the list table. All fine so far, no errors. The 4 dropdowns filter each other and also the cross tab. However: section 2 is showing no data and I can't find a relevant 'drill down on section link' menu item in the cross tab, like I have found before in other chart types like bar chart etc.

- Am I overlooking something?

- Is what I want possible?

- Should I go about this another way?

THanks!

Re: Custom geography

JPinkman — Mon, 10 Nov 2014 13:08:47 GMT

I think I misunderstood the documentation: first I have to right click the measure I want to display, then choose the custom geograpy option. Now I see both latti and longitude..

Custom geography

JPinkman — Mon, 10 Nov 2014 12:59:53 GMT

Hi, I'm following these instructions:

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n0lwmd82he8anen1qnaudmbkda7y.htm in order to create a custom geography data item.

I have a lattitude and longitude measure in my data set. However, In the selection list I only see 'longitude' and another measure, but not the lattitude. Both Lattitude and longitude have the same data type and other properties, as far as I can see.

What can be the problem?

thanks!

Re: interaction between drop downlists and chart mixing up?

JPinkman — Mon, 27 Oct 2014 14:51:13 GMT

Hi,

I had come to the same conclusion myself already: choose the right year in dropdown(dd) 9. This filters dd10. FIlter the chart with the sector of choice from dd10. This also filters the data for the the year of choice in dd9 indirectly.

Thanks again! Cheers

Re: interaction between drop downlists and chart mixing up?

JPinkman — Mon, 27 Oct 2014 10:13:01 GMT

Hi Michelle,

see below:

What I meant by The end result is that both interactions have the same mapping for either year or sector".

Is that I initially set up both drop downs with separate interactions to 10 eerste onderzoeken, dropdown 9 with a mapping for year category, dropdown10 with sector category mapping (which are the visible values in respective drop downs).

After some testing I notice the interaction works for the year category . But when I also click on dropdown10 to filter sectors, the whole thing gets confused: I notice that drop down 9 is not filtering 10 eerste onderzoeken anymore. When opening the mapping of the interaction I see it's now same as the mapping from drop down10, namely sector category.

Hope this clarifies some!

THanks!

interaction between drop downlists and chart mixing up?

JPinkman — Mon, 27 Oct 2014 09:00:42 GMT

Hi,

I am working on a dashboard (report) that has 2 dropdown filters on the canvas, in order to define an interaction between them. One contains the Year category, the other one organisational structure . Reason is that in 2013 the organisational structure differs form that in 2014. I got this working.

Now I want to define interactions between the 2 drop downs with charts in the reports. I manage to add the interactions, but somehow the mapping settings of both drop downs seem to interact. The end result is that both interactions have the same mapping for either year or sector, resulting in one disfunctional dropdown filter. Both dropdown filters are based on the same data source.

Has anyone experienced this also? Is my construction not feasible? Is there another way?

Many thanks..

PS: using sas va 6.4m