-
Retain standard deviation values when removing a column
Hi there, I currently have the following grid: I'd like to attain a grid that doesn't include the Development Month column but retains the standard deviation result (shown above) for each department…
- Answered
-
Using MIN in formulate but only where > than another value
HI I am looking to create a box and whisper chart, I have got it working using Min / Max and average however we have a lot of Min entry where the value is 1 or 0, so the min is always near zero.…
- Answered
-
Models and alternatives to “scheduled” time to process
Outside of pyramid analytics I “know” when my data is available (that my model needs to downsample and append to an memory database) rather than having the model run at specific time of day can I…
- Answered
-
total filter but without the dimension in discovery.
Hi I have a discovery where I have a set of premium values by reference. I want to exclude any reference where the premium value is above a set value. This is possible using the total filter which…
- Answered
-
legend location
i like having discovers render "legend" centered on bottom. when i try to add the discover to present or publish i only see legend on left, right, or off as options.…
- Answered
-
Retaining unique row combinations from query preview to discover
Hi there, In my SQL query preview section (first screen grab) which has two columns, 'Section_Reference' and 'Max_NSP_24Months', I have unique row combinations.…
- Answered
-
Pyramid Analytics API
Good Day. I would like to connect Excel to Pyramid and extract a database using the REST API's. Is there any guidance on how to use these APIs?
- Answered
-
Existing or custom area chart with measure for x axis.
This is quite obscure so not sure if possible, but is it possible to create some sort of stacked area chart where the X-Axis is a rank (so numeric) instead of a dimension (so 1,2,3,4,…
- Answered
-
how to create not a dynamic calculation
Hi, I have a case where I need to make the next calculation: In a table with the columns: week | store name | item name | sales For each item: In each store,…
- Answered
-
PDF / Document files as a Data Source in Modeller
Hi Avi / Pyramid Dev team, Often, information useful for a Pyramid client is stored in PDF or other document formats - for example where the Pyramid client itself has many suppliers who do not…
- Answered
-
Eliminate visual indicator on eliminate datapoint
Hi is it possible to eliminate a visual indicator on a data point? I have a report which shows by Quarter , i only want to show Q1 to Q3, and eliminate Q4,…
- Answered
-
Is the Job Spooler available in Viewer version?
Some of our users have been moved to Viewer licenses. They have reported not being able to find the Job Spooler icon now. Is the Job Spooler functionality available in Viewer?
- Answered
-
Merge separate lines into one single line whilst retaining separated stacked columns
Hi there, For some context, the 'Gross Incurred Claim' measure refers to the stacked columns whilst the 'Rolling Average 12 Gross Incurred Claim' refers to the four separate dashed splines.…
- Answered
-
Legend not showing on Matrix grid.
How can I show a legend in a matrix grid? mine doesn't show up even when I turn it on. I would also like the legend to show the break points between colors (it's a band).
- Answered
-
Changing positioning of data labels in point graphs
Is it possible to change the position of data labels in point graphs? It seems possible to do with line graphs, but the positioning feature disappears when doing a line graph.…
- Answered
-
How to create a report without live connection?
Hi We are looking at creating some reports (in publish) that we would only want to refresh once a week. In this way we are trying to find a way to create some type of saved report that would save…
- Answered
-
sort or filter on subtotals
Hi, Im not able to sort or filter for the subtotals in dark green, to identify the largest quantity, moreover, I also did not manage to filter out the TOP5.
- Answered
-
Percentage points change
Hi We are looking at a solution to create point percentage change column. In the given example we would like to create a measure that can be calculated on percentages,…
- Answered
-
Combining two discovery tables in present
Hi We have two tables which we are trying to merge. The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.…
- Answered
-
Unified slicer for two separate parameters
Hi We're building a dashboard which includes two main charts. The top one is sales data and the second is market share. Each one of them is attached to parameter (marked) which allows to switch…
- Answered
-
Is there a way to move a CMS repository to different database vendor?
Hello, We want to move the CMS repository to a different database. We have them in Postgres and want to move them to SQL Server. Is there a way to port from one database to the other? Thanks,…
- Answered
-
Replace a current template in a presentation
We have changed our Master Pages/template and we would like to update all our existing presentations. Is there a way to edit/replace a current theme in a presentation?
- Answered
-
Equivalent to SUMPRODUCT in Pyramid
Hi I have to do a weighted average calculation to calculate a market average. In excel I would use sum product where I can't get the numeric value for the %'s and created a weighted average.…
- Answered
-
Publications- One attachment for multiple selections
Hello, I've got this publication that produces a list of open orders by requestor and year, for this year and the previous year only. To get only the years I need,…
- Answered
-
Date Members in formulas
When I create a Date with a formula, using several functions, Pyramid seems to work fine: When using common date functions with the created dates, everything looks correct to me: Also,…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help