-
PQL lookup second largest value
Hello, I am trying to write a PQL function which will find the row with the second largest value in a particular column of my matrix, is there a way to do this ? Thanks, Katie
- Answered
-
model development
Hello, I'm developing a model from an oracle connection (two tables). I'm trying to append one of the tables via union however when I do I only get a measure from one table and not the other.…
- Answered
-
Welcome to our Community Member Lounge
Hello, and welcome to the newest area in our community, the Member Lounge! This area will be a place for community members to connect with each other through introductions and user groups,…
-
Column width
Can I change the width of individual columns instead of changing the width off all of them (similar to the way Excel works? Sorry for using Excel as an example - but the feature I want happens to…
- Answered
-
Customizing specific background colors in a discovery - Version 2020.16.031
Good Morning, Please be so kind as to assist me with the following: I am trying to create a robot grid for my dashboard. There are 2 ways I need to do this. 1.…
- Answered
-
Rename the "Grand Total" name in a grid
Is it possible to rename the "Total" or "Grand Total" name in a grid?
- Answered
-
is there a way to calculate an mesure avarage for the last year from yestrday?
I want to calculate a moving avarege of a mesure that will be always take the period of a year from yesterday or preveious week back. can someone help me with this calculation?
- Answered
-
Shareable rolling average formula
I am trying to create a calculation for the 5-day moving average. I know there is a built-in rolling average function where I can select how many days back I want to average using a parameter.…
- Answered
-
Highlighting the column and grid setup *help*
I'm working on a small project and cannot for the life of me get this right. What I want is to make a table in Discover that looks just like the example in Excel where the column color is determined…
- Answered
-
Handling 504 and 502 Errors in Pyramid
If you're encountering 504 or 502 error messages, the issue is likely related to the reverse proxy or load balancer sitting in front of Pyramid. These errors often occur due to timeouts that are set…
-
Congratulations - Level 3 Certified: Chase Egbo - Millenial Informatics
Congratulations to Chase Egbo and our partner Millenial Informatics on their first Level 3 Certification. What an accomplishment and we can't wait to see how this transforms the solutions the team…
-
Radius Search
Is there a way to include data based on a radius? If so, how? I'm specifically looking for a 20 miles radius around an address. Thank you -
- Answered
-
Is there a way to calculate a date off of a date parameter?
Hello, We have an evaluation date parameter and we want to create a prior year end date value for a formula. In other words the user chooses March 2024 for premium and then for the "Prior Year End…
- Answered
-
Is it possible to connect a slicer to dynamic text within a tooltip in Present ?
I have a tooltip on an image that displays dynamic text pulling data from a simple grid discovery. The only issue is that I am unable to apply the slicers on the present slide to the Dynamic text.…
- Answered
-
Congratulations – Level 3 Certified: GaneshShankari Karuppiah - KASH Tech
Congratulations to GaneshShankari Karuppiah and KASH Tech for adding their third Level 3 Certified Consultant in the past eight months—a testament to their commitment to mastering the platform and…
-
New service packs for Pyramid 2024 and Pyramid 2025 Released
New service packs have been released for both Pyramid 2024 and Pyramid 2025. Customers are advised to deploy these upgrades to benefit from the fixes and upgrades to both functionality and security.
-
Pyramid 2024.01 LTS "Fibonacci" has been released
Pyramid 2024.01 LTS "Fibonacci" has been released. This is the first service pack for Pyramid 2024 which only includes fixes for key issues and security updates.…
-
Sorting Order gets disrupted when Swap dimension feature is in use
The "Swap" functionality of the pyramid Analytics is a great feature from a user perspective, but it has some flaws. Say, I have a chart showcasing the Sales against the "Sub-Category" dimension,…
- Answered
-
2 elements in 1 minitab
I'd like to add 2 charts per minitab. Is that possible? When I am adding the first chart into my present minitab it auto fills the space; not allowing me to add another chart.…
- Answered
-
How do I add the Tooltip for the last element in a Waterfall Chart
Hello PA-team! Tooltip Issue for the Total Element There is currently an issue with the tooltip functionality for the generated last element (Total) in the Waterfall chart.…
- Answered
-
hyperlinking
I am working with a hierarchy in discover. The second layer in, is 2 columns combined, which I did when I modelled it. The first column represented the quote number (ie. Y19439-R0)....…
- Answered
-
Target URL Parameterization for Present
I am currently digging into getting target settings in url right. It works with simple URLs like…
- Answered
-
Joining Splicers
I'm putting together a present where I have 2 elements from the same model, that use different time intelligence dimensions. I'm trying to add a splicer that will function on both elements on the…
- Answered
-
Origin date format isn't recognized by Pyramid as a DATE
The system I use generates reports where the date is formatted as a string of numbers and I cannot figure out how to get model to see it as a date. I assume somewhere there is a solution where I can…
- Answered
-
API for Testing In-Memory Data Source Connection
Is there an API available that tests the connection to the in-memory data source and sends an alert if the connection fails?
- Answered
Welcome to the Pyramid User Community
Pyramid User Community