Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Column width
Hi @Ricky Melamed You can resize the columns in exactly the same way as you do in excel. Position the cursor over the column dividing line, it changes to a double headed arrow,…
- VP Product Management
- Ian_Macdonald
- yesterday
- Questions & Answers
- Reported - view
Re: Rename the "Grand Total" name in a grid
Hi @Yolanda Heldsinger I don't think so, but V2020 was a long time ago. I would STRONGLY encourage your organisation to upgrade ASAP, as V2020 is end of life as of 31st March 2025 (in like 3 weeks!).…
- VP Product Management
- Ian_Macdonald
- 2 days ago
- Questions & Answers
- Reported - view
Re: is there a way to calculate an mesure avarage for the last year from yestrday?
Marking as answered as no response from poster.
- VP Product Management
- Ian_Macdonald
- 2 days ago
- Questions & Answers
- Reported - view
Re: Rename the "Grand Total" name in a grid
Hi @Yolanda Heldsinger Yes. Add your totals, then click on the down arrow on the "Totals" button and select Column Totals. Click on "Advanced" and you can add your own Sub total and Grand Totals text.…
- VP Product Management
- Ian_Macdonald
- 2 days ago
- 1
- Questions & Answers
- Reported - view
Re: is there a way to calculate an mesure avarage for the last year from yestrday?
Hi @Irad The answer to your question depends on the data source you are using. To give you best answer, we need to know if it is an MDX based source (Microsoft Analysis Services (OLAP or tabular) or…
- VP Product Management
- Ian_Macdonald
- 13 days ago
- Questions & Answers
- Reported - view
Re: Is there a way to calculate a date off of a date parameter?
Hi @Robert Clark To calculate it from the parameter do the following: Add a Member block on your Formulate canvas and select the Parameter (my dates are the start of the month, not the end,…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- 2
- Questions & Answers
- Reported - view
Re: Is it possible to connect a slicer to dynamic text within a tooltip in Present ?
Hi @Alexander Khater Yes, it is. Here we have an image and we're setting a tooltip on it in Illustrate. Enter whatever text you need, then add the Placeholder:…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Pyramid 2024.01 LTS "Fibonacci" has been released

Pyramid 2024.01 LTS "Fibonacci" has been released. This is the first service pack for Pyramid 2024 which only includes fixes for key issues and security updates.…
- VP Product Management
- Ian_Macdonald
- updated 3 wk ago
- 209
- 20
- Product Announcements
Invitation to take part in beta testing of Pyramid 2025 Newton

Hello all who subscribe to this forum! We are continually working to make Pyramid the best platform in the market for solving the most difficult problems through industry leading analytics.…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- 1reply
- 120
- 5
- Product Announcements
Re: Prioritize the Discover level over the Presentation layer when displaying or hiding specific dimensions using the Runtime Settings
Hi @Shuvankar Mondal This is working as designed. If you want a change or enhancement to this functionality, please submit your request through the Product Ideas forum. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Sorting Order gets disrupted when Swap dimension feature is in use
Hi @Shuvankar Mondal This is working as designed. If you want a change or enhancement to this functionality, please submit your request through the Product Ideas forum. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Ability to show just AI chat bot on Hub page
Hi @Robert Clark This functionality is in development and will be available in the next major release, Pyramid 2025 "Newton", due at the end of Q1 2025. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Origin date format isn't recognized by Pyramid as a DATE
np. we're all here to learn
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Origin date format isn't recognized by Pyramid as a DATE
Hi @Ricky Melamed Or use the Convert block from Column Operations. Specify what type you want the column to be, Date, in this case, and how the string of numbers relates to year,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Push Publications to an SFTP Site
Hi @Bruce Campbell This feature is in development and should be available with Pyramid 2025. Hope this helps. Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Target URL Parameterization for Present
Hi @Fabian Frank You can use multiple members from the same hierarchy in your parameterisation by listing the members in the URL, seperated by a colon, : For example: https://<pyramid server>/direct?…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Pyramid 2020 End of Life

By the end of Q1 2025, Pyramid 2020 releases will be considered fully end of life as extended support ends. Pyramid’s support team will take no further tickets for this version after March 31st 2025…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 66
- 1
- Product Announcements
Re: Using a pie graph as a 'link' to open a chart
Hi @Ricky Melamed Create a new presentation called, say, pop up which contains one slide showing the pie chart and the grid: On your original presentation,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to do an vertical union in Pyramid?
Hi @Noel Izoulet , Yes, use the Union block but make sure the table with the most number of columns is linked to the Union block first, then the table with fewer columns,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to bring up a second filter/slicer when selections are made in the first one?
Hi @Rory Sinclair , Your explanation is a little confusing. Can you try again and maybe my feeble brain can understand what you are wanting Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Present
- Reported - view
Re: How to do an outer union in Pyramid?
Hi @Raveena Mariappan Use the JOIN Block and specify "Full Outer Join" in the join type: It doesn't matter what the join fields are. You can see the data from both tables stacked in the preview pane.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: disable Welcome Screen for all Users
Hi @b hoppe It is not possible to disable the initial welcome screen globally when a new user logs into Pyramid, although there is the "Don't Show Again" checkbox, bottom left,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
Hi @Alexander Khater If you use individual images of the separate parts of the body, those can be used directly rather than superimposing the transparent rectangles.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: MTD YTD QTD manual functions
No reply for more than a month. Marking as answered.
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
Hi @Alexander Khater “Execute JavaScript” is not the right way to go to achieve what you are after. This Jump Action is designed to run JavaScript code,…
Attachment
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view

1 2 3 4 5 23

Back to top

Home

View all topics