Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
- 2 days 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
- 3 days ago
- 1
- Questions & Answers
- Reported - view
Re: Different Behaviour with IF and SWITCH/CASE
Hi @Mad Amruthur Your case statement is missing the hierarchy name, so it will always return false. Ian
- VP Product Management
- Ian_Macdonald
- 4 days ago
- 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 days 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
- 11 days 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
- 11 days 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 4 wk 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
- 4 wk 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Netto_workdays
Hi @Stefan La Rooij Here's an example of what @Obee1 is talking about: Open Formulate and select Custom Column, then choose your model. Add the DateDiff block and select the first date,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: How to disable slicer drop Down option in presentation
Hi @Shahzad Rizwan Err, if you don't want the user to change the slicer value, why have the slicer at all? In your underlying Discover, select the single member from the dimension you want to slice…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Interactive Data to change pricing
Hi @Ricky Melamed Pyramid Grids have a plethora of formatting options, but we would concede that it not in the same league as Excel. For this type of "Last Mile" formatting,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi @Ananth Periyasamy Measures in a slicer and Measures based Parameters do not support Multi Select as an option. I tried a number of approaches as a workaround but hit roadblocks in each one.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Date Data Points
@Mad Amruthur It works for me. Try clearing your browser cache and try again. Hope this helps, Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Need guide on 2025 Feature || New option to print a single visual in a presentation, rather than the entire slide.
Hi @Shuvankar Mondal Where the print option is located in the context menu will depend on which context menu option has bee applied in your settings. The Help section you included mentions this.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Date Data Points
hi @Mad Amruthur Before we get onto the calculation side of things, you should set up your aggregate properties of your model correctly for this type of Measure.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view

1 2 3 4 5 25

Back to top

Home

View all topics