-
Incorrect SQL generation in Calendar Slicer (Formula Picker) when using Last with Date granularity
Hello PA Team, I’m seeing incorrect SQL generation in the Calendar Slicer when applying function "Last" with Date granularity. The filter produces single-day matches per period instead of a full…
- Answered
-
Execute JavaScript – Navigate to Specific Slide in Present
Hi Team, I'm trying to navigate to a specific slide in a Present Pro dashboard using Execute JavaScript action (not Jump To Slide). I wanted to share everything I've tried so far in case anyone has a…
-
How to configure Dashboard slicers to work with Tabulate slicers?
I have a tabulate that contains 2 discovers, both filtered by a date. I grab one of the rows from the second discover and place it at the bottom of the first sheet and create some calcs.…
-
Use one date to filter multiple fields
Hello, We are trying to make it so that a user can select a single date and it will filter the data similar to this where clause, replacing the ? with the date: where trans_date<=?…
-
Limit dates in a slicer to after the last date selected in a date range filter
I have a calendar-type slicer. When I select a date range representing opening dates during that period, I want another slicer for evaluation dates to show only dates that are on or after the last…
-
Usage of the Count Function in Present
This may be a pretty basic question: I have a presentation that allows users to select multiple elements from a slicer. I would like to place a dynamic text box that displays the count of selected…
- Answered
-
Need guide on 2025 Feature || Delayed Slicer Execution
Hi Team, I need a guide on this below feature. Thanks, Shuv
- Answered
-
The first workday does not appear as set up
I noticed that my Date Calendar Slicer shows the first workday as Sunday, even though I've set it correctly in Tenant / Tenant Default Settings. Is there maybe another way to setup this? If not,…
- Answered
-
Is it possible to connect a slicer to dynamic text within a tooltip in Present ?
I have a tooltip on an image that displays dynamic text pulling data from a simple grid discovery. The only issue is that I am unable to apply the slicers on the present slide to the Dynamic text.…
- 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
-
How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
My team and I are working on a presentation that contains an image and a discovery on a single slide. We would like to create a click action on the image that sets a filter on the discovery to a…
- Answered
-
Improve Search Functionality of Data Elements
When using the search function (via the magnifying glass icon) for data elements, such as searching for elements when creating a Formula, the output for the search only contains items that begin with…
- Answered
-
How to include all Context in Action when Jumping from Present to Discover
I want to create a jump to content item action on a Present that carries over all filter values placed on a Discover in the Present. In a Present, I have a Discover with multiple slicers interacting…
- Answered
-
Subscription Default/Current Slicer Question
Hi everyone, Is it possible to set up subscriptions with a combination of current and default values selected for a presentation? For example, if a user wants to create a regular weekly subscription…
- Answered
-
Using cascading slicers/filters
Hey all, We have a hierarchal table like the one shown above with simple data in the table and this table is hosted in Redshift. When I do cascading slicers so 1 interacts with 2 interacts with 3 etc…
- Answered
-
Cascading Slicer - show count of elements??
i have a slicer that derives it's elements based on other slicers (and data behind them). how might i expose on a present a field that represents the "count" of elements in the resulting slicer??
- Answered
-
Data model Hierarchy - Tree slicer
Hi everyone, I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure. The problem I have is that it works well with double click and drill down,…
- Answered
-
Changing Slicer Settings
I've noticed that when I change a slicer from Single Select Tree to Multi Select Drop Down that it places my Single Select Tree selection into the background and does not change the Slicer Type.…
- Answered
-
Creating/displaying global slicers in present
We have started converting content from BI Office to Pyramid and I haven't been able to find clear instructions on how/if global slicers work in presentations.…
- Answered
-
Ho do I cascade from one slicer to another, and have the second slicer have all options selected by default?
We are looking at student information at our university. I have set up a cascading slicer so that when I select a student then the second slicer populates with the courses they are taking this…
- Answered
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- Answered
-
Dynamic texts for Slicers
Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…
- Answered
-
Reset Presentation Slicers to "All"
Hello Pyramid Community, I tried some different settings for the slicers on a presentation. Now, I always have the first available value of the slicer selected when I execute the presentation (I…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.