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…

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

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

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

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

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

• 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

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

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

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

Model management tools

Hello, Are there any inherent model management tools available in Pyramid ? In essence, if I have models in UAT and Production and I want to get Production updated from UAT as part of a promotion but…

• Answered

Headcount from the previous month automatically updated on the 1st of the month

Hi, My English is not very good and I was not able to correctly formulate my request in my previous subject. I have an exploration that indicates the headcount for the previous month.…

• Answered

Having trouble to make an average over a created column

I’m encountering an issue while calculating the average sales over the last 6 months using a custom column (Mes completo) that transforms dates into a string displaying the month and year in the…

• Answered

Publication Subject - Bold

Hi , Can we make the publication / subscription subject name to bold ? Please refer the image below Please guide. Regards, Aaron Y

• Answered

String Display

Hi Pyramid Community, I'm facing an issue in displaying string in dynamic text. Please refer to the snips to understand my issue: 1. This is the formula I have on Formulate:…

• Answered

IN operator in Pyramid Formulate (Custom Column)

Hello, What's the best way to setup an IN operator in Pyramid formulate ? For e,g. I want to be able to do something like if (colvalue in ("10","11"....…

• Answered

Exports to PNG Layers

I am working on a chart in Publication that I need to export as an image. However, when I do, all of the layers are exported separately and not as one chart.…

• 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

`itemId` Parameter for `dataSources/addRolesToItemAndBubbleUp` API

For the dataSources/addRolesToItemAndBubbleUp API, what is the itemId parameter, and where can I find it?

• Answered

List itemType: database in dataSources/getDataSourcesByTenant API Output

The dataSources/getDataSourcesByTenant API currently returns details for itemType:server in the output. How can I include itemType:database in the response as well?

• Answered

Report shows unwanted data after user adds new Dimension in Analyze Further

Hi All, one of our Users, modified a report in Analyze Further to include the Group Name Dimension in the report. The problem is now that for each group it shows all agents,…

• 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

Scheduled maintenance down time

Afternoon, I've looked but have not found any means to have pyramid shut down access for scheduled maintenance. Main requirement is to prevent JDBC calls interrupting Netezza service procedures.…

• Answered