Ian Macdonald's Profile - Pyramid Analytics Community Forum

Company

Pyramid Analytics

Country

Latest Posts

Re: Using SQL queries to build reports
Hi Laura, Only indirectly through Model as you have observed. However, there is a shortcut here, whereby you can create a quick direct query model based on a custom SQL query when you open Discover.…
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Q&A
- Reported - view
Re: Preset number of Y ticks in advance
Hi dgf, The actual, absolute size of the rendered content can be defined when it is embedded in a Dashboard or a Publication. Outside of that, setting absolute size has no relevance. Hope that helps.…
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Q&A
- Reported - view
Re: Inserting a blank column
Hi Amy, Simply create a new Measure that does not contain any values, in my case I'm calling it 'Blank': Then place it in your grid where you need the empty column: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Q&A
- Reported - view
Re: Rename an element?
Hi Dave, No, not in the same way. The reason is that the names of the members of a hierarchy are, in fact, the data coming from your underlying table. So you would effectively be altering the data in…
- Senior Director of Product
- Ian_Macdonald
- 4 wk ago
- 1
- Q&A
- Reported - view
How to add subtotals for % Values to sum up to 100% in the category

Question: How to add subtotals for % to sum up to 100% for the category In a recent internal discussion we came across this question and wanted to share the solution to a broader audience.…
- Senior Director of Product
- Ian_Macdonald
- 4 wk ago
- 1reply
- 39
- 5
- Discover
Re: Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative
Hi Dave, I've reproduced the issue with similar data to the example above. This appears to be a bug. Can you please open a support ticket by emailing support@pyramidanalytic.com.…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Building Custom Filters
Hi Laura, How do you measure "Activity"? Do you have a Measure that contains the hours attended by course or something like that? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Is there a way to add a discovery to a tabulation without it merging fields?
Hi Robert, Yes. Instead of using a Matrix Grids, use a Tabular Grid. Here's a standard Matrix Grid: Right click on the Grid Icon in the Visualisations Bar and select Tabular Grid:…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Building Custom Filters
Hi Laura, Can you give some examples of what you are trying to achieve? When you say "custom filters", what do you mean exactly? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Dynamic filter for various slides in the same dashboard
Hi dgf, How are the relevant countries for each slide determined? How can they be calculated dynamically? I.e. what is driving the list of relevant countries? there may well be a way to do this,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Dynamic filter for various slides in the same dashboard
Hi dgf, Easiest thing to do is simply add a new Country slicer to each slide, then set what elements appear in the slicer for each slide. As you add each slicer,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view
Re: Count the number of customers depending on specified levels (nested if)
Hi Niclas, Generally for these types of queries, where there is a need to filter then count a set, it is more efficient to take a slightly different approach, evaluating the condition,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view
Re: Can you switch off Totals for specific columns in a Matrix Grid
Hi Steve, We are currently enhancing the totals and subtotals options and we will have a "No Totals" option by Column/Row/Measure. This will be available in a later release of Pyramid.…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view
Re: Using cascading slicers/filters
Hi Fergus, We'll take a look at this. Meanwhile, maybe you could try creating a hierarchy in your dimension in the semantic model and try a Tree slicer using that hierarchy,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Count of positive values in sub query
Hi Valeriia, Yes, I will reply. Been busy on other things. certainly by next Monday. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view
Re: Count of positive values in sub query
Hi Valeriia, In that case it is a vey simple calculation, but using the new feature in Pyramid2023, "Custom Columns". I'm assuming you are working in Direct Query mode,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: get a list of unique account_IDs from two lists
Hi dgf, Open Formulate, select your model and choose to create a new List. Drag the "Union" block form the "Derive" menu on to the canvas, you will by default get two branches to Union:…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 2
- Q&A
- Reported - view
Re: Actions > Jump to Content
Hi Shannon, We'd need a lot more information to determine if this is an issue. We currently have no reports or open problems on this topic. If you are getting "not enough information" when you jump,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: How to Create a measure from a dimension
Hi Steve, Pyramid's Semantic Model is dimensional, so you have to think Sets rather than Tables, Rows and Columns. So, you need to create a set of Periods, sorted by Sales descending,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view
Re: Count of positive values in sub query
Hi Val, Sorry, some more questions. Is this example table the base, row level data? At what level of aggregation is the testing of Sum of Profit if it is +/- ?…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: How to view underlying query of a discover report
Hi Laura, You cannot. The Pyramid "Pyrana" SQL query engine uses advanced and sophisticated techniques to "shard and stitch" its generated SQL to deliver the analytic view the user has defined…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view
Re: How to view underlying query of a discover report
Hi Laura, Be aware that setting Benchmark logging on can impact the runtime performance of your Pyramid Server and recommended best practice is to only switch it on to troubleshoot problems,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Suppression of Columns when Column is Filled with dynamic parent
Hi Andre, With the above from NPANS, you can also use the Dynamic Caption feature to set the Column Header of your custom member to the name of the parameter parent: Note:…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Count of positive values in sub query
Hi Valeriia, Can you please tell me what version of Pyramid you are using? That determines the approach that needs to be taken to solve this problem. Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Q&A
- Reported - view
Re: Shapes & pattern from png or svg
Hi Aaro, We don't currently support the use of user defined images as chart column fill or scatter plot points. Yes, a new feature request. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Q&A
- Reported - view

1 2 3 4 5 14

Welcome to the community!

User Community

Ian Macdonald

Re: Using SQL queries to build reports

Re: Preset number of Y ticks in advance

Re: Inserting a blank column

Re: Rename an element?

How to add subtotals for % Values to sum up to 100% in the category

Re: Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative

Re: Building Custom Filters

Re: Is there a way to add a discovery to a tabulation without it merging fields?

Re: Building Custom Filters

Re: Dynamic filter for various slides in the same dashboard

Re: Dynamic filter for various slides in the same dashboard

Re: Count the number of customers depending on specified levels (nested if)

Re: Can you switch off Totals for specific columns in a Matrix Grid

Re: Using cascading slicers/filters

Re: Count of positive values in sub query

Re: Count of positive values in sub query

Re: get a list of unique account_IDs from two lists

Re: Actions > Jump to Content

Re: How to Create a measure from a dimension

Re: Count of positive values in sub query

Re: How to view underlying query of a discover report

Re: How to view underlying query of a discover report

Re: Suppression of Columns when Column is Filled with dynamic parent

Re: Count of positive values in sub query

Re: Shapes & pattern from png or svg

Home