Latest Activity

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

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

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