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