-
Sorting Order gets disrupted when Swap dimension feature is in use
The "Swap" functionality of the pyramid Analytics is a great feature from a user perspective, but it has some flaws. Say, I have a chart showcasing the Sales against the "Sub-Category" dimension,…
- Answered
-
Alerts that loop through multiple data points
Hello Pyramid team! I'm trying to send an alert for every country in which the total talk time grew by 20%+ compared to last month, as seen in this discover:…
- Answered
-
2 elements in 1 minitab
I'd like to add 2 charts per minitab. Is that possible? When I am adding the first chart into my present minitab it auto fills the space; not allowing me to add another chart.…
- Answered
-
Ability to show just AI chat bot on Hub page
I know that users can click on the Pyramid icon on a discovery in a presentation and do NLP and use AI. Is there a way to have a chat box on the Hub when they login for them to simply ask a question…
- Answered
-
hyperlinking
I am working with a hierarchy in discover. The second layer in, is 2 columns combined, which I did when I modelled it. The first column represented the quote number (ie. Y19439-R0)....…
- Answered
-
is there a way to calculate an mesure avarage for the last year from yestrday?
I want to calculate a moving avarege of a mesure that will be always take the period of a year from yesterday or preveious week back. can someone help me with this calculation?
- Answered
-
Joining Splicers
I'm putting together a present where I have 2 elements from the same model, that use different time intelligence dimensions. I'm trying to add a splicer that will function on both elements on the…
- Answered
-
Origin date format isn't recognized by Pyramid as a DATE
The system I use generates reports where the date is formatted as a string of numbers and I cannot figure out how to get model to see it as a date. I assume somewhere there is a solution where I can…
- Answered
-
API for Testing In-Memory Data Source Connection
Is there an API available that tests the connection to the in-memory data source and sends an alert if the connection fails?
- Answered
-
Target URL Parameterization for Present
I am currently digging into getting target settings in url right. It works with simple URLs like…
- Answered
-
Push Publications to an SFTP Site
Hi. We have publications containing sensitive data, and data protection regulations prevent us from using email distribution. Is there a way to push publications to an SFTP site?…
- Answered
-
Using a pie graph as a 'link' to open a chart
I'm looking to insert a 'clickable' pie chart into a presentation. Ideally, when the viewer clicks on the chart, a separate window would open displaying both the pie chart and the corresponding data…
- Answered
-
How to do an vertical union in Pyramid?
I want to combine data from two sources but stack the results vertically, even if there's no direct match between the left and right datasets. How can I achieve this?
- Answered
-
Multiple slicers in Mini-Tabs
Hello everyone, I'm new to Pyramid Analytics and have recently started learning about Mini-Tabs. I was wondering if it's possible to link two slicers to four different Mini-Tabs?…
- Answered
-
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…
- 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…
- 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
-
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 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
Got stuck with a report? Start a discussion or help others to move forward.