Questions & Answers Category

Interactive Data to change pricing

Hello, I am trying to find the limits of Pyramid, so pardon me if this is impossible. I'd like to think that thee has got to be a way... even if it is complicated.…

Cascade for date filter

Hi, I’m working on the cascading of filters and when I use the date as a base filter (i.e) the filter based on which 2 other dimensions must be filtered,…

• Answered

Highlighting the column and grid setup *help*

I'm working on a small project and cannot for the life of me get this right. What I want is to make a table in Discover that looks just like the example in Excel where the column color is determined…

• Answered

model development

Hello, I'm developing a model from an oracle connection (two tables). I'm trying to append one of the tables via union however when I do I only get a measure from one table and not the other.…

• Answered

Shareable rolling average formula

I am trying to create a calculation for the 5-day moving average. I know there is a built-in rolling average function where I can select how many days back I want to average using a parameter.…

• Answered

Is it possible to connect a slicer to dynamic text within a tooltip in Present ?

I have a tooltip on an image that displays dynamic text pulling data from a simple grid discovery. The only issue is that I am unable to apply the slicers on the present slide to the Dynamic text.…

• Answered

Radius Search

Is there a way to include data based on a radius? If so, how? I'm specifically looking for a 20 miles radius around an address. Thank you -

• Answered

Is there a way to calculate a date off of a date parameter?

Hello, We have an evaluation date parameter and we want to create a prior year end date value for a formula. In other words the user chooses March 2024 for premium and then for the "Prior Year End…

• Answered

Slicer to switch between months and weeks with same amount of bars in a barchart

Hello, we are currently building a dashboard that uses a global parameter as slicer to switch between months and weeks. The goal is to have some equal amount of bars in a barchart.…

Prioritize the Discover level over the Presentation layer when displaying or hiding specific dimensions using the Runtime Settings

There are specific scenarios where we may want to swap a chart's dimensions using only certain predefined dimensions. To achieve this, we use the Runtime setting at the discovery level for that…

• Answered

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