-
Option to change the data format to the Europan format: 1.234,56
Hello, it would be helpful to be able to change the data format from 1,234.56 to 1.234,56 as this format is used in Europe. This could either happen in the profile of each user,…
- In review
-
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
Got stuck with a report? Start a discussion or help others to move forward.