-
is there a way to calculate an mesure avarage for the last year from yestrday?
I want to calculate a moving avarege of a mesure that will be always take the period of a year from yesterday or preveious week back. can someone help me with this calculation?
- Answered
-
Joining Splicers
I'm putting together a present where I have 2 elements from the same model, that use different time intelligence dimensions. I'm trying to add a splicer that will function on both elements on the…
- Answered
-
Origin date format isn't recognized by Pyramid as a DATE
The system I use generates reports where the date is formatted as a string of numbers and I cannot figure out how to get model to see it as a date. I assume somewhere there is a solution where I can…
- Answered
-
API for Testing In-Memory Data Source Connection
Is there an API available that tests the connection to the in-memory data source and sends an alert if the connection fails?
- Answered
-
Target URL Parameterization for Present
I am currently digging into getting target settings in url right. It works with simple URLs like…
- Answered
-
Push Publications to an SFTP Site
Hi. We have publications containing sensitive data, and data protection regulations prevent us from using email distribution. Is there a way to push publications to an SFTP site?…
- Answered
-
Using a pie graph as a 'link' to open a chart
I'm looking to insert a 'clickable' pie chart into a presentation. Ideally, when the viewer clicks on the chart, a separate window would open displaying both the pie chart and the corresponding data…
- Answered
-
How to do an vertical union in Pyramid?
I want to combine data from two sources but stack the results vertically, even if there's no direct match between the left and right datasets. How can I achieve this?
- Answered
-
Multiple slicers in Mini-Tabs
Hello everyone, I'm new to Pyramid Analytics and have recently started learning about Mini-Tabs. I was wondering if it's possible to link two slicers to four different Mini-Tabs?…
- Answered
-
Filtering child of hierarchies; not parent.
I have a chart where there is a column of (parent) PRODUCT TYPE sorted by sales, and nested below are the (child) PRODUCT NAME. I want to be able to show only the TOP20 selling (child) PRODUCT NAME…
- Answered
-
Conditional Formatting in a waterfall
Hey I am trying to create a waterfall chart that shows the deviation between planned and actual values. I have inserted this as a unit of measurement (calculation actual minus plan) in my values and…
- Answered
-
Display dates in viewer's timezone
I'm looking for a way to display date/time fields in Discoveries (and elsewhere) in the viewer's time zone. We store datetime values in the source data in UTC and when we show it in reports we want…
- Answered
-
disable Welcome Screen for all Users
Good Morning, I'd like to disable the welcome screen for all users. Unfortunately I can't find any option in the admin console or the pyramid online help to do that.…
- Answered
-
Tenant-localizable field names
Our application allows customers to rename things, for example patient identifiers. Even if it's all the provincial health card number, each province has a different acronym,…
- 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
-
How to Set a Default Size For Pop Up With IFrame
My team is utilizing the 'pop up in iframe' click action in a present window. We would like to set the default size of the pop up window to be slightly larger.…
- Answered
-
Power Automate Integration with Pyramid Analytics
I am currently working on integrating Pyramid Analytics with Microsoft Power Automate/ aka Microsoft Fabric to automate the retrieval of JSON files generated by Pyramid.…
- Answered
-
How to replace a string cell with a text value using Calculated Column
Hello, I need to find 'blank' (empty, no data, '', etc.) cells in a column "Description" (String, 255) and replace with a text 'NO DATA'. I added InsertRecords Flow --> Column Operations -->…
- Answered
-
Top and Bottom N filtering
Hi, I want to be able to filter my matrix to show both the top 1 and bottom 1 value in the same table. Is there a way to do this? Currently I can only see that its possible to do one or the other…
- Answered
-
Table in Present automatically changing to different style on resize.
Morning all, Quick question, if I create a table in a discover then place within a Present, the table will automatically change type when the size is reduced to a certain level.…
- Answered
-
Seeking to Apply Security to End Users on 'Analyze Further' option for discovery
I am working on a discovery for a client-facing presentation that I want users to use the 'Analyze Further' feature to explore. Within the matrix grid discovery,…
-
Model management tools
Hello, Are there any inherent model management tools available in Pyramid ? In essence, if I have models in UAT and Production and I want to get Production updated from UAT as part of a promotion but…
- Answered
-
Headcount from the previous month automatically updated on the 1st of the month
Hi, My English is not very good and I was not able to correctly formulate my request in my previous subject. I have an exploration that indicates the headcount for the previous month.…
- 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
Got stuck with a report? Start a discussion or help others to move forward.