Questions & Answers Category

How to do Window Aggregation calculation?

I would like to know how we can create Window Aggregate calculations such as SUM(Sales) Over(Partition by Invoice Number) can be done in Pyramid Analytics.…

• Answered

Purpose of the different filter panels

Can I get some guidance on using the different filter panels across the Pyramid Analytics? Filtering using the Filter panel in the drop zone Filtering using the Filter button from the Ribbon…

• Answered

The first workday does not appear as set up

I noticed that my Date Calendar Slicer shows the first workday as Sunday, even though I've set it correctly in Tenant / Tenant Default Settings. Is there maybe another way to setup this? If not,…

• Answered

Is there a way to apply Dynamic Masking (or something similar) to Measures?

My team and I would like to create a grid discovery for external users. We would like the values from certain Measures to be encrypted to external users,…

• Answered

Global variable doesn't update when new model is processed

Hello, I'm trying to use a conditional to check the most recent run date column in a model and compare it with today's date. I'm hoping to create a crude validation that will email stakeholders and…

• Answered

Hiding of Filters in Discovery

I am using two filters, I need to hide one of them. Is there a possibility to make it hidden in discovery and not presentation. Thanks in advance. Jeevitha

• Answered

Data Source with SSL

Hi, I want to connect a MariaDB database as a data source, but it requires an SSL certificate (ca-cert.pem, client-cert.pem, and client-key.pem). What are the steps to do this?

• Answered

Pyramid doesn't recognize addresses

I have 1 column with full addresses; not multiple columns that separate the Street Address, city, postal code, country. When I am modeling the data, the address is recognized as a string.…

• Answered

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

• Answered

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

• Answered

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