Latest Activity

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

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

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…

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

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

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

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

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?

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!!

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

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

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

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

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

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

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