-
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
-
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…
-
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
-
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
-
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
-
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
-
Data Type changes from Date to Datetime when reusing IMDB Models (blocking Multi-Select workflows)
Hello PA Team, I'd like to report an issue with Data Type preservation that creates a blocker when using the "Multi-Select" feature in Data Flow. The Scenario:…
-
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
-
How to get grand totals to appear on top for a tabular grid
In a Matrix Grid there is an option to display the Grand Totals on top Is there some way to do this for a Tabular Grid?
- Answered
-
creating a discovery with category sales and supplier sales without dashboard slicer messing up values
I'd like to create a discovery with supplier sales within the category and category sales(what i marked) and place it in my dashboard. however the dashboard has supplier and category slicers,…
- 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
-
Filter with numeric attribute
I'm trying to achieve the below: sum of transactions.sales by product where transactions.Sales > $32,000 (user can choose amount) I can't find a slicer type for a numeric attribute,…
- 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
-
Drop tables in the In Memory Database
Is there a way to drop a table in the In Memory Database? I see where I can delete an entire database, but not individual tables.
- 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
-
PDF Export Looks Different Than Presentation View
Hi everyone, I’m running into an issue with formatting when exporting to PDF and wanted to check whether this is expected behavior or if I’m missing a setting.…
-
Secure/Masked Variables for Python Scripts
Hello PA Team, I have a request regarding security in Python/R scripts within Data Flows. Currently, I haven't found a secure way to pass sensitive credentials (like DB passwords or API keys) into a…
-
Use one date to filter multiple fields
Hello, We are trying to make it so that a user can select a single date and it will filter the data similar to this where clause, replacing the ? with the date: where trans_date<=?…
-
Troubleshooting intermittent "Grey Screen" crashes in Content Explorer
Hello Community! I am running Pyramid version 2024.03.002. I am facing a recurring but inconsistent stability issue where the UI completely crashes to a "Grey Screen" while I am working.…
-
Formulate with condition if measure is blank
I'm trying to subtract one measure from another only if the second measure has a value. If not, the formula should return empty. The below is not working.…
- Answered
-
Parent-Child Sales Aggregation Issue
HI Let’s say we have a single DB table that has sales data at the state level and population data at the city level and is pulled into PYRAMID using the direct query model (CUSTOM QUERY TABLE).…
- Answered
-
Formula for measure filtered by a dimension
I have the fact and dimension tables below: SourceType dimension · SourceType 1 · SourceType 2 · SourceType 3 · SourceType 4 Event fact · Count of events I would like to 1) create a formula which…
- Answered
-
Bug Report - Calendar Slicer Disables Previous Full Week if Current Day Data is Filtered Out
Hello PA Team, I'm reporting a bug in the Calendar Slicer logic when using "Weeks" granularity. Scenario: I have a data model where data is filtered strictly "before today" (date < today()).…
-
How to Show Multiple Grand Totals without Repeating Measure Under Each Column
I want to show the current sales values per day for the current month with the grand total to the left. As show below. This is easy enough. However I want to add two extra (in yellow) grand total…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.