User Community

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

Slow Loading and Incorrect Previews in Presentation Viewer

Hello PA Team, I'd like to report a performance and rendering issue with slide previews in the Presentation viewer. The Issue: When opening a Presentation,…

• 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