Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Making a population pyramid chart - specify total for %, and reverse axis direction
Hi Adam, The Tornado chart was included in the 2020.11 release. It seems, for some reason, somehow, that the partners server has escaped the upgrade process!…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Trouble Drilling up
This is working as designed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Switching from AD to SAML
Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: #run_time_error
Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Twitter Source questions
Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How to Update Pyramid 2018 to the latest version.
Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Model Parameter Default Value
Not directly, but you could define a custom member "default" that is whatever the member is you want as your default and add that to the parameter list. Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: user Profiles not working with AD-group-users
Please consult Help: https://help.pyramidanalytics.com/Content/Root/AdminClient/access/Profiles.htm?Highlight=profile Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: data retrieval
Use Formulate to calculate current and previous week values based on a parameter of week number. Show these in your report. Select "Last" as the default wee number.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Pareto Analysis
Thread closed.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Market Basket
Thread closed
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Can I Publish to pdf and have Discoveries wrap onto subsequent pages?
"Flow" grids and charts are now provided that address this. Please check out the latest release.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Announcement: Pyramid Office Hours
Yep!
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: In Explore Further is there any easy way to filter out records with $0 measures?
Hi Robert, You can use the extended Quick Filter options available with later releases of Pyramid (as of 2020.12): Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Hiding an item from the legend?
Hi Adam, You can hide the legend entirely, but not just part of it. Is the intended destination of this discovery to be on a dashboard in Present? If so,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Date Parameters
Yes. Create a List of Years by selecting the All checkbox. This will create a List that will contain all the values of Years dynamically at runtime. Thus next year,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Switch dimensions in a bar/column chart
Another option would be to attach an action to the chart in the Dashboard Presentation and jump to another Discover view that used the other attribute.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Switch dimensions in a bar/column chart
Hi Sam, We included in Pyramid 2020.10 additional options, Swap and Add in the right-click menu when working with analytic content in Discover and Dashboards.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Population pyramid part 2 - axis extents
Tornado charts are included in the latest patch release (2020.11) and automatically balance the axis scales. See my reply to your other post on this for examples. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Making a population pyramid chart - specify total for %, and reverse axis direction
Hi Adam, Yesterday we pushed the latest Patch release for Pyramid. Good news is that we have included Tornado charts so all our messing about re above has now gone away! Yay!…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Percent of Parent Calculation
To add to Jason's informative post above, there are a couple things to be aware of when working with SQL hierarchies in this way. First, the hierarchy must be defined as type "Regular".…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Making a population pyramid chart - specify total for %, and reverse axis direction
Hi Adam, The % of Total created from the slide off is what we call a "Context" calculation, i.e. it is performed in the context of the query, rather than against the model.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Line chart - multiple items, all one colour
Correct. Make sure when you drop the RGB colour measure into the colour drop zone that you choose the "Custom Colors" option:
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
Hi Dan, Re-examining your grid I now better understand the algorithm you are using to calculate your compound rate change column. Here's the result, which matches your Excel grid:…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: change start of week in Data Flow (Advanced Time Intelligence)
Hi Fadiel, This is fixed in 2020.10. Please upgrade and retest. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view

1 16 17 18 19 20 21 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Making a population pyramid chart - specify total for %, and reverse axis direction

Re: Trouble Drilling up

Re: Switching from AD to SAML

Re: #run_time_error

Re: Twitter Source questions

Re: How to Update Pyramid 2018 to the latest version.

Re: Model Parameter Default Value

Re: user Profiles not working with AD-group-users

Re: data retrieval

Re: Pareto Analysis

Re: Market Basket

Re: Can I Publish to pdf and have Discoveries wrap onto subsequent pages?

Re: Announcement: Pyramid Office Hours

Re: In Explore Further is there any easy way to filter out records with $0 measures?

Re: Hiding an item from the legend?

Re: Dynamic Date Parameters

Re: Switch dimensions in a bar/column chart

Re: Switch dimensions in a bar/column chart

Re: Population pyramid part 2 - axis extents

Re: Making a population pyramid chart - specify total for %, and reverse axis direction

Re: Percent of Parent Calculation

Re: Making a population pyramid chart - specify total for %, and reverse axis direction

Re: Line chart - multiple items, all one colour

Re: Cumulative Rate Changes

Re: change start of week in Data Flow (Advanced Time Intelligence)

Home