-
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.…
-
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…
-
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,…
-
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 use KPIs and Gauges in a Dynamic Way
How to use KPIs and Gauges in a Dynamic Way The Use Case Working with a customer, I recently ran into an interesting use case that required dynamic band values in a KPI and a gauge view.…
-
Access Multiselect Parameters values in Formulate
Hi, I’m trying to access multiselect parameters in Pyramid Analytics. Specifically, when using multiselect parameters in a dynamic caption, only the first selected value is shown,…
- Answered
-
How to build Aggregate blocks for a Dimension
How to build Aggregate blocks for a Dimension When you are working with larger lists it is often necessary to define groups of elements into a single aggregated element that contains the totals for a…
-
How to create a parameter driven list and search across multiple attributes
How to creating a parameter driven list and search across multiple attributes Imagine we have a long list of Values in a table. Now we want to filter out all lines that contain certain values but…
-
Is there a way to apply Dynamic Masking (or something similar) to Measures?
My team and I would like to create a grid discovery for external users. We would like the values from certain Measures to be encrypted to external users,…
- Answered
-
Is there a way to calculate a date off of a date parameter?
Hello, We have an evaluation date parameter and we want to create a prior year end date value for a formula. In other words the user chooses March 2024 for premium and then for the "Prior Year End…
- Answered
-
Learning Hub Guide: Data Concepts and Integrating Calculations in Pyramid
Dive Deeper into the Basic Principles of Calculations with the Learning Hub Calculations are a key feature of the Pyramid Platform, offering powerful functionality across its modules.…
-
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 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 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…
-
Slicer to switch between months and weeks with same amount of bars in a barchart
Hello, we are currently building a dashboard that uses a global parameter as slicer to switch between months and weeks. The goal is to have some equal amount of bars in a barchart.…
- Answered
-
YTD and Prior YTD Measures
Desired Outcomes: I want to perform month-over-month analysis, comparing prior year-to-date (PYTD) figures with current year-to-date (CYTD) figures, and calculate the difference for each month.…
- Answered
-
Calculating a Rolling Average Containing Empty Values
I noticed that whenever a cell is empty, Pyramid excludes it from the average. For example, if week1 = 1, week2 = 0, week3 = 5, Pyramid excludes the week 2 element from the calculation (i.e.…
- Answered
-
How can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- Answered
-
AVG OF WEEKDAY AND WEEKENDS
I have two columns weekday column and count column I want to find the average for each day and weekends based on month or year …How can we achieve this ?
- 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
-
Rolling average formula
I'm currently trying to create a formula to calculate the 3 week rolling average, the reason we're doing it in formulate rather than through the context calculations is because it will form part of a…
- Answered
-
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…