-
YTD and Prior YTD Measures
Desired Outcomes: I want to perform month-over-month analysis, comparing prior year-to-date (PYTD) figures with current year-to-date (CYTD) figures, and calculate the difference for each month.…
- Answered
-
Calculating a Rolling Average Containing Empty Values
I noticed that whenever a cell is empty, Pyramid excludes it from the average. For example, if week1 = 1, week2 = 0, week3 = 5, Pyramid excludes the week 2 element from the calculation (i.e.…
- Answered
-
Pyramid Community Weekly Wrap Up - August 30th 2024
Dear Community, Back from my holiday. First thing on Monday I checked, if there are any new developments in the Community and YES! There are new Leaders in the Top Contributor Lists.…
-
Create an OR filter
Hello, I have a discover as below I want to create a filter that says either the first employee_flg = Y (table 1) or the second employee_flg (table 2) = Y Is it possible to do this in an discover ?…
- Answered
-
Free Text Parameter interacting with Present content
Hello I have the following use case issue that I cannot resolve. I need to place a free text numeric input field onto a present and get that to interact with a Discover to act as a filter.…
- Answered
-
Publication Performance
I have a 5 page Publication with over 300 dynamic text elements and 4 Discovers. I work in Higher Education and this is an academic program profile that looks at 5 years of data for a degree major.…
- Answered
-
Congratulations – Level 3 Certified: Immanuel Gem - Tigma Tech
Pyramid Certified Level 3 Announcement Tigma Tech grows their group of fully certified consultants at an impressive speed, this week I am happy to announce that Immanuel Gem also has completed his…
-
Pyramid Community Weekly Wrap Up - August 16th 2024
Dear Community, to our new members, thank you for signing up this week. This is the first step in your journey to get better reports and results from Pyramid.…
-
Congratulations – Level 3 Certified: Steve Devine - Camden AI
Pyramid Certified Level 3 Announcement Make that three fully certified Consultants at Camden AI. Growing the list of our Partners who have shown to be up to date with the latest addition in the…
-
how to ALTER in-Memory DB table and add new columns?
i have a large model that i don't want to wipe out and rebuild. i was hoping to learn syntax for sql script to "alter table [tableName] Add [tableName].[newColumn] char(8)" type of command.…
- Answered
-
Rolling average on a switch list
I have a discovery which is driven by a switch list containing two parameters. I would like to be able to apply a rolling average on each of the values when selected,…
- Answered
-
Talk to your Data and See It on the Map
Conversational BI with Pyramid and Mapbox In a recent Webinar, our own @Joe Beaubien talked with Cris Byers from our Partner Mapbox about the potential of using GenBI in combination with their…
-
Congratulations – Level 3 Certified: Nanmaran Pandiduri - Tigma Tech
Pyramid Certified Level 3 Announcement To see Tigma Tech adding certified consultants at a regular basis is a great proof of the growing number of joint projects.…
-
Loading present via URL with filters and targets….but cross model mapping needs to be tailored
I have been expanding a dashboard that’s really resonating with our internal users. When opening the “present” directly it lands with a date filter using “current date”.…
- Answered
-
A quirk when installing Pyramid on Linux - Host Name Issue
We ran into an odd issue with Pyramid installation on Linux (Ubuntu). The installation was failing for no good reason. And there is no point in delving into the logs as the solution was found.…
- Answered
-
Error When Adding Web Panel In Present
When I try to add a link to the web page illustration in Present, I keep on getting a error message as seen in the attached image. When I was following the Pyramid Help Page for Web Panels https:…
- Answered
-
Pyramid Community Weekly Wrap Up - August 9th 2024
Dear Community, "working behind the scenes week" means preparing some changes for the Community and the Learning Hub, where can't wait to publish the updates.…
-
How to build Aggregate blocks for a Dimension
How to build Aggregate blocks for a Dimension When you are working with larger lists it is often necessary to define groups of elements into a single aggregated element that contains the totals for a…
-
Automatically save Present filters to original discovery report
Hello Pyramid Community: I need the filters applied in "Present" mojo to be automatically saved in a original "Discovery Report" What is the more efficient way to configure this?
- Answered
-
Log Storage Table in Pyramid Repository Database
I want to make the system logs and scheduled job logs visible to users by creating a dashboard in Pyramid. Is there a table in the Pyramid repository database that stores these logs? If so,…
- Answered
-
Congratulations – Level 3 Certified: Arunkumar Kuppusamy - Tigma Tech
Pyramid Certified Level 3 Announcement Tigma Tech add another consultant to their team, shortly after Nanmaran, Aunrkumar Kuppusamy also has taken his Level 3 Exam and passed the Certification…
-
Is there a way to get the modelId for the /API3/dataSources/addRolesToModel API without using the Admin Console?
The /API3/dataSources/addRolesToModel API requires an itemId as an input parameter. To obtain the itemId, I currently need to navigate through the Admin Console by going to Source Manager >…
- Answered
-
Fixed Static Parameter
Hi I'm new to Pyramid. How do I create in a report or KPI that has a fixed static parameter please. I want a report or KPI that counts a distinct value when a range is between 1 and 1000.…
- Answered
-
How can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- Answered
-
Congratulations – Level 3 Certified: Mark Davis - Camden AI
Pyramid Certified Level 3 Announcement Mark is the second Consultant from Camden AI, who completed his Level 3 certification in the past few days. The final exam means building a full solution and…
Welcome to the Pyramid User Community
Pyramid User Community