Formulate

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

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

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

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

Find Difference between two dates

Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?

• Answered

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.…

Last 'N' dates list Based on Date Filter

I want to get the list of last 90 days based on Date Parameter ( Date filter Selection). How can we achieve this ?

• 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

HR Cube - Absenteism hours - Formulate

PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…

• Answered

Formulate: Comine Standard List with a Measure

Hi guys, I'm not sure if I'm just "standing on the tube" or if my idea can't be realized, so I hope for your support: In formulate, I want to combine the function of a "standard list" with a measure:…

• Answered

Ordering the Months

Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…

• Answered

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

Having trouble to make an average over a created column

I’m encountering an issue while calculating the average sales over the last 6 months using a custom column (Mes completo) that transforms dates into a string displaying the month and year in the…

• 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

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

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

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

Text parameter which retrieves date ranges

Hello everyone, Is it possible to map text captions in a parameter to individual list objects. The business context is to enable the formation of date ranges which are either calendar or fiscal in…

• 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

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

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

Custom Visualizations

The formulate module should have a option for "Custom Visualizations". I dont see it, neither in our pyramid analytics platform nor the explore one of the community?

• Answered

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