-
Usage of the Count Function in Present
This may be a pretty basic question: I have a presentation that allows users to select multiple elements from a slicer. I would like to place a dynamic text box that displays the count of selected…
- Answered
-
Metadata Management for Data Governance
Hello, I just wanted to check if anyone has Pyramid discovers, present and models integrated to a metadata management tool like Collibra, Apache Atlas or Openmetadata The intent is to be able to…
-
Top 10 filter doesn't take each year into account separately.
I have data setup in pie graphs showing products ordered in each year. When I trellis them so that multiple years are shown, and then add a TOP10- filter it doesn't show me the TOP10 products ordered…
- Answered
-
Add a column that shows previous year, YTD.
I have sales for a few years in a grid, but want to add a column between 2024 and 2025 that shows the 2024 YTD. I assume that this can be done using time intelligence or formulate,…
- Answered
-
Text indicator to show % change from previous period
I want my text indicator to show the % change from the previous period. Ie. If the sales in 2024 were $100 and the sales in 2025 were $110, I want the text indicator to show 10%
- Answered
-
horizontal scroll
I'm assuming this is simple - and yet I cannot figure it out. My tables isn't that wide, there is no reason that it should have the horizontal scroll bar. How do I eliminate it?
-
Join with a constant
Hello, In a direct query model, is it possible to have a join with a constant value ? For e.g. can I have the join as tableA.date = tableB.date tableA.type = 'Type1' another join tableA.date = tableC.…
- Answered
-
How to disable slicer drop Down option in presentation
I have created a presentation in pyramid and want to show preselected value in slicer. So that user can't change value from slicer drop down
- Answered
-
Need guide on 2025 Feature || Delayed Slicer Execution
Hi Team, I need a guide on this below feature. Thanks, Shuv
- Answered
-
Need guide on 2025 Feature || New option to print a single visual in a presentation, rather than the entire slide.
Hi Team, I raised the below request sometime back Link, and I am excited to have this feature launched in the 2025 Newton Version, but I did not find any guide on how to use this. Thanks, Shuv
- Answered
-
Date Data Points
Hello, I have a requirement to display various measures for Current Year Prior Year End Prior Qtr End Measures would be for e.g. Balance YTD Growth % (Current Month - Prior Year End Bal)/Prior Year…
-
Turn off time changes
Hi everyone, I need to shut down the time changes in the platform because in my country we keep the same time throughout the year but I haven´t found out how. Has anyone done it before?
-
In a Discovery, how to identify records that do not have a corresponding child record
Hello, Here is the scenario. We have insurance policies in a policy table which joins to a coverage table by a policy_id primary key which is a foreign key in the coverage table.…
- Answered
-
Netto_workdays
I'm trying to do a datediff() between two dates in my Cube, but ideally I would remove the weekends from this, like excel would do with the netto.workdays() function.…
- Answered
-
Cohort Chart Analysis
Hello! Cohort Chart: Requirement : Cohort view (table or chart) to visualize these recurring orders by showing the average order value and also the percentage of customers who place recurring orders…
- Answered
-
Is there a way to disable the drop zone pop ups in Discover?
I want to be able to turn off the drop zone pop ups. I'd like this specifically for the 'Analyze Further' use case, but I would be satisfied with disabling it entirely.…
- Answered
-
Union of custom columns (Static Values)
I am in need of creating a static dimension with multiple measure names such as: sales, expenses, cost, count, etc. These are to be given to a multiselect dropdown in a report that gives the measure…
- Answered
-
Exclude a specific relationship from a Discovery
Hi everyone, I'm working with a data model that includes multiple relationships between fact tables and a date table. Currently, there's an existing relationship between a certain table and another…
- Answered
-
Difference between the calculations
Currently, I am diving deep into more of the calculations, and this brings me to a confusion that I would like to understand. I would like to know the differences between these calculations and how…
- Answered
-
Building cascading filters/slicers that contain only relevant values of charts at the presentation layer
I have a main slide where there are around 10 global filters/slicers, and the slide contains more than 6 charts. What my need is to have these filters to be cascaded and also these filters should…
-
How to do Window Aggregation calculation?
I would like to know how we can create Window Aggregate calculations such as SUM(Sales) Over(Partition by Invoice Number) can be done in Pyramid Analytics.…
- Answered
-
Purpose of the different filter panels
Can I get some guidance on using the different filter panels across the Pyramid Analytics? Filtering using the Filter panel in the drop zone Filtering using the Filter button from the Ribbon…
- Answered
-
The first workday does not appear as set up
I noticed that my Date Calendar Slicer shows the first workday as Sunday, even though I've set it correctly in Tenant / Tenant Default Settings. Is there maybe another way to setup this? If not,…
- Answered
-
Is there a way to apply Dynamic Masking (or something similar) to Measures?
My team and I would like to create a grid discovery for external users. We would like the values from certain Measures to be encrypted to external users,…
- Answered
-
Global variable doesn't update when new model is processed
Hello, I'm trying to use a conditional to check the most recent run date column in a model and compare it with today's date. I'm hoping to create a crude validation that will email stakeholders and…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.