-
Count of positive values in sub query
hi all, Can you please help me to reproduce the metric from PBI DAX calculation in PQL? the story is the following - at any time dynamically we need to have counted positive values within internal…
- Answered
-
Actions > Jump to Content
Good morning! Working on adding a drill through to a discovery (on two different discoveries in the last week actually) and when I "jump to content item" and include context,…
- Answered
-
Shapes & pattern from png or svg
Hey! I would like to make visuals, where the data point patterns or shapes are based on images retrieved from URLs. For example, I could have columns be patterned as country flags or company logos,…
- Answered
-
Capacity limit to number of accepted lists in Discovery's Variable List Wizard
Is there a limit to the number of lists that can be accepted when building a Variable List using the Variable List wizard in Discovery. I am trying to add 47 lists, however,…
- Answered
-
Mimic member logic within lists
Hello folks. I have a very handy variable list object which filters a large number of products into the end-user's desired internal product categories. I would like to now compute the percentage…
- Answered
-
get measure monthly count for last 12 months
I have a [Measure] and that I want to show it's trend on a monthly basis. Therefor I created the following logic: strtomember("[Date].[Calendar].[Date].["+ format(now()-1,"yyyy-MM-dd")+"]").parent.…
- Answered
-
Custom Columns and OLAP Cubes
We just installed Pyramid 2023 in our development environment and I am in the process of test driving some of the new features including custom columns.…
- Answered
-
Member Security - return default if no rows matched
We are looking to apply a security rule to a table using member security. In our security table, there is a default row that should be matched to if the user does not meet the security rules.…
- Answered
-
What is the "AI Driven Value" option?
Hello, I see there's a new option, when right clicking on dimension attribute, labeled "AI Driven Value" How do I use this? I searched the help documentation and the community forums and can't find…
- Answered
-
Using a SQLServer Table Value Function in Pyramid
Hello, Has any one tried using a SQLServer table valued function in a mode ? For e.g. I have a TVF that tables date as an input select * from schema.table(@date) Where date is a literal that can be…
- Answered
-
PQL for checking if date is null
Trying to find the correct syntax for checking if a date is null in a script formulate. Currently accessing the date via [pyramid_custom_query_t_placement_patient_hsptl].[cl_effective_from_date].…
- Answered
-
Can R or Python models be easily imported into a Data Model?
Hello, We have existing R and Python models developed in RStudio. Is there a way for us to import these models into a Pyramid Data Model? Thanks, Rob
- Answered
-
Cascading parameters
Hello folks. Does Pyramid have the ability to build cascading parameters? I would like to have a text parameter control the output of two independent numeric parameters. Cheers, Dave
- Answered
-
Date filters allow range and null selection
Use case: Users need to be able to select a date range (YTD 2023 for example) and also have the ability to return the rows that have a NULL date. Using the multi select dropdown is not an suitable…
- Answered
-
Sortting on aggregated measure on PostgreSQL
Hey all, I'm looking at trying to find the latest date for user logins in pyramid, using the username dimension and then creating a max formula for date dimension to find the most recent date.…
- Answered
-
Text parameter which retrieves date ranges
Hello everyone, Is it possible to map text captions in a parameter to individual list objects. The business context is to enable the formation of date ranges which are either calendar or fiscal in…
- Answered
-
Splitting dataset Train Error
I am trying to spilt dataset into a train and test using Python Node and Learn&Predict. I get an error below related to pyramid_eval_out.write. How can it be fixed? Error PyramidException:…
- Answered
-
Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?
When renaming a direct query table, the original table name is often used in other areas (security scripts, join statements as shown in attached image).…
- Answered
-
Custom user dimension linked to a specific e-mail account
Dear all Irrespective of my attempts, I still need to succeed in creating a dimension of specific users/clients with a particular e-mail account suffix.…
- Answered
-
Identifying Duplicated Elements
Hi all, I have a discover object containing products and their status. I want to identify products where the attribute status is duplicated. i.e. Products where the status has been assigned more than…
- Answered
-
Multi-measure pie charts
I have to measures in percentage that add up to 100% and I want to show in one pie chart both of them. I'm using version 2020.27.113 but it doesn't work for me. Could you please explain how to do it?
- Answered
-
real time data refresh
For the use case of direct database query is it possible to set an automatic refresh let’s say every 10 seconds without clicking run query or interacting with the chart?
- Answered
-
Get data from 2 months ago
Hi, I need to get for a new business logic (AKA formulate section) data dynamically from 2 months ago in order to divide it by data from 1 month ago. I don't have the "2 months ago" filter built-in…
- Answered
-
comment out parts of formulate in business logic
Hi, I'm writing a business logic using a formulate and calculating it based on a calculation of (a+b+c) / (z+x+c+v). I want to check each part on its own to make sure it gives the right output.…
- Answered
-
LineBreak in a measure
Hi, I'm trying to create a measure to be used as tooltip and it could contain text that is long. Is there a way to add a line break or new line in the measure via a PQL formula ?…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.