-
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
Creating a Line Graph With Year as X-Axis and a String as Y-Axis
I want to create a line graph in discover that shows all of the years as the x-axis and the company name as the y-axis. So like a line graph that shows that a company existed from 2009-2024 and…
- Answered
-
Making Custom Bins With Measures For Discover
So I have a measure that I want to use to make bins. Discover is able to have me create bins by rank, value, category, size, parameter, etc. Still, is there a way for me to create bins by custom…
- 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
-
Calculation based on Date Filter Range
I am looking for a calculation of a value divided by month; however, the number of months is dynamic depending on the overall date range that the user has set.…
- 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
-
Charts Customization
I have male female COUNTS in gender column .The requirement is that the SVG should be filled only for the count based on gender. For example if male count is 40 and female count is 60 ,…
- 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 define a common scale for primary and secondary Y-axis?
I have a (stacked) bar chart with two measures - one measure on the primary Y-axis, the other on the secondary y-axis. As these two measures should be comparable (imagine e.g. incoming vs.…
- 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
-
including google charts in Formulate ( custom visual )
how can i use google charts in formulate-custom visuals , I have a code for for a chart - (have attached the code below) , how can I integrate it in FORMULATE_ CUSTOM VSUAL ,…
- 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