-
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