-
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
-
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.…
-
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
-
Day 1 of 18 Days of Year-End Community Celebration!
To kick off our Year-End Community Celebration, we want to hear from YOU!
What was your Highlight of the Year? 
Day 1 Prompt: What’s ONE professional or tech highlight from your year within your… -
Day 7 of 18 Days of Year-End Community Celebration!
Day 7 — Community Appreciation Give a shoutout to someone in this community who helped you, inspired you, or shared something valuable this year 
Let’s spread some recognition. -
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<=?…
-
Day 5 of 18 Days of Year-End Community Celebration!
Day 5 — One Prediction for Next Year 
What’s one bold prediction you have for the tech/data/AI world next year? Let’s see who’s right in 12 months!
Welcome to the Pyramid User Community
Pyramid User Community