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

Can you please update me if the network diagram chart type option is available in Pyramid or the marketplace?

• 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

Calculating percentiles

Hi. I'm trying to get some percentiles (10,25,50,75,90) from my data. First, I tried with the percentile PQL function, but it has the restriction of being attached to the Dimension provided in the…

• Answered

Add a total line to a graph.

Hi I have a person wanting a chart they can do in Tableau. In the picture attached the graph shows this information from Pyramid. The chart shows above the sections a total line.…

• Answered

Alternate header row shading

I'd like to extend the alternate shading to the header row and not just the data rows. How do I go about that? I didn't see anywhere in formatting to do this.…

• Answered

How to add a CountRows Functionality in Pyramid

Hi Pyramid team, I would like to request the addition of CountRows functionality in Pyramid, similar to the feature in DAX (Power BI). Currently, we need a function that can count the number of rows…

• Answered

Date Range Slicer for Two Dates on a table

Hello, I have two dates in my table: Contract Date and Execution Date. I do not need to apply the date range slicers on both dates at the same time. I am using @Param to create the First and the Last…

• Answered

How do I select multiple reports or formulates to open at once

Sometimes we're editing a set of reports at once or multiple formulates, it would be helpful to be able to multi-select pieces of content and open them all at once instead of having to do it…

• Answered

Maps in Pyramid

Hi, I am struggling to create a map at a region level for kenya, there is region level data in the model as you can see in the first snip below, however when I try to use this data to build a map at…

• Answered

Using same parameter for same model but pointing at different tables

Hi All, I have a model that creates some simple data sets. They are linked by location but each of them also have a parameter of "online sale" where a column states 1 or 0.…

• Answered

Using measure as an attribute

While working on a report I came across this issue: I have a list of accounts/ For each account, I have the number of days in which it was recommended. “Count recommendation date” is a measure that…

• Answered

Sorting on Multiple Columns in Model

Hello Community, I have a use case where I need to sort a data set first on column A and then, retaining this order, on column B. From what I gathered, the Sort node allows only one column at a time.…

• Answered