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?…

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.…

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…

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.…

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…

Remove Print-to-PDF in Embedded mode

Is there a way to remove the Print-to-PDF option in Embedded mode (just leaving Excel)? We have lots of embedded Presents that are big tables and rather than explaining to users not to use the PDF…

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.…

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

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.…

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

Azure VMs - Supported SKUs for 2023 update

What are the Azure VM SKUs that are compatible for use with Pyramid version 2023.1? During an upgrade to the latest 2023 version, the installation gave this warning:…

Is there a way to add a discovery to a tabulation without it merging fields?

Hello, Is there a way to add a discovery to a tabulation without it merging the fields? It can be difficult to do formulas against merged columns. I know when I export to Excel I can turn merging off,…

• Answered

Building Custom Filters

Hello, I am trying to create a custom filter for my queries using the Filter() function that I have read documentation on. I believe this will be useful for what I am trying to use it for.…

Count the number of customers depending on specified levels (nested if)

Hi all, I am trying to create a count of customers depending on set Orders Recevied intervals. I.e. for the specific time periods, how many customers made orders within e.g. 1.…

• Answered

Dynamic filter for various slides in the same dashboard

Hi, I want to create a Cube based dashboard with multiple slides. I want to add a country filter for all the slides but each slide it will show just the relevant countries for this specific slide -…

• Answered

Can you switch off Totals for specific columns in a Matrix Grid

I have this grid and don't want Totals for the O'Stock columns. I tried using Colour to no avail, all help greatfully received

• Answered

Use API's to extract data from a discovery

Hello, Is there a way to make an API call to export data from a specific Discovery? Thanks, Rob

• Answered

Using cascading slicers/filters

Hey all, We have a hierarchal table like the one shown above with simple data in the table and this table is hosted in Redshift. When I do cascading slicers so 1 interacts with 2 interacts with 3 etc…