Formulate

Filtering on 2 dimensions and counts

Hi community, I am struggling to do something that I think should be possible so asking for help here I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…

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

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

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

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

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

Creating a formulate based on the caption of the current member for a different dimension

I have two year year dimensions, lets say [A].[Year] and [B].[Year], I am trying to get the value of the B year based on the selected value of the A year in a slicer.…

• 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

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

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

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

REPLACE- EMPTY VALUES

In reports when working with values using formulate we are able to replace the null values . In the given scenario we need to replace the empty values .…

• 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

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