-
Changing the background or font of 1 cell
I have a table jam packed with information, but I need 1 cell (in my case it is a specific element within a dimension) to have a red background. How do I go about doing that?
-
"Last N Weeks" Function in Calendar Slicer is Misleading
Hello PA Team, I'm reporting a highly confusing behavior in the Calendar Slicer that appears to be a UI/UX bug. Steps to Reproduce: In Discover, add a date hierarchy to the Filters zone to create a…
-
Using Regular Expressions to replace
Hello, Is there a way to use regular expressions to search and replace?
- Answered
-
Is there a way to show a measure only once when we have repeating dimension values?
We have a scenario where an insurance policy has multiple drivers. However, there is only one insurance premium at the policy level. If we add drivers to a discovery with a measure it replicates the…
- Answered
-
Minimum Date
Hi all, I'm looking to find the first time a customer quoted. I have a transactional table with customer dimension and a quote date dimension. I want to aggregate the dates by customer and return the…
- Answered
-
PYTD vs YTD Comparison , while Not Showing Dates
I have a request which i cannot seem to get working correctly without showing dates. I want to compare suppliers YTD spend vs PYTD spend, so only dates up to today for this year and last.…
- Answered
-
Binary Code to HTML in Pyramid
We have a BINARY column in Snowflake that contains file data in raw bytes . This column is being surfaced in our Pyramid data model. Can Pyramid natively convert this binary field into a renderable…
- Answered
-
End of Month custom column (EOMONTH formula)
Is there way to convert dates to End of Month date using formula like EOMONTH. In our system, we do not load data for Sundays or Holidays and I would like to use the EOMONTH formula to convert any…
- Answered
-
How do I upload my corporate font?
We have a corporate font, which isn't available on the standard fonts lift in Pyramid. How do I add it? It's on my computer, but not available on Pyramid.
- Answered
-
Execution Solve Order Explanation
Morning all, Question around formulates and solve orders, we have had a couple of situations recently that has caused some issues that was resolved by adjusting the solve order on formulates.…
- Answered
-
Choose which 6 options are available on the popup
Within Present, when a user hovers over content there is a popup with 6 options to choose from: Can I change which items I want to display?
- Answered
-
Attach pdf as an attachment in email node
Hi, Is there a way to attach a PDF when sending an email? Thanks, Raveena
- Answered
-
Can Supabase be used for the Pyramid repository?
Hello, Is it possible to use Supabase (https://supabase.com/), which is a Postgres based database as a service, as the repository database for Pyramid Analytics?…
- Answered
-
Clarification regarding the model_name column
Hello PA Team! While exploring the Pyramid repository database, I came across something I'd like to clarify. I noticed that in the public.server_log_transaction table,…
- Answered
-
Dynamic formulation for full year / rolling 13 months
Hello everyone, We currently use the following formulations to ultimately display the rolling last 13 months ("Rollierend") or the entire year ("Gesamtjahr") via a button in the dashboard.…
- Answered
-
Adding Security to a Dimensions so only a small group of users can see and use it
Hi is there a way to have a dimension that only a small group can see and us it? I want to use a dimension in a report but I want to be the only person to be able to select it.…
- Answered
-
Best Practice for Isolating Self-Service Workloads in a Single Installation
Hello PA-Team, I'm looking for advice on a common enterprise challenge: how to ensure the stability of my critical corporate reports in a mixed-use environment where self-service users are also…
- Answered
-
When search for contains, how to specify?
Just say I have a dimension, "Model" and within Model there is an element "THIS IS AN EXAMPLE". I want to be able to search for "IS" without "THIS" being shown as a result.…
- Answered
-
Specify an indicator on a specific dimension's element.
Is it possible to use a KPI as an indicator only on selected elements within a dimension? Currently when I drag the KPI into the indicator, it will apply it to all the elements.
- Answered
-
Reset query context on a click action
Is it possible to use a click action or something similar to reset the query in Present? I've got two visualisations controlled by a mini tab - if the user selects an element on chart 1 it filters…
-
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…
-
'Average' line that has no data points
Hello, When I add an 'Average' line it has data points for each full month name. I want it to have no data points despite the other data on the line graph having data points.…
- Answered
-
Interaction between slides
I'd like to have data interactions between slides. Currently I can only perform data interaction on the elements within 1 slide. Is that possible?
- Answered
-
Learning materials for level 2 professional certification
Hello, I am looking to complete my level 2 professional certification. I wanted to ask if the learning materials for the level 1 also apply to the level 2 assessment. Thanks! Connor
- Answered
Got stuck with a report? Start a discussion or help others to move forward.