-
PQL lookup second largest value
Hello, I am trying to write a PQL function which will find the row with the second largest value in a particular column of my matrix, is there a way to do this ? Thanks, Katie
- Answered
-
Top and Bottom N filtering
Hi, I want to be able to filter my matrix to show both the top 1 and bottom 1 value in the same table. Is there a way to do this? Currently I can only see that its possible to do one or the other…
- Answered
-
Rolling average on a switch list
I have a discovery which is driven by a switch list containing two parameters. I would like to be able to apply a rolling average on each of the values when selected,…
- Answered
-
Dynamic caption for lag member
Hi, I want to add a dynamic caption, which displays the member name rather than the name of my formula. My formula finds the lag 4 of a member which is selected through a parameter.…
- Answered
-
Rolling average formula
I'm currently trying to create a formula to calculate the 3 week rolling average, the reason we're doing it in formulate rather than through the context calculations is because it will form part of a…
- Answered
-
Setting dimension elements to a secondary axis
Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…
- Answered
-
Default theme not pre-selected
Hi, I have created a new theme (circled below) and made it the default within my pyramid environment under the admin settings, however when creating a new present / discovery the old default theme…
- Answered
-
Default panel settings
Hi, Is it possible to amend the default panel settings for a discover in present? Under themes in admin content there are a lot of configurable formatting options,…
- 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
-
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
-
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
-
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
Latest Posts