Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Indicator to ONLY the total/subtotal
Hi @Ricky Melamed Unfortunately not directly from the Totals / Conditional Formatting / Indicator options. Maybe you could ask for this as an enhancement request in the Product Ideas Forum.…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Last month of Quarter - Date Lists & Formulates
Hi @Jashanpreet Sandhu Do you have any other Time attributes derived from these dates, like Year, Quarter, or Month? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Connecting buttons to a slicer to display lists
Hi @Ricky Melamed You need to create and use a "Switch List" and assign that to the slicer. Here's my global slicer with my three groups. Create a new dynamic list against your model and drag and…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Malcolm Green Ok, buckle up because this is going to be a wild ride! Let’s take a step back and consider the problem. While the Date dimension has Development Months 1 – 19,…
Attachment
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Malcolm Green This is quite tricky. The triangle bit is straightforward (BTW a simpler Left Outer join on the Year and Month is all that is necessary),…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Comparing dates in a formula
Hi @Robert Clark You must remember that the Pyramid models are dimensional in nature. Thus, each dimension (hierarchy/attribute) is independent of the others,…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Malcolm Green Could you post here your excel sheet that contains the data used in your example above? Or more if you have it. I can then replicate your model and see if I can provide an answer.…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Help Getting Stacked Bar Plot to Use a Consistent Set of Colors
Hi @Alexander Khater Yes. Go have a read up on Pyramid Member Color Lock. that should give you what you want. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Monthly percentage of annual value
OK, I've created a periods dimension of Quarter number, Month and Day number. Build a % Total Measure that is Sales / Sales for all four quarters. Then add Year as a filter in your Chart to show the…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Monthly percentage of annual value
Hi @Josephine I'm not sure why the context (visual) calcs are not showing up as expected, maybe your profle has then turned off. Anyway, you can chieve what you need by selected the "Ancestor" option…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: create hierarchy without access to the model
@Ricky Melamed Unfortunately, no.
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Configuring FTP Source with Host, User, and .ppk File
hi @Raveena Mariappan It doesn't appear so. There is no option in the Data Source Card for FTPS to add a .ppk file. Sorry. Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
@Ray Buechler BTW... Outside of the Pyramid Usage model shipped with the product, any access to the Repository tables are not supported. Thus there is the potential that should the repository schema…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
@Ray Buechler In your model, sort the Year Weeks by the Week Start Date column from Time Intelligence;
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Need help with Dynamic Place Holder - Adddays (business days) to date
Hi @Jashanpreet Sandhu OK, so if your Model only contains working days, with no weekends or public holidays, then you can use that to determine the comparative period rather than trying to calculate…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
The Week Year sort is defined in he model and gives the correct sequence, so no sorting is required: Ian
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Need help with Dynamic Place Holder - Adddays (business days) to date
Hi @Jashanpreet Sandhu What do you mean by business days? Not including weekends? Or accounting for public holidays? (That gets v complicated as it depends on which country the user is in.…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Show Data for the most recent full week
Hi @Ray Buechler Easiest way is to use dynamic lists. Create a list of all the Year Weeks: Then filter for the Last 2: Then filter for the First 1: Then use this list in your Discover: Now,…
- VP Product Management
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Need help with a new list
@Obee1 Fair enough!
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Need help with a new list
@Ricky Melamed Not much difference really. Ian
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Metadata Management for Data Governance
@Mad Amruthur As mentioned above, the integration needs to be FROM the meta data management tools, rather than us building a connector TO them. We're monitoring this scenario and are reviewing…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Metadata Management for Data Governance
Hi @Mad Amruthur No replies in a month so marking this as answered (i.e. no answers forthcoming). Best option would be to approach those meta data management companies and ask them to integrate with…
- 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 ?
@Ricky Melamed By using the new Sort Wizard, as above or in the Panel as you would in 2023. 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 ?
@Alexander Khater In fact, you can do this in the Sort panel in 2023 without creating the new Measure: My bad! Ian
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Need help with a new list
Hi @Ricky Melamed You'll need to create a Custom Column to do this, essentially building a new "Number" dimension that maps to the letters as you have described them.…
- VP Product Management
- Ian_Macdonald
- 7 mths ago
- 2
- Questions & Answers
- Reported - view

1 2 3 4 5 29

Back to top

Home

View all topics