-
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
-
Cascading Slicer question
I have a report that had non-cascading slicers for Course College and Course Department. The report displays Course Section and Attempted Class Count. It made sense to have a cascading slicer for…
- Answered
-
Usage statistics
Hi team I would to ask if in PA 2018 you have embedded a user usage cube as in BI Office. If not is it in planning? Thx Nikos
- Answered
-
Dynamic texts for Slicers
Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…
- Answered
-
Displaying a 0 instead of a blank cell where there's no data for a given date
Hi. This is related to the How To article that Moshe Yossef kindly provided a while back - https://community.pyramidanalytics.com/t/p8hv3sr/how-to-create-a-dynamic-set-of-dates.…
- Answered
-
Install or Add new Python packages
Hi, How do I add new Python packages which are not available by default in the pyramid?
- Answered
-
Drill Through within Measure?
I was wondering if there is a function in pyramid which allows me to drill down/through to a single line item (if it is not linked to a hierarchy)? I can always right click e.g.…
- Answered
-
Maintaining Formatting when Exporting to Excel
Hi all, New user here still getting to grips with the product. I am currently in the process of trying to replicate some of my company's reports that are in a standard format in Excel.…
- Answered
-
Using cascading slicers/filters
Hey all, We have a hierarchal table like the one shown above with simple data in the table and this table is hosted in Redshift. When I do cascading slicers so 1 interacts with 2 interacts with 3 etc…
- Answered
-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
Number Formatting in Discovery
Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…
- Answered
-
Discovery Data Catalog Export
Hello folks. Is it possible to export the data catalog from a discovery object in a format which is not .pdf? I see I can export the data catalog from a data model object as a json file,…
- Answered
-
Customize a Breadcrumb Subtitle
Hi. Is there a way to customize the breadcrumb in a subtitle on a Presentation such that only the slicer values are displayed, and displayed in the order they appear in the presentation?…
- 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
-
Creating a calculation to provide difference between two columns of numbers
We have reports that use named sets to provide four years of data and need to show the difference between the last two. We've done it with a quick calc using data points but we find that these hard…
- Answered
-
Control over #PageNumber Text Field in Publications
Is there a way to control the #PageNumber text field in a publication? For example, if I'm using the new Cover page feature and have the #PageNumber text field on the Content master page,…
- Answered
-
how to create not a dynamic calculation
Hi, I have a case where I need to make the next calculation: In a table with the columns: week | store name | item name | sales For each item: In each store,…
- Answered
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
Ordering the Months
Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…
- Answered
-
How to calculate 90 percentile based on category
I need to calculate 90 percentile in one of my discovery (there is no option in model). Since there is no direct way to have 90 percentile, instead I am trying using standard deviation (1.…
- Answered
-
Can Admin see which reports Users have accessed?
Hi, Can the admin account see which reports specific users have accessed? Often times client users will ask me questions, but I don't know which report they've looked at specifically.…
- Answered
-
PDF / Document files as a Data Source in Modeller
Hi Avi / Pyramid Dev team, Often, information useful for a Pyramid client is stored in PDF or other document formats - for example where the Pyramid client itself has many suppliers who do not…
- Answered
-
Date Parameter Slicer Issues
I’m new to Pyramid 2020, coming into it from BI Office and struggling to create parameters for date selection. In most of our BI Office reports we created an Advanced Data Set from a Date Hierarchy…
- Answered
-
IMDB Engine and Database Questions
We have several questions regarding the IMDB engine and databases that are created/stored there. Is the memory required for a given database the same as the amount of disk space that the database…
- Answered
-
Waterfall Chart to show the actual growth split by category
We need to build a waterfall chart that shows the LY Sales as the first bar, then shows the Actual Growth split by category, then shows the resulting CY Sales figure.…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help