Latest Activity

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

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

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

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

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