How to enable Javascript

Latest Posts

Re: Line Banding, different bandings for different classes. Swap dimensions. @NPANS Great idea! Thanks will use.
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 mth ago
- Q&A
- Accepted
- Reported - view
0
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,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 mth ago
- 3replies
- 25
- Q&A
- Answered
- Answered
Re: Distinct Count if Line Size Value >= Max Line Size for Group @Ian Macdonald Many Thanks, perfect!
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 2 mths ago
- Q&A
- Reported - view
0
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…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 3 mths ago
- 2replies
- 55
- Q&A
- Answered
- Answered
0
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.…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 3 mths ago
- 1reply
- 26
- Q&A
- Answered
- Answered
Re: total filter but without the dimension in discovery. Hi Thanks Ian, this has saved me so much time. Much appreciated :)
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 3 mths ago
- Q&A
- Reported - view
0
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…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 3 mths ago
- 2replies
- 45
- Q&A
- Answered
- Answered
Re: Existing or custom area chart with measure for x axis. just to add the final version in excel, how it was achieved was each reference was given a rank value based on its exposure so the risk with highest exposure for X year was renamed to 1,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 4 mths ago
- Q&A
- Reported - view
0
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,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 4 mths ago
- 4replies
- 45
- Q&A
- Answered
- Answered
Re: Eliminate visual indicator on eliminate datapoint so where the arrow is pointing, that is blank as i eliminated the data point for that specific measure at Q4, however I need to find a way to eliminate the 87.…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 5 mths ago
- Q&A
- Reported - view
Re: Eliminate visual indicator on eliminate datapoint This is an example of eliminated data point, but not eliminated indicator
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 5 mths ago
- Q&A
- Reported - view
0
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,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 5 mths ago
- 6replies
- 45
- Q&A
- Answered
- Answered
Re: Equivalent to SUMPRODUCT in Pyramid Ian - i have a feeling level 3 in the learning hub wont be a problem for you :) many thanks! you've saved me a lot of time
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 8 mths ago
- Q&A
- Reported - view
0
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.…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 8 mths ago
- 3replies
- 48
- Q&A
- Answered
- Answered
1
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,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 9 mths ago
- 1reply
- 24
- 1
- Q&A
- Answered
- Answered
Re: Sankey Chart - Source and Target Same Dimension Hi Ian, Apologies I'll ask Jon if he can draw up an image Wednesday, we have Matt in as well so perhaps Jon can demo to Matt too :) Will update you by Thursday.
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 9 mths ago
- Q&A
- Reported - view
Re: Variable List Measure, of a Variable List Measure Thanks Ian as usual very easy to follow and understand and helped massively :)
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 10 mths ago
- Q&A
- Reported - view
0
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.…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- updated 10 mths ago
- 2replies
- 29
- Q&A
- Answered
- Answered
0
Variable List Measure, of a Variable List Measure
Some of our colleagues demo'd a dashboard where they had two parameters, one of which drove the visual i.e. a variable measure. They had 4 groups of measures, profit, reserving, claims and premium.…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 10 mths ago
- 2replies
- 35
- Q&A
- Answered
- Answered
Re: Sankey Chart - Source and Target Same Dimension Hi Ian I got the wrong end of the stick, I spoke to Jon (I'm going to get him to draw a chart), its actually so we have a set of statuses so say quote, provisional, signed, written on one side,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 10 mths ago
- Q&A
- Reported - view
0
Sankey Chart - Source and Target Same Dimension
Hi I am looking to create a Sankey chart where the source is a month (I want to select a start month using a parameter) and the target is the same month dimension however I want to select an end…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 10 mths ago
- 5replies
- 44
- Q&A
- Answered
- Answered
Re: chart list for development months hero it works!!! thanks much appreciated :)
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 yr ago
- 1
- Q&A
- Reported - view
Re: chart list for development months Hi Sorry I should have stated so its not a week number as such its a development month so in the data its just 1,2,3,4,5 etc with no time intelligence, Thanks for the prompt response though :…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 yr ago
- Q&A
- Reported - view
0
chart list for development months
hi I have a chart which is showing months 1 to 60+, i was wondering if its possible to show 1 to 24 then from there going in multiples of 3? so 27 30 33 etc...?
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 yr ago
- 4replies
- 28
- Q&A
- Answered
- Answered
0
blank row in between different values
Is it possible to add blank rows in the tables? i.e. show 3 value measures, have a blank row then another 3 value measures?? So I have a table which shows increased, reduced, unchanged,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 yr ago
- 1reply
- 20
- Q&A
- Answered
- Answered

1 2 3 Next

Back to top

Top Contributor

Nicholas Campbell

Nicholas_Campbell

77
26
1

Joined: 16 Jul 2019

Follow

Mr