-
Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
Our users would like to be able to choose, on a presentation, to display all the discoveries by either week, month, quarter or year. Is there a way to have a drop down that would change each…
- Answered
-
How to obtain a value from the same day in the previous year
Hi, I'm looking to obtain a value from a measure which shows that value for the same day from the previous year. I have created this below in formulate,…
- Answered
-
Column width
Can I change the width of individual columns instead of changing the width off all of them (similar to the way Excel works? Sorry for using Excel as an example - but the feature I want happens to…
- Answered
-
Data Flow Output Question
I am trying to create a dataflow that starts with 2 different Pyramid content file sources (Tables I created within Pyramid already). Since each is referencing a different database,…
- Answered
-
Rename the "Grand Total" name in a grid
Is it possible to rename the "Total" or "Grand Total" name in a grid?
- Answered
-
Customizing specific background colors in a discovery - Version 2020.16.031
Good Morning, Please be so kind as to assist me with the following: I am trying to create a robot grid for my dashboard. There are 2 ways I need to do this. 1.…
- Answered
-
PQL lookup second largest value
Hello, I am trying to write a PQL function which will find the row with the second largest value in a particular column of my matrix, is there a way to do this ? Thanks, Katie
- Answered
-
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.…
- Answered
-
Cascade for date filter as Date Calendar Type
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.…
- Answered
-
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
Got stuck with a report? Start a discussion or help others to move forward.