-
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…
-
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
-
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
-
So...is the Cloud Actually Dead?!
Is ‘cloud-first’ still the right default strategy for most organizations? The answer isn’t as clear-cut as it used to be. Tell us how your organization is thinking about cloud today
Add your… -
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.…
-
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,…
-
Top or Bottom X using a Parameter - TIP
Have you ever wanted to toggle between the top or bottom products, items, or whatever by a specific measure? Here is a simple approach to do so. 1. Start in Formulate and select a List. 2.…
-
Day 14 of 18 Days of Year-End Community Celebration!
Day 14 - A Book, Video, or Article That Stuck With You Learning happens everywhere. What content — professional or personal — taught you something valuable this year? -
How to Use Nginx to Act as a Load Balancer
The following article explains how to install Nginx as a Load balancer, allowing access to Pyramid using HTTPS and redirect request between multiple web servers.…
-
Extract Private Key and Chain Files from PFX Certificate for Nginx HTTPS
When using Nginx as a load balancer or a reverse proxy to serve on HTTPS protocol, Nginx expects the SSL certificate to be configured as a private key and chain files.…
-
Day 16, 17, 18 of 18 Days of Year-End Community Celebration!Whew, what a year! First, I want to thank everyone who participated in our 18 Days of Year-End Celebration here in the community. It’s been such a meaningful way to close out the year together.…
-
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).…
-
Day 15 of 18 Days of Year-End Community Celebration!
Day 15 — Share a Holiday/Winter Tradition We come from many cultures. Tell us about a tradition from your family, region, or community — big or small. -
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:…
-
Day 9 of 18 Days of Year-End Community Celebration!
Day 9 — Gratitude & Growth Share one thing you’re grateful for in your tech journey this year — big, small, personal, or professional. 
-
Day 10, 11, 12, 13 of 18 Days of Year-End Community Celebration!
Days 10, 11, 12, 13 As many of us head into some well-deserved time off this week, let’s kick things off with a little holiday trivia!
Test your knowledge and see who can score the most correct… -
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
-
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
-
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
-
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
-
Day 8 of 18 Days of Year-End Community Celebration!
Day 8 — Eight-Second Tip Share a quick eight-second tip that someone else in the community can benefit from. Fast. Practical. Helpful. What can you share @Hillel Dor@Joe Beaubien@Dmitri Kanounnikov -
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
Welcome to the Pyramid User Community
Pyramid User Community