Latest Activity

Bug Report - Critical Excel Export Failures

I am observing consistent failures when attempting to Export to Excel, particularly with large datasets (e.g., ~300k cells). Notably, exporting the exact same report to PDF succeeds,…

Adjust width for text indicator

How do I adjust how much of the cell is for the indicator (text in this case) and how much is for the data? I get this block of empty space between my data and the indicator text that is a real pain.…

question about 'Distinct Count' total function by measure in Row Total

I have a report for active customer count by quarter , so one customer may appear in multiple quarters, in grand total, need to 'distinct count ' customers,…

• Answered

Query the Pyramid Database to find Data Interaction Setting Between Report Items

Over time while maintaining Presentations we have inadvertently unset the "Data Interaction" setting in the Interaction Manager (see attached screenshot);…

• Answered

Alternative to SQL Window Functions in PQL

I wanted to check if there is any alternative approach in PQL to achieve functionality similar to SQL window functions( for example Row Number() ). Any guidance, examples,…

• Answered

CSV Export Changes Column Order in Pyramid Discover/Presentation

Hi Team, Greetings. When exporting a CSV file from Discover or Presentation, the column order changes to a weird (non-alphabetical) sequence. I want the columns to export in the exact same order as…

• Answered

Multilevel Sankey

Is there a way to create a multilevel sankey diagram? For example, if I have a dataset like this: Source Target Values NY TX 100 NY CA 200 MA CA 75 CA HI 25 TX WY 50 I'd like to produce

• Answered

Median with SQL Server direct query

How can I get the median for a measure with a SQL Server data source using direct query? Median is not in the list of aggregate functions for a measure.…

• Answered

How to create dynamic range slicers that change min/max values based on another parameter?

Hi everyone, I'm trying to create a range slicer system where the slider's min/max values change dynamically based on a period type selection. My Use Case:…

• Answered

Excel Exported Report Not Preserving Bold Header Formatting

We are facing a common issue across all reports when exporting to Excel. In the report view, all column headers are formatted in bold, but after exporting to Excel,…

• Answered

Conditional formatting on a switch list

I am trying to input conditional formatting on a switch list, but the conditional formatting won't dynamically update based on the measure selected from the switch list when the discovery is put into…

Filter

Hi Team, How can I create a date filter for “previous working day”? I need it so that when a user logs in on Monday, the “previous day” filter returns Friday’s data (skipping Saturday and Sunday).…

• Answered

General question about feature requests

Maybe I'm just being stupid, but I can't reply to my own FR again: https://community.pyramidanalytics.com/t/x2yp3df The FR was tagged with “already exists” (which I doubt) at the same time.…

• Answered

Export to Excel w/o totals/subtotals

Is there a way to export (print) a matrix grid to Excel without the totals/subtotals? I am aware I can remove them via discover, but for the viewers who don't have access to the discovery,…

• Answered

A question regarding the possibility to add or remove columns

Subject: Dynamic Column Visibility in Tables - Control via Slicer/Parameter? Hi Pyramid Community, I'm looking to create a dynamic table visualization where users can control which columns appear in…

• Answered

Dynamic Function for Total Year

Hi PA-Team, We currently use a formula that recognises the current month and year based on the current date and then outputs the entire year (e.g. January 2025, February 2025, ..., December 2025).…

• Answered