About blewsas

blewsas · ‎06-03-2022

I have a parameter called "Days". When I use Text Input control to set its value, it works properly: However, if I switch to a slider control, the slider shows "16" as the value, even though the parameter is set to 1: Any ideas why? Thanks! Barry Lewis

blewsas · ‎06-09-2020

Hi Petri, I'm using SAS v8.3. I have a simple aggregation that looks like this: But when I try to use Advanced Edit to create a filter for it, it is greyed out. The only thing I can think of which might be causing this is that I created my aggregated measure from an aggregated data source. Can you try to create an aggregated data source from your list table, and then try to create an Advanced filter using the aggregated data source? Thanks, Barry

blewsas · ‎06-08-2020

Did you ever get an answer to your question? I am having the same problem 🙂

blewsas · ‎05-25-2020

Thanks @PetriRoine, Thanks for your reply. I thought about that approach too, but it doesn't seem to work. 😕 Here are my data items after I created the "Consumed" item using the calculation I previously posted. However, when I create a new aggregated data source from this data source, "Consumed" is not one of the available items:

blewsas · ‎05-24-2020

Hi, I've created the following aggregated periodic measure called "Consumed": But when I try to calculate the average of that measure, I get a message that "Nested aggregated expressions are not supported": So - how do I calculate the AVERAGE (and the MIN and the MAX)? Thanks, Barry Lewis

blewsas · ‎01-23-2020

Hi, I have a Shapefile that consists of 52 Districts. Using this Shapefile, I created a new custom polygon provider called "Fish Wildlife Enf Districts", using DISTRICT as the ID Column. The map above was created as follows: So far, so good! I have a data file called "VW_ENFORCEMENT_ACTIONS" that has a column called DISTRICT CODE. It has 60 unique District Codes because it includes historical data, and 8 of the districts have since been incorporated into other districts. As best as I can tell, the DISTRICT CODE values in this file match the DISTRICT values in my map; for example, I have values of "00036" in both. So I would expect that 52 out of 60 would "map" (87%). However, when I try to create a Geography Item using DISTRICT CODE as below, I get 0% mapped. What am I doing wrong? is it because the DISTRICT and DISTRICT CODE are not formatted exactly the same way? Thanks!

blewsas · ‎09-04-2019

I have calculated "Month" from a DateTime field as "DatePart('Offence Date'n)", formatted as MONTH7. I would like to show only the last 13 full months of data in a crosstab of Offences by month (i.e., this month, I want to see September 2018 to September 2019; next month, I want to see October 2018 to October 2019). Any ideas how to do this?

blewsas · ‎08-23-2019

Thanks, that would work. I took a different, but similar, path - I created a custom category called "Offence DOW" based on my "Offence Day of Week" values and used them instead.

blewsas · ‎08-23-2019

Yes, thanks, I was just doing it wrong. I had pre-selected one data item before I tried to build the query and then I couldn't select any other data items. If I build the query without pre-selecting a data item, they're all available to me in the query builder.

blewsas · ‎08-22-2019

I deleted the old data item "Offence Day of Week" and created a new one by right-clicking on the "Offence TMST" (datetime) data item and selecting "Duplicate Data Item". I renamed the new item to "Offence Day of Week" and applied the "Day, Date" format. That gives me what I want - "Offence Days of Week" of "Sunday", "Monday", "Tuesday", etc. However, I have the same problem when I view the report - they change to "03Jan1960", "04Jan1960", "05Jan1960", etc. And I can't custom sort them. Help! Very frustrating!

blewsas · ‎08-22-2019

I want to build a filter that uses two different data items ("Form 7 Warrant" and "Form 21 Warrant"). I only want those records where "Form 7 Warrant" = "Issued" or "Form 21 Warrant" = "Issued". However, I can seem to do this in the filter advanced editor. Any suggestions? Thanks!

blewsas · ‎08-22-2019

I deleted the old data item "Offence Day of Week" and created a new one by right-clicking on the "Offence TMST" (datetime) data item and selecting "Duplicate Data Item". I renamed the new item to "Offence Day of Week" and applied the "Day, Date" format. That gives me what I want - "Offence Days of Week" of "Sunday", "Monday", "Tuesday", etc. However, I have the same problem when I view the report - they change to "03Jan1960", "04Jan1960", "05Jan1960", etc. Help! Very frustrating!

blewsas · ‎08-22-2019

my calculation is DatePart('Offence TMST'n) And I am applying the "Day of Week" format to this. What should I be doing differently? Thanks!

blewsas · ‎08-22-2019

Yes, my calculation is DatePart('Offence TMST'n) And I am applying the "Day of Week" format to this. How do I "create a new column that contains the string value that represents the day of the week and use that new column in your report."? Thanks!

blewsas · ‎08-21-2019

When I view my heat map in the Editor, the days of week (Sunday, Monday, etc.) show up properly (except that I can't custom sort them - see my other post from today). However, when I view the same heat map in the Report, they show up as "o3Jan1960", "04Jan1960", etc. Any ideas why? SAS VA 8.3

Online Status	Offline
Date Last Visited	‎06-03-2022 04:18 PM

Slider Control used to set the value of a parameter is not working

Re: Advanced Edit Filtering of Aggregated Measures in Visual Analytics

Re: Advanced Edit Filtering of Aggregated Measures in Visual Analytics

Re: How to calculate AVERAGE, MIN, MAX for an Aggregated Periodic Meas...

How to calculate AVERAGE, MIN, MAX for an Aggregated Periodic Measure

Custom Polygon isn't working

SAS VA 8.3 - Filter and display only last FULL 13 months of data

Re: Custom Sort of "Day of Week" Calculated Item

Re: Filter using two different data items

Re: Custom Sort of "Day of Week" Calculated Item

Re: Custom Polygon isn't working

Re: Custom Polygon isn't working

Re: Custom Polygon isn't working

Re: Day of Week shows up weird in report!

Re: Filter using two different data items

Re: Custom Sort of "Day of Week" Calculated Item

Slider Control used to set the value of a parameter is not working

Re: Advanced Edit Filtering of Aggregated Measures in Visual Analytics

Re: Advanced Edit Filtering of Aggregated Measures in Visual Analytics

Re: How to calculate AVERAGE, MIN, MAX for an Aggregated Periodic Meas...

How to calculate AVERAGE, MIN, MAX for an Aggregated Periodic Measure

Custom Polygon isn't working

SAS VA 8.3 - Filter and display only last FULL 13 months of data

Re: Custom Sort of "Day of Week" Calculated Item

Re: Filter using two different data items

Re: Custom Sort of "Day of Week" Calculated Item

Filter using two different data items

Re: Day of Week shows up weird in report!

Re: Custom Sort of "Day of Week" Calculated Item

Re: Day of Week shows up weird in report!

Day of Week shows up weird in report!

SAS Analytics Explorers