Questions & Answers Category

Reordering Columns Once Model Has Processed

So in pyramid model there is a column operation that allows me to reorder the columns. Still, once I process the model, the order of the columns that is displayed is not what I specified in the model.…

Colored Stacked Bar Chart with Grey Area Overlay Displaying 75%-125% of the Average Count

Looking to create a bar chart that is using colors based on a dimension for the vertical lines, while also placing an average amount of the count as a grey horizontal line.…

KPI Chart

I would like to know if there is a possibility to use the drag and drop facility of the tool to achieve the KPI chart- values with dynamic trendline. Many Thanks!!

Presentation sharing issue

Hi , I cannot find any option to share my presentation publicly. Could you please advise? Attached my role details as well. I also need the embedding link. Thanks

countif

I'm trying to recreate a function like countif to create a table showing me how many times 1 parameter's element relates to a different parameters element. See diagram for example.

• Answered

Trimming and Cleaning Whitespace with Python Node in Model

Hello, I know how to trim and use regex to replace whitespaces in Model, but I thought I'd challenge myself to try to learn and familiarize myself with the script node.…

• Answered

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

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

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

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