Imbar's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Filter a second dimension based on the value of a first dimension in Discover
@Malcolm Green Keep in mind that the filters do not "cross inject" one to the other, so if you are trying to have a AsAtDate as a filter and also the custom list above as a filter,…
- imbarmarinescubar_pyram
- 2 days ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
@Malcolm Green Since PQL is multi-dimensional oriented, meaning it works off Member objects and not "plain raw values" like SQL, simply writing CurrentMember inside the StrToMember function will…
- imbarmarinescubar_pyram
- 3 days ago
- Questions & Answers
- Reported - view
Re: Filter a second dimension based on the value of a first dimension in Discover
@Malcolm Green Try this one: --- Using your excel (I've split the tables it into different sheets so I could easily load it into Pyramid's modeling app) I created these 2 tables with the join you…
- imbarmarinescubar_pyram
- 8 days ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@Luke Dyer Yes, the model attribute inside the SUM calculation should be the lowest level of the hierarchy (assuming that the threshold condition is meant to evaluated at that level -> if the…
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@Luke Dyer I Just had another idea as to how to approach this. Create a single custom measure which is an extension of the New Sales calc. The calc was if(condition, value, other value).…
- imbarmarinescubar_pyram
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: How do I limit the available months per year
@Ricky Melamed Glad to help! Add a check for multi-selection of the parameter inside the IF condition: If( {[Custom Query].[Order Invoice Date year].@[....id....]}.Count == 1 && [Custom Query].…
- imbarmarinescubar_pyram
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: How do I limit the available months per year
@Ricky Melamed So do as I wrote in the last section of the original comment: 1 - create a year parameter (you can, in the parameter setup itself, specify you want 24-25 only,…
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: How do I limit the available months per year
@Ricky Melamed Is the user meant to chose 1 year and 1 month? And the grid will be filtered down to the values of the selected year+month? And the header should display what year was selected,…
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
@Luke Dyer many deeply nested exotic calculations could require lots of resources and time to evaluate. Another approach which is lighter to evaluate is to avoid the hierarchy,…
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: How do I limit the available months per year
@Ricky Melamed I'm sorry, I think I'm loosing track of what you are trying to do exactly. Maybe explain in more details, what exactly the grid should look like and what exact slicers do you want to…
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: How do I limit the available months per year
@Ricky Melamed Oh, then just remove the month name. You'll have the years displayed and the values will be filtered down to the months that you have in full months list.
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: How do I limit the available months per year
Hi @Ricky Melamed , You leave the Year and Month Name attributes and create a custom list for Full Month which has July 24 onwards, and drop it into the "combined elements" filter.…
- imbarmarinescubar_pyram
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
Glad to help @Luke Dyer . By the way, ObeeOne's second suggestion, if applicable, is even simpler to implement and will perform better. You can create a new custom measure that looks something like…
- imbarmarinescubar_pyram
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
Hi @Luke Dyer , The rolling up of the hierarchy values is the first mathematical operation that happens. The calculation evaluation happens second. This means that expression that you wrote is…
- imbarmarinescubar_pyram
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Is it possible to do a "Count IF" in a Dynamic Text data set?
Hi @Jason Picker , 1. You can use the count if function with tabulate. Take the grid and drop it into tabulate, then create in the tabulate a cell that has the count if function.…
- imbarmarinescubar_pyram
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: countif
@Ricky Melamed this is failing because of missing ( between the if and the [sheet1]
- imbarmarinescubar_pyram
- 4 mths 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
- 4 mths 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
- 4 mths 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
- 6 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
- 6 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
- 6 mths ago
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

View all topics