User Community

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.…

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…

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

How to configure Dashboard slicers to work with Tabulate slicers?

I have a tabulate that contains 2 discovers, both filtered by a date. I grab one of the rows from the second discover and place it at the bottom of the first sheet and create some calcs.…

Error in interaction between two calendar filters

Hi all, i have the following problem - error in interaction between two calendar filters. How to reproduce the problem: 1) Create a calculated measure. 2) Create a visualization with two date filters.…

[Bug] Unpivot Settings causes a gray screen in Model

Hi Pyramid Team, I can reproduce a UI crash in Model when opening the settings window for an Unpivot node. Scenario: ClickHouse > Table > Unpivot Steps to reproduce: Create a new model.…

Issues with $0 values exported as $ in Excel export of a Publication

Hi, I have measures in my publication that display values as $0. When I export the publication to Excel, the values appear as just $ without the 0. I have attached screenshots of both the publication…

• Answered