Latest Activity

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

How to create quantities sales report

Hi, I coudn't find answer on my question anyware so just creating new topic... I want to create a report for specific departments and subdepartments which will show me units sales of all product…

• 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 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

How can we identify which part of a theme to change?

Wondering if there is some kind of documentation that would help me identify which part of a theme to update to have the impact I'm wanting in a Discovery.…

• 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

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

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

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

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

Where can I find the query text information in the Pyramid repository database?

I'm building a transaction logs dashboard and can get most details from the transactionView table, but I can't find the query text information. Is the query text stored in the Pyramid repository…

• 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