User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Latest Posts
Re: Line Banding, different bandings for different classes. Swap dimensions.
@NPANS Great idea! Thanks will use.
Nicholas Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
1 mth ago
3
replies
25
Q&A
Answered
Answered
Re: Distinct Count if Line Size Value >= Max Line Size for Group
@Ian Macdonald Many Thanks, perfect!
Nicholas Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
3 mths ago
2
replies
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 Campbell
Top Contributor
Nicholas_Campbell
3 mths ago
1
reply
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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
3 mths ago
2
replies
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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
4 mths ago
4
replies
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 Campbell
Top 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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
5 mths ago
6
replies
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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
8 mths ago
3
replies
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 Campbell
Top Contributor
Nicholas_Campbell
9 mths ago
1
reply
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 Campbell
Top 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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
updated
10 mths ago
2
replies
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 Campbell
Top Contributor
Nicholas_Campbell
10 mths ago
2
replies
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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
10 mths ago
5
replies
44
Q&A
Answered
Answered
Re: chart list for development months
hero it works!!! thanks much appreciated :)
Nicholas Campbell
Top 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 Campbell
Top 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 Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
4
replies
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 Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
1
reply
20
Q&A
Answered
Answered
1
2
3
Next
Top Contributor
Nicholas Campbell
Nicholas_Campbell
77
26
1
Joined: 16 Jul 2019
Follow
Mr
United Kingdom
Home
Q&A
Best Practices
Learning Live Archive
Learning Live Topic Suggestions
Tips & Tricks
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help