Alex Scott's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Calculation of a ratio
Jona, on a second review I might have misunderstood your question. The explanation is in English but the P&L table is German. Before I take another guess would you be able to more clearly state the…
- alex_scott
- 10 days ago
- Questions & Answers
- Reported - view
Re: Calculation of a ratio
Hi Jona, I think what you are looking for is a context calculation. It is covered in the following section of the help.…
- alex_scott
- 10 days ago
- Questions & Answers
- Reported - view
Re: In a Discovery, how to identify records that do not have a corresponding child record
Hi @Robert , There are probably several ways to achieve the required result. One option in Pyramid 2023 or higher is to use the 'text' aggregation function in model then searching the resulting…
- alex_scott
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: How to obtain a value from the same day in the previous year
@Stephen Forster , easiest way is to create a date parameter for the current date. Select the parameter in the formulate then click on the function button for the parameter and add the lag.
- alex_scott
- 2 mths ago
- Questions & Answers
- Reported - view
Re: How to define a Design Theme for grids with a single-color background?
I may have misunderstood your question but did you take a look at Grid Quick Styles options. There is a style option for "no background". Link to the Pyramid help file topic https://help.…
- alex_scott
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Top 10 By Measure
Hi Len, here is a similar example of qty sold by part number. The filter wizard (filter options on the toolbar) will help with this use case. You can define as a fixed Top 10 or use a parameter to…
- alex_scott
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: SAP blocks usage of ODP (Note 3255746)
In a short summary, Pyramid doesn’t use the ODP APIs and does not extract SAP data. Instead, it DIRECTLY queries SAP BW & SAP HANA. Further information on SAP Note 3255746 in relation to Pyramid can…
- alex_scott
- 11 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Case Statement in model
@Tabitha DeCaprio I am sorry but I don't fully understand what you are trying to achieve. Would you be able to provide a full explanation along with some sample data (please don't share any real data…
- alex_scott
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Case Statement in model
If you are creating a custom column the case syntax is... Case([SGBSTDN_TERM_CODE_ADMIT] >="201650" and [SGBSTDN_TERM_CODE_ADMIT] <= "201940","6th Year",…
- alex_scott
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Is there a way to filter out rows that are only showing inf and -nan(ind)?
If it is the same "IPM Provider Names" that always give the 'inf' or 'nan' result then you can use eliminations to remove the rows. This will hide the problem but not solve it.…
- alex_scott
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: User Login Stats
I suspect it is EPOCH value. The number of milliseconds since the 1/1/1970.
- alex_scott
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Is there a way to list all assets in the repository with the folder they are in?
This is answered in another Q&A article https://community.pyramidanalytics.com/t/m1hmzy7/how-to-get-the-content-path-from-the-pyramid-repository-in-usage-reporting
- alex_scott
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Additions to conditional formatting
By default, when adding the color field to the drop zone Pyramid applies a linear continuous dual banded format to the values. If you have outliers in the data or it is non-symmetrical this may not…
- alex_scott
- 3 yrs ago
- Questions & Answers
- Reported - view

Back to top

Home

View all topics