-
Sub Total Color Formatting - to be exported in Excel
Hi Team, Need your help on getting color formatting on sub totals and same to be exported with color to the excel. Please guide how we can achieve the same.…
-
Is there a way to set a process to automatically copy a presentation from folder to another?
I want to set a schedule that moves a copy of a presentation from my pre-prod folder to my prod folder. I want it to overwrite the copy every time. Is there a way to do this via the API or some other…
-
Congratulations – Level 3 Certified: Mary Cecilia Siluvai - Tigma Tech
Pyramid Certified Level 3 Announcement Congratulations to Mary Cecilia Siluvai and Tigma Tech for being the first global partner with a full dozen certified consultants!…
-
How do I add the Tooltip for the last element in a Waterfall Chart
Hello PA-team! Tooltip Issue for the Total Element There is currently an issue with the tooltip functionality for the generated last element (Total) in the Waterfall chart.…
-
How can we give a specific colour to Subtotals in a schema?
Hi, I found this older discussion in the Q&As, https://community.pyramidanalytics.com/t/g9hqrlc/how-can-we-identify-which-part-of-a-theme-to-change can anyone please guide where we can give color to…
- Answered
-
Access Multiselect Parameters values in Formulate
Hi, I’m trying to access multiselect parameters in Pyramid Analytics. Specifically, when using multiselect parameters in a dynamic caption, only the first selected value is shown,…
- Answered
-
How to define a Design Theme for grids with a single-color background?
I'm afraid this is almost becoming a feature request, but maybe I've overlooked something... I would like to define a Design Theme that provides a completely single-color background for grids, e.g.…
- Answered
-
How can we identify which part of a theme to change?
Wondering if there is some kind of documentation that would help me identify which part of a theme to update to have the impact I'm wanting in a Discovery.…
- Answered
-
Calculating percentiles
Hi. I'm trying to get some percentiles (10,25,50,75,90) from my data. First, I tried with the percentile PQL function, but it has the restriction of being attached to the Dimension provided in the…
- Answered
-
How to create quantities sales report
Hi, I coudn't find answer on my question anyware so just creating new topic... I want to create a report for specific departments and subdepartments which will show me units sales of all product…
- Answered
-
Alternate header row shading
I'd like to extend the alternate shading to the header row and not just the data rows. How do I go about that? I didn't see anywhere in formatting to do this.…
- Answered
-
Date Range Slicer for Two Dates on a table
Hello, I have two dates in my table: Contract Date and Execution Date. I do not need to apply the date range slicers on both dates at the same time. I am using @Param to create the First and the Last…
- Answered
-
Sorting on Multiple Columns in Model
Hello Community, I have a use case where I need to sort a data set first on column A and then, retaining this order, on column B. From what I gathered, the Sort node allows only one column at a time.…
- Answered
-
Add a total line to a graph.
Hi I have a person wanting a chart they can do in Tableau. In the picture attached the graph shows this information from Pyramid. The chart shows above the sections a total line.…
- Answered
-
Where can I find the query text information in the Pyramid repository database?
I'm building a transaction logs dashboard and can get most details from the transactionView table, but I can't find the query text information. Is the query text stored in the Pyramid repository…
- Answered
-
Pyramid Community Weekly Wrap Up - Oct 18th 2024
Dear Community, I’m thrilled to highlight some fantastic LinkedIn accounts that have recently begun sharing insights within the Pyramid Ecosystem, each showcasing unique aspects of our industry.…
-
How to add a CountRows Functionality in Pyramid
Hi Pyramid team, I would like to request the addition of CountRows functionality in Pyramid, similar to the feature in DAX (Power BI). Currently, we need a function that can count the number of rows…
- Answered
-
Dashboard Gallery: Population Survey
Dashboard Gallery: Population Survey This Dashboard on population data based on an open data source has been developed as quick showcase on how to structure and display data in a attractive way.…
-
Learning Hub Course: Basic Dashboard Design Principles
Dive Deeper into Pyramid Use Cases with the Learning Hub The Use Case: Improving an existing dashboard This course, designed for professional license holders,…
-
Congratulations – Level 3 Certified: Surya Sankar - KASH TECH
Pyramid Certified Level 3 Announcement Congratulations to Surya Sankar and to KASH TECH, who added their second Level 3 Certified Consultant in short time.…
-
How do I select multiple reports or formulates to open at once
Sometimes we're editing a set of reports at once or multiple formulates, it would be helpful to be able to multi-select pieces of content and open them all at once instead of having to do it…
- Answered
-
Using same parameter for same model but pointing at different tables
Hi All, I have a model that creates some simple data sets. They are linked by location but each of them also have a parameter of "online sale" where a column states 1 or 0.…
- Answered
-
Using measure as an attribute
While working on a report I came across this issue: I have a list of accounts/ For each account, I have the number of days in which it was recommended. “Count recommendation date” is a measure that…
- Answered
-
Pyramid Community Weekly Wrap Up - Oct 11th 2024
Dear Community, Reflecting on the past four User Groups, we’re considering how we can improve in 2025. We want to know the best direction for our Webinars and Meetups.…
-
Maps in Pyramid
Hi, I am struggling to create a map at a region level for kenya, there is region level data in the model as you can see in the first snip below, however when I try to use this data to build a map at…
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
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