Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How Do I Use A Small Font Size In Questions And Answers?
Marking this as answered since there has been no response to requests for further information.
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculating a CLV measure
Marking this as answered since there has been no response.
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Scheduled Model Refresh not showing under Schedule Listing
Hi Dan, David, Can you please let us know what version of Pyramid you are using where you see this behaviour? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date Parameter Slicer Issues
@Jon Wright Great!
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Adding Hyperlink to text in Publish
Hi Aaron, Use the HyperLink() function in dynamic text: I know you said "no code", but this is very simple! You will need a query associated with the dynamic Text,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date Parameter Slicer Issues
Hi Jon, Apologies that this has gone unanswered for so long. Is this still relevant or have you resolved your issues? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Hi Markus, Please retest in the current version (2020.20). Regards, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculate a dimension value (numeric)
Hi Nicholas, It's been some time since you posted, is this still relevant to you? If you can relate your currency and date and value to convert, then yes, it should be straightforward calculation.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Rotate table header text?
Hi Adam, Unfortunately this is not yet supported. Make an entry in the Product Ideas forum. In
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
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

1 18 19 20 21 22 26

Back to top

Home

View all topics