-
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
-
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).…
- Answered
-
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
-
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… -
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
-
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. -
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! -
Day 6 of 18 Days of Year-End Community Celebration!
Day 6 — Six-Word Story Describe your year in a six-word story. Thoughtful, funny, honest — all welcome! PS: Include photos if you can 
@Matthew Dove @Joe Beaubien @Risa Peterson ,… -
Day 3 of 18 Days of Year-End Community Celebration!
Day 3 - Share a Learning Moment! A funny mishap, an unexpected discovery, or a “yep… never doing that again” moment — we want to hear it! What did it teach you? P.S.… -
Day 4 of 18 Days of Year-End Community Celebration!
Day 4 — Four Questions Challenge Answer these FOUR reflection prompts about the Pyramid Analytics platform: 
Favorite new feature 
A challenge you solved 
Something you learned 
… -
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.…
Welcome to the Pyramid User Community
Pyramid User Community