Conversations - how to mark as read?

We are using conversations to communicate within our development team. How do we mark it as read?

• Answered

Percentage points change calculation

I am trying to calculate change in percentage points between two rows and have followed the steps in a previous post: Click on the "+" icon in the vertical column of icons to the left of the Grid…

• Answered

How to calculate an average at a lower Time level of detail than a Discovery

Hi All, Not sure how to create a formulate calc to do this if anyone can help. This is against a Direct SQL model. The grain of my data is: Week, Opening Stock, Sales.…

• Answered

Format gauge chart

Trying show the full number detail. Right click on the transaction count chip brings up the properties menu. I select #,# and no label format but it doesn't change. Are gauges always rounded?

• Answered

Live Connection SAP BW - Extrapolation of Budget values to a monthly split (linear)

Hi there, I would like to extrapolate the following budget values to a monthly view from a given year view only. For example, from SAP BW we only get the annual accumulated budget figure.…

• Answered

Custom Visualizations

The formulate module should have a option for "Custom Visualizations". I dont see it, neither in our pyramid analytics platform nor the explore one of the community?

• Answered

How to

Hi there, In the pie chart below how can I format the yellow highlighted figures in such a way that the sales percentage is below the sales figure.

• Answered

Paging for long tables

Hi, We are in the process of converting a legacy system to Pyramid and are facing a challenge regarding long tables over 30K rows. We don't want to show long table and are looing for a way to load…

• Answered

Make maps less that 180x180

How can I override the bottom limit on the size for view on the canvas. It appears that it automatically goes to a BAN when the width or height is <=170 px.…

• Answered

Matrix Grid multiple rows not expected

In the table shown, there is only one value (quintile) for each row (State) and column (Type). Why does each state have multiple rows? How can I get it to only show populate cells?…

• Answered

Remove dimension from data label in tile plot.

I want to edit the data label to only show the State abbreviation. I don't need to show the dimension Quintile Name in the tiles. It is picking this up bc it also defines the color.…

• Answered

How to get export of Excel file which is getting used in the report.

Hi, I have a demo report. In the model of that demo report, they are using one dataset. I want to export that data file which is in Excel.

• Answered

How to create group headers for certain columns in Discover

What are the steps to create grouped/merged column headers in discover for Name and Address in Row 1? the discvover has 20 columns so adding just a text box in Present doesn't work well with the side…

• Answered

Sorting with Trellis

Hi, I have a trellis graph and I want to be able to sort values descending on both graphs separately. At the moment it half sorts the graphs, as you can see below it picks up the largest value…

• Answered

IMDB Setup on a Kubernetes deployment

Hi there, wondering if there is any specific information about setting up the IMDB (in memory database) source server specifically in a kubernetes environment.…

• Answered

How to restore a deleted workflow?

• Answered

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