Latest Activity

NLQ with Pyramid Internal Chatbot

Hello, Does using NLQ with the Pyramid Internal chatbot cause any data (semantic as well) to leave my network ? Or does this just use the semantic data from the model to answer my questions ?…

• Answered

Images to be connected to a slicer

I have a presentation that shows the sales for 4 different companies, where the data is changed by a company slicer. Each company has their own logo. Is it possible on a presentation to have the logo…

• Answered

Average invoiced shown instead of totals

I'm so lost here that I had to draw it by hand! haha. How do I do this properly? I'm actually just grasping at straws at the moment and need some expertise.…

Ordering the Months

Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…

• Answered

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

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

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