Malcolm Green's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Augmented Insure

Country

Latest Posts

Re: Filter a second dimension based on the value of a first dimension in Discover
@Imbar Just one further question if I may. At the moment this works when the RANGE is based on a parameter. I was wondering whether it is possible to based it on a value from a slicer? For example,…
- Malcolm_Green
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Thank you @Imbar . That has worked a treat.
- Malcolm_Green
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Imbar , This is an interesting approach and I will see if I can get this working. Thank you so much for your input. Regards, Malcolm
- Malcolm_Green
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Ian Macdonald , I am still working my way through this as, as you said, it is a wild ride. I suppose the thing that is frustrating is that from an SQL perspective all I am trying to achieve is…
- Malcolm_Green
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Wow - thank you @Ian Macdonald . I will digest and come back with any questions.
- Malcolm_Green
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
Hi @Ian Macdonald, many thanks for your reply. I have had a quick look at those posts but will need to take a proper look - they are very involved! I was hoping to not have to create new measures,…
- Malcolm_Green
- 7 mths ago
- Questions & Answers
- Reported - view
Filter a second dimension based on the value of a first dimension in Discover

Contents Hi Community, Please bare with me whilst I try to explain what I am trying to achieve. This is a very slimmed down example, but suffice to say,…
- Malcolm_Green
- 7 mths ago
- 13replies
- 188
- Questions & Answers
- Answered
- Answered
Re: Filtering on 2 dimensions and counts
Thanks @Obee1. Interestingly, I did this trick for another requirement but never thought of it for this one. I will try it out.
- Malcolm_Green
- 9 mths ago
- Questions & Answers
- Reported - view
Filtering on 2 dimensions and counts

Hi community, I am struggling to do something that I think should be possible so asking for help here I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…
- Malcolm_Green
- updated 9 mths ago
- 2replies
- 73
- Questions & Answers
- Answered
- Answered

Back to top

Home

View all topics