Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: PQL for checking if date is null
Hi Paul, There is a clue in your question, "it would check every row", that leads me to think this is not a semantic calculation, but a row / table calculation.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Custom user dimension linked to a specific e-mail account
Hi Dolf, Here's how you might do it to create a list of names that have a specific email domain: First, create a list of emails that contain the domain you require.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Sortting on aggregated measure on PostgreSQL
Hi all, Non numeric values in measures are currently handled as NULL or zero. This allows the handling of strings in Measures, which are in many other products exclusively numeric items,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Custom user dimension linked to a specific e-mail account
Hi Dolf, You are sure you need to create a new dimension / hierarchy that only contains email address equal to "gmail.com"? Or are you rather looking to create a List of users with that suffix?…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?
Hi Paul, Working as designed. The actual database join defined by the model is shown in your red box. This is the join which will be passed down to the database as part of the query generated by…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Answer
- Reported - view
Re: Cascading parameters
Hi Dave, You can't cascade global parameters in that fashion, there is no mechanism to set the value of one global parameter directly from another. However,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Official response
- Reported - view
Re: Text parameter which retrieves date ranges
Hi Dave, Is this the same question as the cascading parameters? If so, I've answered that one. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Date filters allow range and null selection
Hi Paul, Create a parameter that contains all your "proper dates": Create a List that includes the null dates ("--") Member and the Parameter: Select the List: Se the Parameter to be of type Calendar:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Official response
- Reported - view
Re: PQL for checking if date is null
Hi Paul, When Pyramid constructs its Semantic Model, each attribute / hierarchy that results is a list of unique values from the originating column. In the case of dates,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Answer
- Reported - view
Re: Can R or Python models be easily imported into a Data Model?
Hi Robert, Yes, but it kind of depends on what they do and how they're written. You can either copy and paste the script into an R or Python block in the Data Flow,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Official response
- Reported - view
Re: Date filters allow range and null selection
Hi Paul, Can I clarify a couple of things with you? Are you looking to retrieve rows for, say, a sales transaction, where the date column has not been recorded and is null, or,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Cascading parameters
Hi Dave, The answer is broadly, yes, but if you can provide an example, of what you want to achieve, I can show how that might be implemented. Cheers, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Identifying Duplicated Elements
Hi Jenny, In your hierarchies panel, right click on Product and choose "Aggregate / Count". Your menu may look different to mine as you will be on an earlier release,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Identifying Duplicated Elements
Thanks Jenny, Yes, it should be. One more question, is your Status field in the same table as the Product Field? If not, how are the two related? Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Identifying Duplicated Elements
Hi Jenny, This problem falls into the category that requires analysis / calculation from the underlying table of data that makes up your dimension / attributes.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Multi-measure pie charts
Hi dgf, It is unusual in most data analytics models to have multiple Measures that together make up the total of that Measure. Usually there is a single Measure and that is split out by the Members…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Get data from 2 months ago
Hi dgf, The first thing we need to do is establish the current month and the previous month. There are many ways we could do this, but an elegant and simple way is to use your existing data to do…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Analyse Further Multiple Measures on 1 Line Chart
FYI, everybody, it ha been brought to my attention that my answer above applies to Pyramid 2023. Another good reason to upgrade! Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: real time data refresh
@Ilya Tsyrulnik https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Present/Present%20Pro/functions/Presentation%20Timer.htm?Highlight=auto%20refresh
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: real time data refresh
Hi Ilya, Yes, for Presentations. In the Presentation Tab menu you should find this button: Click on this and you can set either to cycle through the slides,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Analyse Further Multiple Measures on 1 Line Chart
Hi Natalie-Anne, It works for me. When you take the second measure, hover it over the "Values" heading in the DropZone and you should get a slide off "Y2 Axis" option,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: LineBreak in a measure
Hi Michael, No, there does not appear to be a way to do this. Sorry, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Get data from 2 months ago
Hi dgf, There are a number of different ways you can achieve this. To find the best solution for your specific requirements we'll need to know a little bit more about how you want to use the…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Decision Intelligence Blog: Reports, Dashboarding and Color Blindness
Great content Sandra, thanks! As a follow up, there is a section in our Help on creating accessible content, a downloadable PDF guide with examples and a downloadable PDF of Pyramid VPAT declaration.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Tech Blogs & Webinars
- Reported - view
Re: Decision Intelligence Blog: How to choose the right calculation method in Pyramid
Hi Debora, Thanks for your contribution, it's great to see our customers and partners sharing and learning together! Knowing which calculation type to use is very important in order to get the right…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 3
- Tech Blogs & Webinars
- Reported - view

1 8 9 10 11 12 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: PQL for checking if date is null

Re: Custom user dimension linked to a specific e-mail account

Re: Sortting on aggregated measure on PostgreSQL

Re: Custom user dimension linked to a specific e-mail account

Re: Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?

Re: Cascading parameters

Re: Text parameter which retrieves date ranges

Re: Date filters allow range and null selection

Re: PQL for checking if date is null

Re: Can R or Python models be easily imported into a Data Model?

Re: Date filters allow range and null selection

Re: Cascading parameters

Re: Identifying Duplicated Elements

Re: Identifying Duplicated Elements

Re: Identifying Duplicated Elements

Re: Multi-measure pie charts

Re: Get data from 2 months ago

Re: Analyse Further Multiple Measures on 1 Line Chart

Re: real time data refresh

Re: real time data refresh

Re: Analyse Further Multiple Measures on 1 Line Chart

Re: LineBreak in a measure

Re: Get data from 2 months ago

Re: Decision Intelligence Blog: Reports, Dashboarding and Color Blindness

Re: Decision Intelligence Blog: How to choose the right calculation method in Pyramid

Home