Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Motion ranking
Make sure the Category drop zone is empty. Items (Manufacturers in my case) chip in Colour and Months in Motion for the Column chart.
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Motion ranking
Hi Adam, Your post needs to be approved by the moderators of the forum before it appears in the Q&A, so that's why your post does not appear immediately.…
Attachment
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Unique Customers count that bought multiple items at a site
Quick clarification. You say guns, bows, ammo etc are attributes. Is that correct or are they members of a product attribute, like say product category?
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Drill Through within Measure?
Angela, I'm currently writing up a blog on this topic, I'll post a link here when it is ready. Meanwhile, I notice from your example report that you are connecting to a SQLServer Analysis Services…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Blank Pages
Hi Wayne, Yes there is. Take a look at Page Triggers in Publications. This allows you to test on values in a grid and then decide whether or not to print that page.…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Load a whole folder and append multiple same-structure CSV file
Hi Gauthier, I've moved this post from the BI Office (our old platform) Q&A to the Pyramid Q&A as you had accidentally posted it to the wrong Forum! The functionality you want exists today in the…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Find Difference between two dates
Hi, There is a Pyramid function DateDiff() that can be using in formulate to calculate the difference between two dates in various units. See https://help.pyramidanalytics.…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Stacked Visualizations
Hi, Please try this again. Later releases of Pyramid have enhancements to many chart formatting requirements, including multiple stacked measures: Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view

1 20 21 22 23 24 25 26

Back to top

Home

View all topics