-
How to: Display Daily Data in a Calendar View
How to: Display Daily Data in a Calendar View When you are working with Daily Data it will sometimes make sense to display the information in a Calendar view.…
-
How to add subtotals for % Values to sum up to 100% in the category
Question: How to add subtotals for % to sum up to 100% for the category In a recent internal discussion we came across this question and wanted to share the solution to a broader audience.…
-
How to: Create a dynamic set of dates
Question: How to create a dynamic set of dates During a recent discussion we got asked how to create a dynamic set of dates. There are two approaches to the tasks,…
-
How to add a Custom Visual
How to add a Custom Visual Pyramid offers a broad spectrum of standard visualizations that are available to users in the Discover App. In order to include additional visualizations,…
-
Tip of the Day - Dynamic dimensions and measures
How to create dynamic dimensions and measures that can be exchanged This tip & trick has been provided by @Michael Daun who created this solution while working on a project What to we want to achieve…
-
Tips & Tricks: How to identify duplicated elements
How to identify duplicated elements? A recent Question on the Community asked what would be a good way to identify duplicates. E.g. where an Element has been assigned a Status twice where it only…
-
How to build logical categorizations (Bins)
How to build logical categorizations (Bins) Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid. Use the Tips & Tricks series to give you a quick…
-
Pyramid Data Tip of the Day - Metadata Tooltips and Clickthrough
Video of the Day – Metadata Tooltips and Clickthrough Our video of the day looks at metadata tooltips and click through in the Formulate app. When working in the Formulate script editor,…
-
Setting dimension elements to a secondary axis
Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…
- Answered
-
How to find the "1st Month of the Year of the Previous Month" in a list
How to find the "1st Month of the Year of the Previous Month" in a list In this question the user was asking how to find the first month of the year, but the basis for this search would not be the…
-
How to build Aggregates with Context Calculations
How to build Aggregates with Context Calculations Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to use Measure Lists and Parameters
How to use Measure Lists and Parameters Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid. Use the Tips & Tricks series to give you a quick way…
-
How to build a Tree Map Chart with Measure
How to build a Tree Map Chart with Measure Tree Maps are a powerful visualization if well used and understood. Using Grouping and Measures we are able to create very insightful Tree Map Charts.…
-
How to cluster outliers and add regression lines
How to cluster outliers and add regression lines Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to use the List Builder to create a Word Cloud
How to use the List Builder to create a Word Cloud Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
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
-
How to: Creating a Custom Column to create a new attribute
How to: Creating a Custom Column to create a new attribute In this usage of Custom Column, a new feature for Pyramid 2023, we will create a new column that represents the Domain of an email address…
-
How to build Dynamic Today, current month, Previous Month etc. in Pyramid Formulate
How to build Dynamic Today, current month, Previous Month etc. in Formulate Get Dynamic Dates Using Formulate Wizard. To make the access on the latest information,…
-
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
-
Adding an empty measure column to a Discovery
Adding columns is basically done by creating and selecting Calculated members/measures into the Columns selection area. In this case, the requirement is to add an empty column to discovery,…
-
Learning Live: Iterative Logic to Solve Complex Questions
About this Video: In this video we give you an overview about how you can work with iterative logical concepts in Formulate. Content: Lets check out this session,…
-
Rank function
Hi Everyone, I am trying to use the rank function in Pyramid (similar to rank function in excel) to rank customers with highest revenue to lowest. The environment used is MS OLAP.…
- Answered
-
Choose an specific dimension element
I'm trying to apply different data points depending on the element value. this is how i built my formula: if(CurrentMember([CalendarioMO].[date full month name]) = DateFormat(Date(),"MMM yyyy"),…
- Answered
-
Learning Live 2024: Pyramid 2023 Update
About this Video: In this Episode of Learning Live we will give you an update and overview of the new features and improvements that have been included in the Product since the launch of Pyramid…
-
Weighted Product Distribution %
Good morning, I hope that someone can assist us with calculating a product's weighted distribution in Pyramid. Weighted Distribution % = The Total Value of the Customers that buy a Product (where…
- Answered