Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Make reports with no longer existing measures editable for a viewer license
Hi Dominique, Rather than try to modify the analytic platform to cater for the fact that Measures in use by users are deleted deliberately, let's look at a more intelligent way to create the…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Slicer ID Embedded Content
Hi Yakov, If you're embedding Present Dashboards, then it comes as part of the Dashboard. With respect to API control, are you asking if it will be possible to inject compound slicer values into the…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Retaining unique row combinations from query preview to discover
Hi Ben, Have you resolved this or do you still need some help? As above, we'd need some detail on your model to help further. Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Slicer ID Embedded Content
Hi Yakov, We can hopefully save you some work here! Bookmarks in Present is a feature we are delivering in the next major release of Pyramid during Q1 2023.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Distinct Count if Line Size Value >= Max Line Size for Group
Hi Nick, Yes, is the simple answer. How exactly you do it depends on your model structure. Can you share a little more of that and how you calculate the permitted line size value? If you have that,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Using MIN in formulate but only where > than another value
hi Nick, Trick here is to filter the list before applying the Min function. Here's an example where I want to find the minimum value of sales for my products where the sales value is greater than a…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Retaining unique row combinations from query preview to discover
Hi Ben, It looks to me, without seeing the whole model, that the table containing Section_ Reference and Max_NSP_24Months is not properly joined to the Table containing the Section_Reference column…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Answer
- Reported - view
Re: legend location
Hi anonymous client, You can place the legend where you want it in Discover and when brought into the Present canvas, the Discover renders as you defined it with the Legend where you put it.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: total filter but without the dimension in discovery.
Hi Nick, Create a Dynamic List of your References, filtered by the Premium being greater than 200. You could parameterise this to allow dynamic changing of the filtering value if you want.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Percentage points change
Hi Yakov, you can achieve this easily using the Quick Calcs in Discover. Click on the "+" icon in the vertical column of icons to the left of the Grid canvas.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Changing positioning of data labels in point graphs
Hi Guillermo, Please post a screenshot of what you are experiencing, with what you require clearly explained using the example as a base. We can then investigate more closely. Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Legend not showing on Matrix grid.
Hi Guillermo, I'm not quite sure what you are referring to. Here is my grid, with my Sales measure background defined by the value of Margin, the colours of which are shown in the Legend.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Pyramid Analytics API
Hi Aadhil, There is extensive documentation of our REST API online. Many entries have example code in a variety of languages. Take a tour through the available functions to see if it will support…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: PDF / Document files as a Data Source in Modeller
Hi Richard, You can do this already through the Python Source Block in Model. Generally, we would be looking for tables of data in the PDF for loading into a DB for analysis.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: How to create a report without live connection?
Hi Yakov, Why not just schedule the Publish report for weekly execution and post the output to the bulletin board? Users can then simply view / download it off the bulletin board when they need to.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Accepted
- Reported - view
Re: How to enable SSL on Pyramid website and forward all HTTP request to HTTPS
Hi Robin, Check out our Help for instructions on how to configure NGINX for use with Pyramid in a Linux environment. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Security
- Reported - view
Re: Merge separate lines into one single line whilst retaining separated stacked columns
Hi Ben, Unfortunately, using Claim Type in the Color Drop Zone will always split the measures into the different values of Claim Type, so you will always get a line for each claim Type showing the…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Publications- One attachment for multiple selections
Exporting to Excel does not replicate the layout of the page, rather it outputs each analytic view on its own sheet. Thus in the example above, yes, the grids for 2021 and 2022 will appear on…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nick, Any update? If not, I'll close out this question and mark it as Answered. Cheers, Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Publications- One attachment for multiple selections
Hi Sophie, Publish is behaving exactly as expected and designed. With two slicers attached to the Publication, it will generate a report for each unique combination of slicer values, i.e.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Equivalent to SUMPRODUCT in Pyramid
Funny you should mention that, we're currently preparing for SOC II certification. Part of the audit is that every employee has to have taken product training through the LMS. So I have go do it..…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Equivalent to SUMPRODUCT in Pyramid
Hi Nick, There are two ways of doing this, depending on your model structure. 1. Using two flat dimensions We need to get the list of shops for each type, for each shop calculate profit*ratio,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 3
- Questions & Answers
- Reported - view
Re: Date Formats in Exported Excel Files
Hi Sophie, When working with dates in calculations in IMDB or other SQL database based model, Pyramid makes use of a SQL Date type field that represents dates as an number (usually the number of…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Multipage Repeater
Hi Nick, You mean like this? https://community.pyramidanalytics.com/t/60h5as0/repeater-selection If so, vote for it and we'll assess the feasibility. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nick, Any update on how you want this chart to look? Or shall I close this item? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view

1 11 12 13 14 15 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Make reports with no longer existing measures editable for a viewer license

Re: Slicer ID Embedded Content

Re: Retaining unique row combinations from query preview to discover

Re: Slicer ID Embedded Content

Re: Distinct Count if Line Size Value >= Max Line Size for Group

Re: Using MIN in formulate but only where > than another value

Re: Retaining unique row combinations from query preview to discover

Re: legend location

Re: total filter but without the dimension in discovery.

Re: Percentage points change

Re: Changing positioning of data labels in point graphs

Re: Legend not showing on Matrix grid.

Re: Pyramid Analytics API

Re: PDF / Document files as a Data Source in Modeller

Re: How to create a report without live connection?

Re: How to enable SSL on Pyramid website and forward all HTTP request to HTTPS

Re: Merge separate lines into one single line whilst retaining separated stacked columns

Re: Publications- One attachment for multiple selections

Re: Sankey Chart - Source and Target Same Dimension

Re: Publications- One attachment for multiple selections

Re: Equivalent to SUMPRODUCT in Pyramid

Re: Equivalent to SUMPRODUCT in Pyramid

Re: Date Formats in Exported Excel Files

Re: Multipage Repeater

Re: Sankey Chart - Source and Target Same Dimension

Home