-
Headcount from the previous month automatically updated on the 1st of the month
Hi, My English is not very good and I was not able to correctly formulate my request in my previous subject. I have an exploration that indicates the headcount for the previous month.…
-
Having trouble to make an average over a created column
I’m encountering an issue while calculating the average sales over the last 6 months using a custom column (Mes completo) that transforms dates into a string displaying the month and year in the…
- Answered
-
Publication Subject - Bold
Hi , Can we make the publication / subscription subject name to bold ? Please refer the image below Please guide. Regards, Aaron Y
- Answered
-
String Display
Hi Pyramid Community, I'm facing an issue in displaying string in dynamic text. Please refer to the snips to understand my issue: 1. This is the formula I have on Formulate:…
- Answered
-
IN operator in Pyramid Formulate (Custom Column)
Hello, What's the best way to setup an IN operator in Pyramid formulate ? For e,g. I want to be able to do something like if (colvalue in ("10","11"....…
- Answered
-
Exports to PNG Layers
I am working on a chart in Publication that I need to export as an image. However, when I do, all of the layers are exported separately and not as one chart.…
- Answered
-
Dot and Ref. Line Plot
I am trying to reproduce a dot and reference line plot in Pyramid. I know what I'd like to do and am having trouble implementing it in Pyramid. I've attached the image of the chart which was…
- Answered
-
`itemId` Parameter for `dataSources/addRolesToItemAndBubbleUp` API
For the dataSources/addRolesToItemAndBubbleUp API, what is the itemId parameter, and where can I find it?
- Answered
-
List itemType: database in dataSources/getDataSourcesByTenant API Output
The dataSources/getDataSourcesByTenant API currently returns details for itemType:server in the output. How can I include itemType:database in the response as well?
- Answered
-
Report shows unwanted data after user adds new Dimension in Analyze Further
Hi All, one of our Users, modified a report in Analyze Further to include the Group Name Dimension in the report. The problem is now that for each group it shows all agents,…
- Answered
-
MTD YTD QTD manual functions
Hello community, I am aware of the pre-built MTD/QTD/YTD function using Time intelligence date hierarchy as filter. However, for the purpose of my dashboard,…
-
Scheduled maintenance down time
Afternoon, I've looked but have not found any means to have pyramid shut down access for scheduled maintenance. Main requirement is to prevent JDBC calls interrupting Netezza service procedures.…
- Answered
-
Reuse Data Models to Build other data models.
PROBLEM: Currently, we build data models that contain a set of tables (data model for products, data model for financial information); but these tables can have relationships between them too (EG:…
- Answered
-
Slicer UI settings
I have a slicer in my Present report. I have it as a button format. I want the filter options to be displayed horizontally instead of the default vertical layout.…
- Answered
-
Improved Support for Data Models with Different Granularities
Hello PA-Team! I’ve run into a challenge with Pyramid when working with data at different granularities. When comparing monthly plan data with daily actuals,…
-
Ability to make number of user inputs dynamic
Hi, I am preparing a dashboard where a dashboard user fills in the list of products to analyze- like product 1, product 2 and so on. Then for each product the user should enter the # of units.…
- Answered
-
Pattern for expected behaviour (general Q)
As I am getting acclimated to using Pyramid, one of the things I'm struggling with is the expected behaviour. Specifically, I have a line chart with two lines.…
- Answered
-
Is there a way to communicate with external models real-time
Hi all, I have a slide where a user inputs a parameter (say price). Is there a way where pyramid can take the parameter, send it to an external predictive model which returns the buy probability (%),…
- Answered
-
Is there a way to set a process to automatically copy a presentation from folder to another?
I want to set a schedule that moves a copy of a presentation from my pre-prod folder to my prod folder. I want it to overwrite the copy every time. Is there a way to do this via the API or some other…
- Answered
-
Sub Total Color Formatting - to be exported in Excel
Hi Team, Need your help on getting color formatting on sub totals and same to be exported with color to the excel. Please guide how we can achieve the same.…
- 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
-
How can we give a specific colour to Subtotals in a schema?
Hi, I found this older discussion in the Q&As, https://community.pyramidanalytics.com/t/g9hqrlc/how-can-we-identify-which-part-of-a-theme-to-change can anyone please guide where we can give color to…
- Answered
-
Access Multiselect Parameters values in Formulate
Hi, I’m trying to access multiselect parameters in Pyramid Analytics. Specifically, when using multiselect parameters in a dynamic caption, only the first selected value is shown,…
- Answered
-
How to define a Design Theme for grids with a single-color background?
I'm afraid this is almost becoming a feature request, but maybe I've overlooked something... I would like to define a Design Theme that provides a completely single-color background for grids, e.g.…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help