imbar's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: PeriodstoDate (MDX) for InMemory (PQL) List
MTD expects 1 argument and returns the list of elements within the same month up to the selected value. This will generally work only on the date level, since there are no other levels below month.…
- imbarmarinescubar_pyram
- 9 days ago
- Questions & Answers
- Reported - view
Re: Create an OR filter
Hi @Mad Amruthur , You can create a calculation and then filter by it. For example, you can create a custom column (formulation app -> column) and then add it as a slicer to the discovery.…
- imbarmarinescubar_pyram
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Free Text Parameter interacting with Present content
@Len I See. So the filter you currently have set is a numeric filter, meaning, filtering the session_id where a measure value would be equal to X. Instead you need to be using a text filter,…
- imbarmarinescubar_pyram
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Free Text Parameter interacting with Present content
Hi @Len Stockdale Could you share the generated SQL and point out was is not right with it? Thanks, Imbar
- imbarmarinescubar_pyram
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Making Custom Bins With Measures For Discover
@Cindy Tran You can create a textual custom measure like this: case( [measures].[data returns] < 10, "0-10", [measures].[data returns] < 20, "10-20", [measures].…
Attachment
- imbarmarinescubar_pyram
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Making Custom Bins With Measures For Discover
The technical answer would be "no" on nesting measures within the expression of a custom column (that's why you can't see any blocks for them). But maybe if you share some more details about the…
- imbarmarinescubar_pyram
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Making Custom Bins With Measures For Discover
Hi @Cindy Tran , You can create a custom column and using the case function split the Age attribute into custom bins. For example, I created this custom column: case( [customerProfile].…
- imbarmarinescubar_pyram
- 3 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Geocode Missing error
Hi @ArunKumar , I only get this warning with the USA states when I changed the Geo Defaults. Could you check your settings? It should be either no country selected or USA selected.…
- imbarmarinescubar_pyram
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Date comparison with DateDiff
@Daniel Jaldin Pyramid does have a ToDate function for building custom columns. It's visible as a Casting Block in the Logic app, but seems to be missing from the list in script mode.…
- imbarmarinescubar_pyram
- 3 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Filter Selected Date
Hi, you can also try to use the range option within the calendar filter:
- imbarmarinescubar_pyram
- 4 mths ago
- 3
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
@Ying Dong I think i understand what you did based on the column headers in the image. The first 4 columns are indeed aggregations of the Length column, as you would calculate in Postgres.…
- imbarmarinescubar_pyram
- 5 mths ago
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
There is no way currently to select 90 percentile in the model. You can try to do it via a semantic calculation based on a set of the relevant attribute: https://help.pyramidanalytics.…
- imbarmarinescubar_pyram
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Renaming a measure
@Dotan Beker@Nkhensani Khoza , That's actually renaming the attribute (column). To rename the measure go here in the tables view: or here in the column view:
- imbarmarinescubar_pyram
- 6 mths ago
- 3
- Questions & Answers
- Reported - view
How to find the "1st Month of the Year of the Previous Month" in a list

How to find the "1st Month of the Year of the Previous Month" in a list In this question the user was asking how to find the first month of the year, but the basis for this search would not be the…
- imbarmarinescubar_pyram
- 7 mths ago
- 70
- 1
- Formulate
Re: Dynamic calculation measure for Prev Qtr End using selected date of report
Hi, Assuming the Quantity is a measure in the model, and that you have the report filtered using a date column, giving you the first 2 columns in the report,…
- imbarmarinescubar_pyram
- 8 mths ago
- Questions & Answers
- Reported - view
Re: OpenAI Integration - How to view the query of the "AI driven value"?
Hi @Fabian Frank , As descripted here: https://community.pyramidanalytics.com/t/g9yy7yt?r=x2y3dp0 The ChatGpt function is agnostic to the query. It's actually a generic function that you could use in…
- imbarmarinescubar_pyram
- 8 mths ago
- Questions & Answers
- Answer
- Reported - view
Re: Pyramid Open AI Evaluation
@Fabian Frank The ChatGpt function within the Formula designer does not have any context that is not given to it directly. Also, like any other Formula,…
- imbarmarinescubar_pyram
- 8 mths ago
- 3
- Questions & Answers
- Reported - view
Re: PQL Dynamic text formatting
Hi @Katie Easton , Try this one: if(data(0,1) >= 0, fontformat(formatteddata(0,1), "Green"), fontformat(formatteddata(0,1), "Red")) I'm not sure why that first format was there.…
- imbarmarinescubar_pyram
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Creating "1st Month of the Year of the Previous Month" in a list
@Satveer Kaur You can use the addmonths function to get the previous month (would return Dec 2022 give Jan 2023) dateformat(addmonths(datetime(), -1),"YYYY")+"01"
- imbarmarinescubar_pyram
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Creating "1st Month of the Year of the Previous Month" in a list
Hi @Satveer Kaur , You could do something like this: round(dateformat(datetime(),"YYYY")-1)+"01" Similar to what you already have, just substracting 1 from the year and ensuring you don't have any ".…
- imbarmarinescubar_pyram
- 1 yr ago
- Questions & Answers
- Official response
- Reported - view
Re: Count of positive values in sub query
Hi @valeriia , Using Ian's same model, you can create this custom measure: if([Sheet1].[ship to ID].currentmember.uniquename != "*", // ship_to_id is in the query if([measures].…
- imbarmarinescubar_pyram
- 1 yr ago
- 2
- Questions & Answers
- Official response
- Reported - view
Re: Member Security - return default if no rows matched
@Paul Narup , In the security script you can write any PQL list expression. You can use this script to check if an item exists and if not return a different, default item:…
- imbarmarinescubar_pyram
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: What is the "AI Driven Value" option?
Hi @Robert Clark , It's a quick measure that you can ask chatgpt about the attribute you clicked on. For example, on country: And the calculation looks like this:
- imbarmarinescubar_pyram
- 1 yr ago
- 2
- Questions & Answers
- Official response
- Reported - view
Re: comment out parts of formulate in business logic
Hi, You can use either type of commenting method: 1+2+3 // comment after slashes or 1+ /* comment between star-slashes */ 2+3
- imbarmarinescubar_pyram
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Pyramid Usage Model and Analysis
Hi @Michael Daun , The server time is the entire time that the server handled the request minus the Query Time. That might include queueing time, for example,…
- imbarmarinescubar_pyram
- 1 yr ago
- 1
- Tech Blogs & Webinars
- Reported - view

1 2 3

Welcome to the Pyramid User Community

Pyramid User Community

imbar

Re: PeriodstoDate (MDX) for InMemory (PQL) List

Re: Create an OR filter

Re: Free Text Parameter interacting with Present content

Re: Free Text Parameter interacting with Present content

Re: Making Custom Bins With Measures For Discover

Re: Making Custom Bins With Measures For Discover

Re: Making Custom Bins With Measures For Discover

Re: Geocode Missing error

Re: Date comparison with DateDiff

Re: Filter Selected Date

Re: How to calculate 90 percentile based on category

Re: How to calculate 90 percentile based on category

Re: Renaming a measure

How to find the "1st Month of the Year of the Previous Month" in a list

Re: Dynamic calculation measure for Prev Qtr End using selected date of report

Re: OpenAI Integration - How to view the query of the "AI driven value"?

Re: Pyramid Open AI Evaluation

Re: PQL Dynamic text formatting

Re: Creating "1st Month of the Year of the Previous Month" in a list

Re: Creating "1st Month of the Year of the Previous Month" in a list

Re: Count of positive values in sub query

Re: Member Security - return default if no rows matched

Re: What is the "AI Driven Value" option?

Re: comment out parts of formulate in business logic

Re: Pyramid Usage Model and Analysis

Home