-
Possible to use publication outputs an input to model?
Hi A Publish can only publish files to email and internal, not a shared folder as far as I'm aware. I'm in a situation where I'm using a publication to extract a lot of data,…
- 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
-
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
-
Difference actual week- week prev year
Hello, we would like to calculate the difference of an KPI actual year vs Previous year on weekly base (KW this year - KW prev Year). We have time attributes for Date, KW (i.e.…
- Answered
-
Question on distinct count for each value
Hello, our business users display campaigns to their customers. When they buy a contract they get a discount. Sometimes a campaign contains more than one discount (i.e.…
- Answered
-
How to modify the WHERE clause conditions of SELECT statement before sending the query to database
Hi Assume I have a fact table (FactSales) and two dimension tables (DimDate and DimProduct) setup in a star configuration with following relationships FactSales.Date = DIMDate.Date FACTSales.…
- Answered
-
Using a string variable in sql script
If we use a string variable in PQL editor while creating a SQL Script node, the variable is being enclosed in quotes that is causing the sql to fail. Example: @ColumnList is set to: column1,column2,…
- Answered
-
Azure Conection to Pyramid
How can I remotely connect to a virtual machine in Azure that has Pyramid installed ?
- Answered
-
First time buyers
Hi I have a data set that has retailers, sales value and sales date starting from Jan 2022 to current month and I would like to do the following: Firstly - I would like to determine the date the…
- Answered
-
Unable to see discovery in Present
Hi , I am able to see the discoveries in my slide in the design module but it shows some error when i run the Present
- Answered
-
Create general tabs in the My Hub (Home) area
Hello Pyramid, we think the Home or My Hub environment is a great idea. However, we would like this environment to be displayed by default when Pyramid is started.…
- Answered
-
Table of Contents UI
Hi, When I export a dashboard which includes a table of contents from the dynamic text feature, the contents list isn't included. Are there any settings which need to be selected to include this?…
- Answered
-
CouchDB No SQL Database as a data source
HI everyone, Is there a way to connect a NoSQL Couch DB database to Pyramid? Thanks, Sonia
- Answered
-
Customize a Breadcrumb Subtitle
Hi. Is there a way to customize the breadcrumb in a subtitle on a Presentation such that only the slicer values are displayed, and displayed in the order they appear in the presentation?…
- Answered
-
PQL Dynamic text formatting
Hi, I'm trying to write a PQL for dynamic text, so that when the data value selected in my matrix is equal to or greater than 0 it's formatted as Green.…
- 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
-
Revoking Admin/User tokens
Referring to the below REST API reference, the admin token generated using REST API seems valid forever, Is there any way to revoke/invalidate the token once generated.…
- Answered
-
Delete vs Purge ???
Recently, we created some content in a Workgroup Content folder and then moved the content to a folder in Public and deleted the content in the Workgroup folder.…
- Answered
-
Creating "1st Month of the Year of the Previous Month" in a list
I have the following as a Range List which is the *First Month of Current Year* until previous month I want to change the start of the list to be the first month of the previous year instead.…
- Answered
-
Using SQL queries to build reports
Hello, Is there a way to use SQL queries to build the reports themselves? Forgive my unfamiliarness with Pyramid, but I only see the option to query using SQL when creating a data model.…
- Answered
-
Preset number of Y ticks in advance
Hi, I want to build a line plot in discovery that would have pre-set 5 parts to split into, no matter the data min and max. Meaning, If I have 0 as Mix measure and 100 as Max,…
- Answered
-
Monitoring health of pyramid analytics server and in memory db components- telegraf
Does pyramid analytics connect nicely to any telemetry tools like influxdata’s telegraf? I am hoping to manage and observe the health of pyramid analytics in grafana dashboards where we have a number…
- Answered
-
Inserting a blank column
Hi, Trying to build a simple report. Are you able to inside a blank column in Pyramid like you would an excel document?
- Answered
-
Hiding a Column
Hi, Trying to build a simple report. Are you able to simply hide a column in Pyramid like you would an excel document? For example - Where some columns pull through blank i'd like to simply hide.
- Answered
-
Measure Waterfall chart operational in version 2020
Hello all, I'm working in version 2020 and I am struggling to get the custom visual measure waterfall chart to behave. Is there a bug within this object.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.