How to create a loss triangle in Pyramid Analytics

Does anyone know of a way to create a loss triangle in Pyramid Analytics?

• Answered

Data Label Formatting on Average Measurements

Hi, I've created a discovery which has two axis. The first axis (bar) to show quantity and the second axis (line) to show percentage of sales. What we would like to do is show another line on the…

• Answered

Conditional Formatting

I have been converting reports from BI Office to Pyramid 2018 and I have run into a snag. Note that this report was imported from BI Office to Pyramid 2018 using the conversion tool.…

• Answered

How to set default value to Slicer(Filter) ?

I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.

• Answered

How to un-show header in a table

Tableau had a feature that allowed you to add a column to a table but hide it by deselecting 'show header' Is there a similar feature in Pyramid? Here's a table I created in Pyramid and I could like…

• Answered

After focusing on a member in a Discovery, how do you unfocus?

Hello, We have had a couple of occasions where users have focused on something and saved the report. How do I turn off the focus so it goes back to it's original state? Thanks, Rob Clark

• Answered

Tooltip Name include

When hovering over data in a Discover, the specified tooltip data is shown in the window but it can be difficult to link the data to the title of the tooltip if similar data is shown in the tooltip.…

• Answered

can we refresh chart or grid data automatically at run time?

I have created presentation to show chart and also created scheduler which updates the model every 5 min. I am not able to see the updated data on the presentation.…

• Answered

How to remove Grid header deatils

I am showing data on below calculated grid and i don't want to show the grid header in presentation. How can i remove or hide this grid header details ? Regards, Mangesh Desai

• Answered

Discovery chart - how to show % values to 1dp?

Hi all, In my discovery chart, I would like to show my axis labels to 1 decimal place (they currently show to 3 decimal places). E.g. they show 1.200% when there is really no need.…

• Answered

Number Formatting in Discovery

Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…

• Answered

Unable to see discovery in Present

Hi , I am able to see the discoveries in my slide in the design module but it shows some error when i run the Present

• Answered

Sortting on aggregated measure on PostgreSQL

Hey all, I'm looking at trying to find the latest date for user logins in pyramid, using the username dimension and then creating a max formula for date dimension to find the most recent date.…

• Answered

Creating a dynamic parameter for a date range

Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…

• 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

Customize KPI Component Captions

In KPI definitions, I would like to define the caption for each component - So I don't have to use "value", "goal" and "status". I know in a KPI type discover I can change them,…

• Answered

Can you change filter conditions in discoveries be OR rather than AND?

We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero. So the condition would look like this: Measure A !…

• Answered

How to include all Context in Action when Jumping from Present to Discover

I want to create a jump to content item action on a Present that carries over all filter values placed on a Discover in the Present. In a Present, I have a Discover with multiple slicers interacting…

Is it possible to toggle between 3 different date fields on a Present

I have a present with discovers that all are based on time. They show information about loans that have been created over the past X amount of time. This is grouped by a total for each past…

• Answered

Sequential sorting of a single dimension by multiple measures

Hello everyone, I am trying to ascertain whether I can sort a table on a single dimension column but apply sequential sorts using more than one measure.…

• Answered

Changing Slicer Settings

I've noticed that when I change a slicer from Single Select Tree to Multi Select Drop Down that it places my Single Select Tree selection into the background and does not change the Slicer Type.…

• Answered

Dynamic texts for Slicers

Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…

• Answered

Tooltips

Hi, My tool tips don't appear to be working. I have told the software to display the Netlocation as tooltips, but when I scroll over or click on the lines in the line graph nothing appears.…

• Answered