imbar's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Join with a constant
Hi @Mad Amruthur You can create a custom query and build the join into it directly. See here: Custom Query
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Difference between the calculations
@Shuvankar Mondal PQL and MDX do share many similarities, so MDX is a good reference for most things - mainly at the semantic layer which Ian mentioned in his comment.…
- imbarmarinescubar_pyram
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Difference between the calculations
@Shuvankar Mondal ( ) are used for functions and for tuples. Sum(4,5,6) -> add up 4, 5 and 6 ([product].[category].[bikes],[measures].[sales]) -> give the sales value filtered by bikes { } is how you…
- imbarmarinescubar_pyram
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Difference between the calculations
Hi @Shuvankar Mondal , I think that the key is to understand the building blocks and the functions. The building blocks are: 1. attribute and hierarchies - [table].[column] and [table].^[hierarchy] 2.…
- imbarmarinescubar_pyram
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: countif
@Ricky Melamed this is failing because of missing ( between the if and the [sheet1]
- imbarmarinescubar_pyram
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: countif
@Ricky Melamed is that the name of the table and column that you have in the model? I tried with [customers].[country] and it worked fine.
- imbarmarinescubar_pyram
- 1 mth ago
- Questions & Answers
- Reported - view
Re: countif
Hi @Ricky Melamed , you can simply create 2 custom measures in formulate app: count(if([table].[win/lose] = "Win", 1, null)) count(if([table].[win/lose] = "Lost", 1,…
- imbarmarinescubar_pyram
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Filtering child of hierarchies; not parent.
Hi @Ricky Melamed , There's a feature called N-of-N which allows this exact filtering logic (each level filtered within the scope of the previous level).…
- imbarmarinescubar_pyram
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Display dates in viewer's timezone
Hi @Chad Myers , This is not currently supported out of the box. One way to achieve this could be by creating a calculated column with an offset of hours at let the users select the time zone…
- imbarmarinescubar_pyram
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Top and Bottom N filtering
@Katie Easton You don't need to add a 4th argument, but to change the 3rd one. Currently the 3rd argument is simply "[When - Quarter].[When - Quarter].[+14....+]".…
- imbarmarinescubar_pyram
- 3 mths ago
- Questions & Answers
- Reported - view
Re: How to replace a string cell with a text value using Calculated Column
@Roman Lyakhovsky Could it be that the value is not NULL but rather an empty text? Try if([Description]="", "No Data", [Description])
- imbarmarinescubar_pyram
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Top and Bottom N filtering
@Katie Easton You need to add to the filters the "column" you want to filter by. So the top 10 should have ([measures].[+b88...+], [When - Quarter].[When - Quarter].…
- imbarmarinescubar_pyram
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Top and Bottom N filtering
Hi @Katie Easton , You cannot currently do this using the filter wizard (but you will be able too in a future version). Instead you'll need to create a custom list.…
- imbarmarinescubar_pyram
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Dashboard Gallery: Champions League 24/25
@Mikhail Pikalov but how do I log in? :D
- imbarmarinescubar_pyram
- 5 mths ago
- Pyramid Dashboard Gallery
- Reported - view
Re: IN operator in Pyramid Formulate (Custom Column)
Hello @Mad Amruthur , Pyramid does not have an "in" function. The 2 possible ways to write this would be: IF([col] = "10" or [col] = "11" or... , "GOOD", "BAD") or SWITCH([col], "10", "GOOD", "11",…
- imbarmarinescubar_pyram
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
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
- 7 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 10 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
- 10 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
- 10 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
- 10 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
- 10 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
- 11 mths ago
- 3
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

View all topics