-
From and To Parameters not working in dashboard.
Hello, I've implemented 'from' and 'to' parameters for GAAP accounting periods in a discovery tool. When I adjust these parameters, the tool correctly updates a range aggregate and provides accurate…
- Answered
-
Use a formulate to set the default parameter value
Hi, I have a parameter value which allows the user to select the GAAP Accounting Period, at the moment to make it easier i have a list which goes from 199901 to Prior month close (202304),…
- Answered
-
Unable to Line Up Aggregate Attributes in a Table
Hi So I have a currency table , and grouped CNV & GBP into a single aggregate currency, works fantastic. When I put this into a table it creates a misalignment with the other SCC currencies and GBP -…
- Answered
-
Dynamic Caption for prior month
Trying to use a dynamic caption to show the field name as "Net Written Premium to Feb-2023" I'm trying to get the Feb 2023 part using : Lag(StrToMember( [RiskExtract].…
- Answered
-
Line Banding, different bandings for different classes. Swap dimensions.
Is it possible to have a dimension switch similar to how we deal with measures, so a set of buttons to pick x or y dimension? The reason being I have a report which shows exposure,…
- Answered
-
Distinct Count if Line Size Value >= Max Line Size for Group
Hi So I have a measure showing count(distinct aggregate reference) and it works as expected but now I need to only count if the line size value is greater than the maximum size allowed for the…
- 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
-
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
-
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
-
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
-
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
-
Multipage Repeater
We have three publications one for Premium, one for Claims & one for Reinsurance. On each of these we have a page repeater to show a page for each class of business for example property, casualty,…
- Answered
-
Line Breaks
Hi I've been asked if Pyramid can replicate a report a team currently have. The report has some summary information, and then some comments which the underwriter would input.…
- Answered
Badges
Latest Posts