Filtering child of hierarchies; not parent.

I have a chart where there is a column of (parent) PRODUCT TYPE sorted by sales, and nested below are the (child) PRODUCT NAME. I want to be able to show only the TOP20 selling (child) PRODUCT NAME…

How to add a CountRows Functionality in Pyramid

Hi Pyramid team, I would like to request the addition of CountRows functionality in Pyramid, similar to the feature in DAX (Power BI). Currently, we need a function that can count the number of rows…

• Answered

Power Automate Integration with Pyramid Analytics

I am currently working on integrating Pyramid Analytics with Microsoft Power Automate/ aka Microsoft Fabric to automate the retrieval of JSON files generated by Pyramid.…

• Answered

disable Welcome Screen for all Users

Good Morning, I'd like to disable the welcome screen for all users. Unfortunately I can't find any option in the admin console or the pyramid online help to do that.…

• Answered

Conditional Formatting in a waterfall

Hey I am trying to create a waterfall chart that shows the deviation between planned and actual values. I have inserted this as a unit of measurement (calculation actual minus plan) in my values and…

• Answered

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…

Tenant-localizable field names

Our application allows customers to rename things, for example patient identifiers. Even if it's all the provincial health card number, each province has a different acronym,…

• Answered

How to use the 'Execute JavaScript Action' Click Action to Modify a Filter

My team and I are working on a presentation that contains an image and a discovery on a single slide. We would like to create a click action on the image that sets a filter on the discovery to a…

• Answered

MTD YTD QTD manual functions

Hello community, I am aware of the pre-built MTD/QTD/YTD function using Time intelligence date hierarchy as filter. However, for the purpose of my dashboard,…

• Answered

Top and Bottom N filtering

Hi, I want to be able to filter my matrix to show both the top 1 and bottom 1 value in the same table. Is there a way to do this? Currently I can only see that its possible to do one or the other…

• Answered

How to Set a Default Size For Pop Up With IFrame

My team is utilizing the 'pop up in iframe' click action in a present window. We would like to set the default size of the pop up window to be slightly larger.…

• Answered

how do i get a shapefile for rainfall station and data for Negeri Sembilan, Malaysia

• Answered

Dot and Ref. Line Plot

I am trying to reproduce a dot and reference line plot in Pyramid. I know what I'd like to do and am having trouble implementing it in Pyramid. I've attached the image of the chart which was…

• Answered

How to replace a string cell with a text value using Calculated Column

Hello, I need to find 'blank' (empty, no data, '', etc.) cells in a column "Description" (String, 255) and replace with a text 'NO DATA'. I added InsertRecords Flow --> Column Operations -->…

• Answered

Seeking to Apply Security to End Users on 'Analyze Further' option for discovery

I am working on a discovery for a client-facing presentation that I want users to use the 'Analyze Further' feature to explore. Within the matrix grid discovery,…

Table in Present automatically changing to different style on resize.

Morning all, Quick question, if I create a table in a discover then place within a Present, the table will automatically change type when the size is reduced to a certain level.…

• Answered