-
Allow microphone use in a browser or mobile app
Hello Community, When using the chatbot, clicking on the microphone icon produces the following error message: Unable to access your microphone. Make sure that your microphone is enabled in the…
- Answered
-
Renaming a measure
I want to rename a measure from the model. I try it from the model in the tables part and then "Display Name". But after changing it I see the original name in the discovery and nothing changes.
- Answered
-
Dynamic SQL - Field Name Changes
Hi I have a table that has values in different languages, I wondered if there is a way to pass the field name for the 'current' language as part of a custom sql statement,…
- Answered
-
Content Master Page | Copyright Year
We need to show a copyright year on every slide of our presentations. Currently when we create a new presentation, we add in a dynamic text that shows the year onto the Content Page:…
- Answered
-
Difference actual week- week prev year
Hello, we would like to calculate the difference of an KPI actual year vs Previous year on weekly base (KW this year - KW prev Year). We have time attributes for Date, KW (i.e.…
- Answered
-
IBCS Waterfall Column Naming
Hey All, I was just wondering if there is a way to name the left and right book end of the IBCS waterfall. I can't seem to find where it is in format, has anyone else managed to get the previous year…
- Answered
-
Clear distinction between what a Pro user versus Analyst user can do
New to Pyramid and I wondered if I can please get a clear distinction between a pro user and Analyst user- What a pro user can do that an Analyst cannot do.…
- Answered
-
Percentage points change calculation
I am trying to calculate change in percentage points between two rows and have followed the steps in a previous post: Click on the "+" icon in the vertical column of icons to the left of the Grid…
- Answered
-
Using a string variable in sql script
If we use a string variable in PQL editor while creating a SQL Script node, the variable is being enclosed in quotes that is causing the sql to fail. Example: @ColumnList is set to: column1,column2,…
- Answered
-
Creating "1st Month of the Year of the Previous Month" in a list
I have the following as a Range List which is the *First Month of Current Year* until previous month I want to change the start of the list to be the first month of the previous year instead.…
- Answered
-
Inserting a blank column
Hi, Trying to build a simple report. Are you able to inside a blank column in Pyramid like you would an excel document?
- Answered
-
How to view underlying query of a discover report
Hello, I am wondering if there is a way to view the underlying SQL query of a discover report? I am not finding the performance dialog in the bottom right of my screen.
- Answered
-
Using a SQLServer Table Value Function in Pyramid
Hello, Has any one tried using a SQLServer table valued function in a mode ? For e.g. I have a TVF that tables date as an input select * from schema.table(@date) Where date is a literal that can be…
- Answered
-
PQL for checking if date is null
Trying to find the correct syntax for checking if a date is null in a script formulate. Currently accessing the date via [pyramid_custom_query_t_placement_patient_hsptl].[cl_effective_from_date].…
- Answered
-
Cascading parameters
Hello folks. Does Pyramid have the ability to build cascading parameters? I would like to have a text parameter control the output of two independent numeric parameters. Cheers, Dave
- Answered
-
Get data from 2 months ago
Hi, I need to get for a new business logic (AKA formulate section) data dynamically from 2 months ago in order to divide it by data from 1 month ago. I don't have the "2 months ago" filter built-in…
- Answered
-
Gantt chart?
Can Pyramid be used to create a Gantt chart? https://help.tableau.com/current/pro/desktop/en-us/buildexamples_gantt.htm https://www.atlassian.com/agile/project-management/gantt-chart#:~:…
- Answered
-
Can I bring up a second filter/slicer when certain selections are made in an initial one?
Hi, I would like to make it so that choosing a particular selection in a slicer in a present brings up a secondary slicer based on a different dimension.…
- Answered
-
Bell curve graph
hi, the business is looking to use bell curve graphs in Pyramid to depict performance (using MEAN and Std Deviation and normal distribution). We are struggling to make it work, any insights welcome.…
- Answered
-
HR Cube - Absenteism hours - Formulate
PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…
- Answered
-
How to un-show header in a table
Tableau had a feature that allowed you to add a column to a table but hide it by deselecting 'show header' Is there a similar feature in Pyramid? Here's a table I created in Pyramid and I could like…
- Answered
-
Comment modéliser mes données correctement
Bonjour à tous, je dois réaliser un reporting en fonction de ce fichier excel. Sur des graphiques, je dois afficher le nombre de journées CP en fonction du nombre de journées.…
- Answered
-
After focusing on a member in a Discovery, how do you unfocus?
Hello, We have had a couple of occasions where users have focused on something and saved the report. How do I turn off the focus so it goes back to it's original state? Thanks, Rob Clark
- Answered
-
Congratulations – Level 3 Certified: Dandre Diedericks, Keyrus
Pyramid Certified Level 3 Announcement We are very pleased to announce that, Dandre Diedericks from our Partner Keyrus in South Africa has recently completed the Level 3 Expert Certification in…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.11 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
The DataShark Podcast
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help