Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
OK, So in 2023 you have to create a new measure for one of your series and sort by that. Here's Manufacturers sales split by Gender: Create a custom Measure of Sales for Males:…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
@Alexander Khater You mean 2023.17.029?
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Need help with a new list
Hi @Ricky Melamed I'm sorry, but I don't understand what it is you are trying to achieve. Can you explain in a different way? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: How to get a Discovery Bar Graph to Sort by One Specific Group ?
Hi @Alexander Khater What version of Pyramid are you using? Ian
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Hide/Show dimensions with slicers
Hi @Ricky Melamed That's certainly one way to do it and it allows you to be very prescriptive about what dimensions are shown. For full flexibility, users can access the right click context menu to…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed Use the RANGE function in combination with CurrentPeriod and Lag() to set the start and end of the range. Aggregate the days returned:…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Measure appearing in a separate row using lag date formulate
Hi @Jashanpreet Sandhu It appears in the John Smith row because that is the loan officer it is related to. Jane Doe doesn't have a prior period balance in the same way John Smith doesn't have a…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: create hierarchy without access to the model
Hi @Ricky Melamed This functionality is planned for Pyramid 2025.01, due end of June / beginning July. It will be known as Report Specific Hierarchies. While these will behave like any other regular…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Measure appearing in a separate row using lag date formulate
Hi @Jashanpreet Sandhu I don't understand. It IS showing in the same row as John Smith. Can you explain further? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Previous Month Dimension Value
Hi @Mad Amruthur You have to remember that Pyramid Models are Dimensional in nature. Thus each unique value in a column in the underlying table makes up the Members of Hierarchy based on that column.…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Selecting Multiple Dimensions at Once
@Ricky Melamed Yes, open the constructed hierarchy in Formulate and add whatever characters you like and save: Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Lien entre différentes requêtes dans un modèle qui ne fonctionne plus
Hi @Pinvidic Julie First thing is to run the Analyzer against the Present. This will identify any mismatches in your analytic objects and your Model definition and guide you on how to resolve them.…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Selecting Multiple Dimensions at Once
Hi @John Fonte No, you cannot do this currently. You can "Combine" multiple hierarchies and then use the combined hierarchy, use CTRL-Click for disparate items,…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Using CustomerID instead of their address to look up location
Hi @Stefano Sena OK, but Google maps knows nothing about your Customer ID. All it knows is how to plot a lat/long on the map, geocoded from the address you are passing to it.…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Using CustomerID instead of their address to look up location
Hi @Stefano Sena You can use anything you like to filter the data before you send it onto Google Maps. I'm not quite sure what it is you are asking. Can you please clarify? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Questions About Altering Available Print/Export Options
Hi @Alexander Khater You an turn off the ability to Export/Print from Present using the Runtime Settings. You can only turn this functionality on or off,…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Synchronization of two slicers
Hi @Jona Löneke Have you considered or looked at Model Mapping? This allows you to map one dimension to another so that a single slicer can affect analytic content from different models or different…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Interaction between P&L and waterfall chart
Hi @Jona Löneke Yes, this is possible, You will need to use a dynamic set driven by a parameter that returns the children of the selected row in the Accounts hierarchy.…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Is it possible to do a "Count IF" in a Dynamic Text data set?
Bah! @imbar beat me to it. Had exactly the same Loop() code as him! Ian
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi @Ananth Periyasamy I have a workaround for this, although it does require the forthcoming release, 2025.01, which supports the StrtoSet() function for Measures. Prior to 2025.…
- VP Product Management
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Text indicator to show % change from previous period
@Ricky Melamed Have a read of this Help page and this page for an example. hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed It works fine for me: Make sure you've saved your Discover before putting it on the Present slide. For the list, select your Years individually in the Standard List block (don't use…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed This is not the right way to think about this type of calculation. It is a semantic calculation, not a table row calculation. I.e. it uses the dimensional model in order to perform…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed Taking my assumption above as true, there are numerous ways you can achieve this, here's one of them. Create a new Formulate calculation against your model and drag the "Current…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed I'm assuming you mean the year to last year same date as this year? So today, the YTD 2024 would be the cumulative value up to 18th April 2024? I.e.…
- VP Product Management
- Ian_Macdonald
- 9 mths ago
- Questions & Answers
- Reported - view

1 3 4 5 6 7 29

Back to top

Home

View all topics