-
KPI with dynamic texts
Hello, I am trying to add a dynamic text to the KPI which shows a Year-over-Year change in between the quarters in my presentation. However, the text only returns a result if all years,…
- Answered
-
Dynamic SQL - Field Name Changes
Hi I have a table that has values in different languages, I wondered if there is a way to pass the field name for the 'current' language as part of a custom sql statement,…
- 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
-
Use single measurement as a fixed / set Measurement AND as a Dynamic Measurement at row level or in Calculation
Dear all How can I create a measurement with a set/fixed value that any filter or dimension will not impact? I am working in Higher Education, so my use case will be unique as it is not a commercial…
- Answered
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
Multiselect Dynamic measure
Hello! Is it possible to use multiselect with Dynamic measures? The way I tried in the picture is not working. Kind regards, Dennis.
- Answered
-
Last updated date & time
I remember in BI Office, it was possible to add a text field showing the date and time the source model was last updated. I cannot seem to find this in Pyramid (2018.05.…
- Answered
-
Dynamic texts for Slicers
Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…
- Answered