-
Sorting a measure using N-of-N
How do I sort the 2025 sales highest sales to lowest sales while keeping the subcategories unchanged. i want to sort them winin each subcategory.
- Answered
-
Direct Query vs Ingestion: When to Use Each
Choosing the right data connection approach for your Pyramid model What's the Difference? Direct Query queries data at its source in real time. Every report interaction sends a query to the source…
-
"Model", one word and many meanings
When working with Pyramid Analytics we often mean different things when we refer to “Model” or “Data Model”. In this post I will clarify the main distinctions between the different model terms.…
-
Display dates in viewer's timezone
I'm looking for a way to display date/time fields in Discoveries (and elsewhere) in the viewer's time zone. We store datetime values in the source data in UTC and when we show it in reports we want…
- Answered
-
Execute JavaScript – Navigate to Specific Slide in Present
Hi Team, I'm trying to navigate to a specific slide in a Present Pro dashboard using Execute JavaScript action (not Jump To Slide). I wanted to share everything I've tried so far in case anyone has a…
-
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.…
-
Dynamic “initial price” driven by a user-selected date filter
How do I calculate a dynamic “initial price” driven by a user-selected date filter? Background I have a receiving ledger with a few million rows of receiving entries.…
-
Ai Driven Value creation - showing complete Json Value instead of the specific count
I am new to Pyramid. I was doing Use Case7. While doing 'AI Driven Value Creation" to add " Show population for each country". It's showing the entire JSON value.…
-
Need Help Creating Dynamic Previous Month Sales, Current Month Sales & Growth % in Pivot
Hi Team, I need help creating Previous Month Sales, Current Month Sales, and Growth % in a Pivot. I have: A Sales column A Sales Date column in yyyy-MM-dd format Initially,…
- Answered
-
Is there a PQL equivalent to the MDX Generate function?
I have a report that I am trying to build that will display a current year period and a prior year period. The user needs to be able to select a date range.…
- Answered
Content aside
-
Read More