-
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
-
KPI with dynamic texts
Hello, I am trying to add a dynamic text to the KPI which shows a Year-over-Year change in between the quarters in my presentation. However, the text only returns a result if all years,…
- Answered
-
IBCS Waterfall Column Naming
Hey All, I was just wondering if there is a way to name the left and right book end of the IBCS waterfall. I can't seem to find where it is in format, has anyone else managed to get the previous year…
- 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
-
Learning Live: Using KPIs and Gauges
About this Video: In this video we give you an overview the use of KPI's and Gauges and how to usefully implement them into Pyramid Reports. Content: Lets check out this session,…
-
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
-
How to connect Google Sheets to Pyramid
Pyramid can model and blend numerous complex data sources for basic or advanced analysis. The quick tutorial below shows how you can use Pyramid to access and import data stored in a Google Sheet,…
-
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
-
How to I show data point that do not have a value
Hi, I have a report, where we don't have sales data for the time period, but I want to show the empty cells on the report . Like in this example 123456 didn't show up. Who could help me to solve this.…
- Answered
-
Obtaining accurate summations in a Many-to-One Relationship
I am having trouble grouping lines correctly so that I can get accurate totals. The basic premise is as follows: We are trying to transition away from buying item A and instead encouraging buying…
- 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 can I control the Size and Position on a more granular level
Currently, when adding an element to Present, the Size and Position options are set to increments of 10. This does not allow for design flexibility for developers.…
- Answered
-
Default theme not pre-selected
Hi, I have created a new theme (circled below) and made it the default within my pyramid environment under the admin settings, however when creating a new present / discovery the old default theme…
- Answered