parameter

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

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

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

Dynamic SQL - Field Name Changes

Hi I have a table that has values in different languages, I wondered if there is a way to pass the field name for the 'current' language as part of a custom sql statement,…

• 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

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

Unified slicer for two separate parameters

Hi We're building a dashboard which includes two main charts. The top one is sales data and the second is market share. Each one of them is attached to parameter (marked) which allows to switch…

• Answered

Using URL Parameterization

I am currently trying to figure out how to parametrize a URL in order to link directly to a Present whose data would be filtered by the other application.…

• Answered

Parameters don't seem to be working

I added a parameter to one of my dimensions which I also have in rows in my grid. I am not sure if I did something wrong, but when I change the selection in the parameter's drop-down,…

• Answered

Time Intelligence in Pyramid 2018

Is it possible to get preceding 7 days of full week result or filter in Pyramid 2018? For example, when one date is picked, report should show results for the current week (the last 7 days).

• Answered