-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- Answered
-
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
Replace a current template in a presentation
We have changed our Master Pages/template and we would like to update all our existing presentations. Is there a way to edit/replace a current theme in a presentation?
- Answered
-
Colouring different parts of a dynamic text sentence.
As per the above mentioned, is it possible to colour different sections of a sentence that are based entirely on dynamic text - or made in the dynamic text editor?…
- Answered
-
Introduction
Hi All, My name is Daniel Oppong. I'm so excited to be part of a great community, to learn and grow with you all, and eventually productively participate and contribute to discussions.…
- Answered
-
Cumulative Rate Changes
Hi all, I am trying to replicate the example seen in the picture. As you can see, with each different year the rate % changes. I want to be able to track the cumulative change from a given year…
- Answered
-
Model Parameter Default Value
Hello, For model parameters, is there a way to manually pick a default value instead of choosing First/Last/By position? Thanks
- Answered
-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
Stacked Visualizations
Hello there, I have some questions regarding the stacked visualizations in combination with measures. I tried to create a stacked column chart with 3 different measures (3 types of costs).…
- Answered
-
Python script in model: ok in preview, fails at runtime
Hello everyone. I am attempting to execute a python script module in Model. The key library I am using is googletrans, which allows API calls to Google translate to facilitate foreign language…
- Answered
-
Using cascading slicers/filters
Hey all, We have a hierarchal table like the one shown above with simple data in the table and this table is hosted in Redshift. When I do cascading slicers so 1 interacts with 2 interacts with 3 etc…
- Answered
-
Format Percentage in 100% Stacked Bar
I have a 100% Stacked Bar that I have turned on the Data Label and switched it to show the percentage. Can I format the percentage to no decimal places or just 1 decimal?…
- Answered
-
Make reports with no longer existing measures editable for a viewer license
We have some year based measures that our viewer users use in their reports. For example these measures are always provided for the last three years (e.g. list price 2020, 2021 and 2022).…
- Answered
-
Adjust difference between slicers in Discover & Present
We are missing "Combined Elements" as a type in the "Present" slicer At this moment we are using the slicer we made in "Discover" and drag the slicer to "Present", but this is a trick,…
- Answered
-
Publication with Portrait and Landscape Pages
Hello, I am creating a publication in Pyramid, and have some discoveries which would be better displayed on a portrait page and others on a landscape page - is it possible to change the orientation…
- Answered
-
Filtered filters ->Selecting "All" should impact only filtered entries
When opening a (multiselect drop down) filter and typing a key (e.g. "m") then the filter does temporarily show only those entries beginning with "m". Additionally, it shows the option "All".…
- Answered
-
Cumulative total using Lists
I was looking at creating a measure for the Cumulative Quantities sold over time for individual products. I used the contextual "quick" cumulative measure within the discovery and it seemed to work…
- Answered
-
NQL and OLAP models
We noticed that natural querying and some other cool features (Time Intelligence, Clustering, Outlier analysis,…) don't work with OLAP models, but only within Pyramid-created models.…
- Answered
-
Is there a way to filter out rows that are only showing inf and -nan(ind)?
Is there a way to filter out rows that are only showing inf and -nan(ind)? For example: Appreciate any input! Thanks
- Answered
-
PDF / Document files as a Data Source in Modeller
Hi Avi / Pyramid Dev team, Often, information useful for a Pyramid client is stored in PDF or other document formats - for example where the Pyramid client itself has many suppliers who do not…
- Answered
-
Models and alternatives to “scheduled” time to process
Outside of pyramid analytics I “know” when my data is available (that my model needs to downsample and append to an memory database) rather than having the model run at specific time of day can I…
- Answered
-
Date Formats in Exported Excel Files
I've had a user complaining that when they export a discovery to Excel, they are unable to filter on date columns- normally in Excel when filtering dates, they are grouped together by year,…
- Answered
-
Changing Filter Type in Analyze Further
Is there an option/ability to change the filter type (drop down, buttons, multi drop down etc) in Analyze Further when adding new dimensions to the 'Filters' Drop Zone?…
- Answered
-
Selection set under Data Point not possible
Hi, I was trying to make a formula in which I wanted to use a data point in order to select both a measure and a dimension. For the dimension I wanted to use a set made on that dimension,…
- Answered
-
Cell bars are displayed incorrectly in case the Grand Total is switched on
Dear all, the cell bars' lenghts are related to the maximum value (which will then have the bar filling the whole cell). If the Grand total is switched on this will not be taken in to account, i.e.…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help