-
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
-
Is there an example of how to use the API's to export a discovery as a PDF?
Hello, I've read that it's possible through the API's to export discoveries. Does anyone have example code of how to export a discovery to a PDF using the API's? Thanks, Rob Clark
- Answered
-
Rename an element?
A quick question, and quite possibly something I have overlooked, but, is it possible to do an ad-hoc renaming of specific members within a hierarchy, in a fashion similar to altering the caption…
- Answered
-
Experience on Ipad's
Hi Community, for us it is currently quite challenging to get a good Pyramid experience with an Ipad. We would like to use the pyramid app as it is easier to deploy on multiple Ipad's centrally.…
- Answered
-
Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative
I have 9 custom metrics presently displayed in a matrix grid. These were all built (to the best of my knowledge) in an identical fashion. I have applied conditional formatting to each of the metrics.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.