Latest Activity

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

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

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

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

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

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

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

Rename the "Grand Total" name in a grid

Is it possible to rename the "Total" or "Grand Total" name in a grid?

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

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

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

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

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

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

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