Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: interactions across column charts
Hi Robin, We do not support "brushing" in the way that you describe it, but you should be able to set the interactions so that if I select the cost on a set of products,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Analysis Services Dynamic Management Views as IMDB Data Source
Hi Alistair, Unfortunately what you are asking for is not currently possible in Pyramid. Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How Do I Use A Small Font Size In Questions And Answers?
Hi Elizabeth, Can you explain a bit more what you are trying to achieve and in which part of Pyramid? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Display weather on map with data points
Hi Rob, You should be able to pass the address(es) to a weather mapping sites via their API using Dynamic Text to construct the URL with arguments to open that website in a a web panel on a…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, Can you supply the requested information? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Presentation has no charts due to measures calculated
Hi Kate, Can you supply the requested information? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date Calendar Slicer Load Time Settings
Hi Kimaal, The latest version of Pyramid, 2020.20, supports this: Go to the settings for the slicer, select Load Time, then Functional, then Last Date. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Additions to conditional formatting
Hi Ove, Is this an enhancement request or a request for help in creating? It isn't clear. If the former, please submit in the Product Ideas forum, otherwise if you could provide an example visual of…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculating a CLV measure
Hi Kate, Is the above possible? We need a little more information to be able to help you effectively. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Truncating decimal numbers in dimensions
Hi Sophie, In your data flow in the model, add a calculated field into the table that contains the Rate field, Format it using the Format() function. This will format the decimal to the required…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Create a new member in your [Core Reference] Dimension, like [My Calc] such that it equals: ([Core Reference].[Singular Core Ref - Latest YOA],[Measures].[Amount CAD])/ ([Core Reference].…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, The expression I provided returns a string. Use ConvertToNumber() to change it into a numeric and it will then work. BTW, I would be interested in what your final calculation is.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Here's what I've come up with. Consider this grid: As per your example, I want to find the number of the column that contains the last non null value for a specific row moving form left to…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Just so I am sure, you want the column number that contains the last occurrence across the row of a value for both AmountCAD AND CAD Developed % Latest.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Text - Getting max used columns data
Hi Dan, Can you be a little more precise in how the specific column is selected? Must all the rows be populated with values? Is it the column with highest total of values? Or both?…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Great! I still think there is something not right with the data though, or maybe just that it is represented in a different way than my example, as I did not need that kind of logic to suppress…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculating a CLV measure
Hi Kate, Can you give an example of your data and the calculations you want to perform and how you want to present them ? Maybe some dummy data in excel or something. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Rob, I can only surmise there is underlying data present for some reason. If you create a report with Date of Loss Year and Development Period both on rows and use the raw data measure that you…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Combine members of different dimensions as a new dimension
Hi Dolf, I suspect this is a calculation you would have to perform in the Data Flow for the model you are building. If it is an existing MDX based model (SSAS or BW) then it may not be possible.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Presentation has no charts due to measures calculated
Hi Kate, Can you please explain in a little more detail your difficulty? Maye with some screenshots to help us understand what your problem is. Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Stacked and non stacked chart together
Hi Nick, Bit of a tricky one this, as while we can create composite charts of Line & Column, the stacked column chart is a variation of the column chart and we cannot currently create composite…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Europe Design Theme
Hi Kate, I've exported the Europe theme and attached it to this post. To import, from the themes section in Admin, click on Import theme: Hope that helps. Ian
Attachment
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Can you drill down by column instead of cell?
Hi Erik, To create a Variable List, or if you like, a List of Lists, you need to select more than one List to create the List of Lists. In your screenshot above you only have one list selected,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, Can you explain a little more on why you cannot apply the English names in the meta data overlay to the USA role? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Listing all the dimensions of a hierarchy in a Discovery
Hi guys, Regular Hierarchies defined in Pyramid behave the same as hierarchies defined in a SSAS cube, in that as you drill up and down, the column remains the same (the hierarchy name).…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view

1 16 17 18 19 20 24

Back to top

Home

View all topics