Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Pareto Analysis
Thread closed.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Market Basket
Thread closed
- VP Product Management
- 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.
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Announcement: Pyramid Office Hours
Yep!
- VP Product Management
- 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
- VP Product Management
- 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,…
- VP Product Management
- 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,…
- VP Product Management
- 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.…
- VP Product Management
- 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.…
- VP Product Management
- 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
- VP Product Management
- 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!…
- VP Product Management
- 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".…
- VP Product Management
- 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.…
- VP Product Management
- 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:
- VP Product Management
- 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:…
- VP Product Management
- 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
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Line chart - multiple items, all one colour
Hi Adam, For Vertical trellis, just move the Geography attribute Chip to the Vertical Trellis drop zone. You can then scale the charts to fit and make a common vertical scale and common X axis to…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures
Hi again, You asked for some examples of creating cumulative totals. This, again, makes use of the upgraded CurrentMember function, usually in combination with the Range function.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: SSAS: Formulate across cubes and/or databases
Hi Markus, The answer remains the same I'm afraid. It is not currently possible to create calculations across Pyramid Models. Of course, you can always query your databases,…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures
Hi Nick, Yes, you can. This relies on the upgraded CurrentMember() PQL function which in 2020.10 returns the Member Name where required instead of just the value.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
BTW - Your cumulative (compound) rate change numbers don't look right. My numbers match exactly the numbers generated by Excel when I prototyped the calculations to make sure I understood them…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
Hi Dan, I have some good news and some (slightly) bad news... The good news is: The (slightly) bad news, or, depending on how you see it, more good news, is that this requires Pyramid 2020.10.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Click or drag to add measure - any difference?
Hi Adam, The Values drop zone lists all the Measures that are taking part in the query. The orange Values Chip represents all the Measures in the Values Drop Zone.…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Motion ranking
In this scenario, we are wanting to keep the query as generated by creating the grid, with Manufacturers sorted within each month. By placing Manufacturers into the colour drop zone,…
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Last updated date & time
@Fadiel Ras Last Process date is available as a system field in v2020.10.xxx due a on a couple of weeks' time. Ian
- VP Product Management
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view

1 19 20 21 22 23 24 25

Back to top

Home

View all topics