-
What's this called please? ("Actions")
I have a discovery table in a presentation, DimensionA vs DimensionB with a measure in the values. I'd like the user to be able to select a cell in that table,…
- Answered
-
Accidentally pressed "Auto Interact"...
OK so I've made this mistake before, but this time it's really ruined my presentation. I have saved since as hadn't even realised I pressed it. Is there a way to undo all the knitting it has done…
- Answered
-
Background Colour cells based on IF formula
As per the above, I have created an IF formula to specify what colour I want the cell to be, based on the value of the measure. This doesnt seem to work no matter what I try when dragging the…
- Answered
-
Authenticating with ADS when Pyramid Analytics hosted on AWS
Hello, Does anyone have tips on setting up Active Directory Services (ADS) authentication in Pyramid Analytics running on AWS. ADS is running on local network and Pyramid Analytics is running on AWS.…
- Answered
-
Python
I have a question regarding to python. I want to add the list below into a column and append it to my existing excel file list = [2,3,4,5] Original: After: I have converted my excel to panda ...
- Answered
-
Parse excel doc
I want to parse excel document to lists in Python. Is there a python library which is helpful for this action? And what functions are relevant in that library?
- Answered
-
Python and Excel
What is the best way to read Excel (XLS) files with Python (not CSV files). Is there a built-in package that is supported by default in Python to do this task?
- Answered
-
Customisable Linear Regression Line Scatter Chat
Hi we have a scatter chart and we are looking to create a line which is Y (Premiums)= X (Claims) so that anything below the line is a loss and anything above the line is profit.…
- Answered
-
interactions across column charts
Hi community. I have highlight-type interactions between two column charts, both of which feature measures from the same table (one is "value" and the other is "cost").…
- Answered
-
Ranking a measurement linked to more than one dimension
Hello The rank statistical feature returns the rank of a member in the specified list. The list used must be a list or set of elements from the SAME hierarchy as the member in the model.…
- Answered
-
Quickly duplicate a dimension?
Hi i would like to copy a dimension, we could write it into our ETL but if I can do in Discovery or Formulate then it would be cool. In Tableau I would create a calculated field "=DIMENSION_NAME"…
- Answered
-
Discover - Viewer - Descriptions
Is it possible for users with the viewer license to see any of the metadata associated with Discover? I'd like the viewers to at least see the description text.…
- Answered
-
[Publication] Page repeat children of filtered/selected member
Hello, I am wondering if it is possible to filter a Publication and having a page repeater export the children of the filtered member. For example: I would like to export a publication for Europe,…
- Answered
-
What are the best practices with the new migration capability?
Hello, We are trying to use the migration utility to promote content from development to production. However, we are getting duplicate content suffixed with a number e.g.…
- Answered
-
Present - Not enough information error, can it be turned off?
In Present, can a panel be modified to display a blank grid instead of providing the error 'Not enough information' when no information for the criteria selected?
- Answered
-
Totals of sets
Hi, It seems that we are not able to show totals whenever we make sets. In the attached example you will see it shows totals from the data that are directly coming from the dimension (black arrow)…
- Answered
-
Multiple PlaceHolders in a text box - work once then disappear
Hi I have text boxes on a Present, if I add a single Placeholder and use Interaction Manager to associate it with an item then everything is cool and it works.…
- Answered
-
Multi-factor Authentication
Is there a way to enable multi-factor authentication (MFA)? If not directly through Pyramid, is there third party tools to provide something like this?…
- Answered
-
Publication with Portrait and Landscape Pages
Hello, I am creating a publication in Pyramid, and have some discoveries which would be better displayed on a portrait page and others on a landscape page - is it possible to change the orientation…
- Answered
-
Best method for displaying four measures on the same visual
We have previously upgraded our Pyramid version from 5 to 2020.10. We used to use funnels to show four related measures on multiple reports, however, as we have seen in the help documentation,…
- Answered
-
Can you change filter conditions in discoveries be OR rather than AND?
We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero. So the condition would look like this: Measure A !…
- Answered
-
How to get the Content Path from the Pyramid Repository in Usage Reporting
In the usage report that I built based on Transaction logs in Pyramid, I am not able to get the 'Path' for my dashboard or report objects. Is there a way to get a path field for the content?
- Answered
-
Custom tooltips, how?
Hi all I'm reading this: https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Present/Present%20Pro/functions/CustomTooltips.htm?Highlight=tooltips Because I need to have control over the…
- Answered
-
Trellis - why the 4 column limit?
Hi I love the trellis charts but is there a practical reason for the 4 column limit? 5 would be excellent, after that maybe some diminishing returns, but for flexibility of design options why not go…
- Answered
-
Partial Replacement of Data
Hi All - Is there any way you can delete a filtered set of records from the InMemory db? I need to replace only the last weeks data with every run since these records are altered in the source data.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.