Jason Picker's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Veterans Administration

Country

Latest Posts

Re: Is it possible to do a "Count IF" in a Dynamic Text data set?
@imbarOption #2 is an excellent method. Counting spaces is sweet! It worked like a charm for my user. Thanks!
- Jason_Picker.1
- 4 days ago
- 1
- Questions & Answers
- Reported - view
Is it possible to do a "Count IF" in a Dynamic Text data set?

I have a grid that contains a number of rows and what I want to do is count the ones that are above or below a certain number. For example, let's say that I have a growth percentage and I want to…
- Jason_Picker.1
- 5 days ago
- 3replies
- 19
- Questions & Answers
- Answered
- Answered
Re: How to Create a Custom Bin Range in Data Model
The original syntax changed at some point. The new PQL logic is as follows: case( criteria( ([Age]<18) ,([Age]<26) ,([Age]<40) ,([Age]<55) ,([Age]>=55) ) , criteriaResults( "0-17" , "18-25" ,…
- Jason_Picker.1
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Sourcing Reporting Services Output in a Data Model
@Michael Raam Thanks, Michael. I can certainly look at building a process around downloading the file and then using standard Data Flow features to pick up the file and importing it into a model.…
- Jason_Picker.1
- 2 yrs ago
- Questions & Answers
- Reported - view
Sourcing Reporting Services Output in a Data Model

Does anyone know if it is possible to use an SSRS output (CSV, XML, or Excel) as a source in a Data Model? We tried to use the URL option without luck but aren't sure if it is a security problem or…
- Jason_Picker.1
- 2 yrs ago
- 3replies
- 113
- Questions & Answers
- Answered
- Answered
Re: Reading HTML Tables from Web Pages using Pyramid and the Python Source Connector
Thanks for the code example. The simple one works great. Be aware that the multi-table example no longer works as Wikipedia has changed the page a bit. However,…
- Jason_Picker.1
- 2 yrs ago
- Tech Blogs & Webinars
- Reported - view
Format Percentage in 100% Stacked Bar

I have a 100% Stacked Bar that I have turned on the Data Label and switched it to show the percentage. Can I format the percentage to no decimal places or just 1 decimal?…
- Jason_Picker.1
- updated 2 yrs ago
- 1reply
- 62
- 3
- Questions & Answers
- Answered
- Answered

Back to top

Home

View all topics