-
How to build Aggregate blocks for a Dimension
How to build Aggregate blocks for a Dimension When you are working with larger lists it is often necessary to define groups of elements into a single aggregated element that contains the totals for a…
-
Automatically save Present filters to original discovery report
Hello Pyramid Community: I need the filters applied in "Present" mojo to be automatically saved in a original "Discovery Report" What is the more efficient way to configure this?
- Answered
-
Log Storage Table in Pyramid Repository Database
I want to make the system logs and scheduled job logs visible to users by creating a dashboard in Pyramid. Is there a table in the Pyramid repository database that stores these logs? If so,…
- Answered
-
Congratulations – Level 3 Certified: Arunkumar Kuppusamy - Tigma Tech
Pyramid Certified Level 3 Announcement Tigma Tech add another consultant to their team, shortly after Nanmaran, Aunrkumar Kuppusamy also has taken his Level 3 Exam and passed the Certification…
-
Is there a way to get the modelId for the /API3/dataSources/addRolesToModel API without using the Admin Console?
The /API3/dataSources/addRolesToModel API requires an itemId as an input parameter. To obtain the itemId, I currently need to navigate through the Admin Console by going to Source Manager >…
- Answered
-
Fixed Static Parameter
Hi I'm new to Pyramid. How do I create in a report or KPI that has a fixed static parameter please. I want a report or KPI that counts a distinct value when a range is between 1 and 1000.…
- Answered
-
How can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- Answered
-
Congratulations – Level 3 Certified: Mark Davis - Camden AI
Pyramid Certified Level 3 Announcement Mark is the second Consultant from Camden AI, who completed his Level 3 certification in the past few days. The final exam means building a full solution and…
-
How to Limit Color Logic to a Single Column
In the screenshot, there is a color-coded "Med Surg Supply Cost / Equiv. Patient Day" measure, where the red-green split is based off the average of those values. How do I 1.…
- Answered
-
Pyramid Community Weekly Wrap Up - August 2nd 2024
Dear Community, what a boost in activity. Just look at the list of new joiners, WOW! (Welcome to you all, can't wait for your questions.) PLUS, we secured amazing speakers for the upcoming User…
-
Formatting For Multi-Select Drop Down
Is there a way to make the search box in the multi-select drop down the same size as the slicer elements? It seems I can change the size of the elements but the search box stays the same size.
- Answered
-
Congratulations – Level 3 Certified: Elon Blackman - Camden AI
Pyramid Certified Level 3 Announcement We are proud to add Camden AI to the list of our Partners who list fully certified Consultants in their ranks working from the UK.…
-
Enhancing Accessibility in Data Analytics: The Importance of Dyslexic-Friendly Fonts
Guest Blog - Enhancing Accessibility The Importance of Dyslexic-Friendly Fonts After my Blogs on the general Management of Data Analytics Projects I would like to add another angle to your Business…
-
Display Text Value Instead of Numeric Value
I have three columns one language column, gender column and count column (numeric). Inside my language column I have different languages as text , inside my gender column I have more than three…
- Answered
-
Difference in Filters
In Model, what is the difference between filtering on a table node and with a filter node? 1. Filter on the Table node: 2. Filter node after the month:
- Answered
-
AVG OF WEEKDAY AND WEEKENDS
I have two columns weekday column and count column I want to find the average for each day and weekends based on month or year …How can we achieve this ?
- Answered
-
Dynamic caption for lag member
Hi, I want to add a dynamic caption, which displays the member name rather than the name of my formula. My formula finds the lag 4 of a member which is selected through a parameter.…
- Answered
-
Pyramid Community Weekly Wrap Up - July 26th 2024
Dear Community, What camp are you in? Exited that the Olympic Games are starting? Or more like Churchill: NO SPORTS? What I like most about these big games is,…
-
Last 'N' dates list Based on Date Filter
I want to get the list of last 90 days based on Date Parameter ( Date filter Selection). How can we achieve this ?
- Answered
-
Create Patterns Within Bar Graphs
Hi, Does anyone know to create patterns within a bar graph? Right now there is a "pattern" option but it does not create a pattern within a solid bar graph.…
- Answered
-
Mapping with "Layers"
Is it possible to add addresses to the shown example of a map of a sales area color coded by amount of sales? If so, how would I do that? TY
- Answered
-
Tiled Layout Inside Fixed layout in same presentation
I have three slides in a presentation that I initially set to a fixed layout. Now, I want to insert a fourth slide in the same presentation using a tiled layout. How can I achieve this?
- Answered
-
Getting your OpenAI API key
Pyramid does not support GPT-3.5. You will need to generate a GPT-4 API key. Follow these steps to get started: Step 1: Obtain an API Key To begin using GPT-4, you'll need an API key from OpenAI.…
-
Pyramid Community Weekly Wrap Up - July 19th 2024
Dear Community, looking at the participation and visits in the community I can see that the summer holiday season has begun. Or have you been distracted by the UEFA EURO (will not mention who won)…
-
Charts Customization
I have male female COUNTS in gender column .The requirement is that the SVG should be filled only for the count based on gender. For example if male count is 40 and female count is 60 ,…
- Answered



