Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Removing Outliers Using Pyramid

Notice - all required files to reproduce the example are attached A customer has asked our CS team how to remove outliers from a list in a dynamic way. Before you approach this - how would we define…
- Customer Solutions Architect
- Moshe_Yossef
- updated 2 wk ago
- 1reply
- 44
- 5
- Formulate
Re: YTD Formula in PQL
@Jona Löneke you can also do this with the [KJ Month in Year] parameter, you just need to aggregate a range between January (or the null member- not sure what it represents) and the parameter.…
- Customer Solutions Architect
- Moshe_Yossef
- 2 wk ago
- Questions & Answers
- Reported - view
Re: How can we be able to get the recipient list in the email (Subscription and Publication)
@Aaron Yohannan There are obvious downsides to this - you don't always want to share the full list with everyone, potentially exposing certain addresses you didn't mean to expose or that didn't want…
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- Questions & Answers
- Reported - view
Re: How to calculate "New vs Existing Buyers" with dynamic slicer context in PQL?
Hi @Oren Mkrtchyan , Our team is looking into it. My first advice to you - build it in steps: create a list: Filter( AllMembers([table].[panelist_id]), ([measures].[sales_amount], [table].…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Average invoiced shown instead of totals
@Ricky Melamed Could it be that you only have 19 actual days in Feb 2025? Do you have a date dimension or are the dates from the invoice tables?
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Average invoiced shown instead of totals
@Ricky Melamed If you use the second example - you can simply filter them out in the discover
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Average invoiced shown instead of totals
@Ricky Melamed Are you looking for the daily average? so the average total invoiced per day by months? A. You need to reverse the order: or: Here it is:…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Filter
@sanjay Can you add a screenshot with the different elements you have there? its sounds like you have conflicting filters
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Conditional formatting on a switch list
@Katie Easton So essentially, you use a global parameter to switch between lists, where each list contains 3 measures. how did you set the color and indicator? Did you drag the list to the color?…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Conditional formatting on a switch list
Hi @Katie Easton double click on the measure created for the conditional formatting, then go to measures and open it in forlmulate. This should be a formula that uses "HasItem()".…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Dynamic Function for Total Year
@Jona Löneke So you are selecting a "month-year" using a parameter, and now you need to switch between "last 13 months" and "full year" for this parameter? you can try the following:…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic Function for Total Year
Hi @Jona Löneke The MDX code you provided is a SET (or a list if it was a Pyramid Model). Where is this code put to use? Is it inside the cube? or in Pyramid Formulate? We need some more context here
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Filter with numeric attribute
@Michael Connelly Notice that you have an assumption that the transaction id is a key column for the fact table here. If it wasn't then Hillel's solution would be correct while the PBI example here…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Drop tables in the In Memory Database
Hi Michael, You mean you have an IMDB database with tables that were created in the past, and are now obsolete and will not be used again ? You can try the following:…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Filter with numeric attribute
Hi @Michael Connelly Do you mean you want to filter All the transactionIDs that have a total sales > 32,000 for the bottom grid? That can be easily achieved by right clicking on the sales column and…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Day 2 of 18 Days of Year-End Community Celebration!
@Darren Tuffs Not sure one tool to rule them would be best for us, as it eventually would rule us :-)
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 3
- Member Lounge
- Reported - view
Re: Day 2 of 18 Days of Year-End Community Celebration!
First of all I wouldn't give any tool too much attention :-) I used OpenAI for most things, but when I took a deep dive into DBT I used Google's notebookLM,…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 3
- Member Lounge
- Reported - view
Re: Help: Alert Only on Sales > 0
Hi @Beck Salmon , Can you share a little more on what you did? what does the alert look like and the discover it's based on? Also when you say that if you set it for 3PM it works as expected what…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Filter
Notice my example uses a list - you may want to create it as a calculation (in which case you need to lose all the curly brackets).
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Filter
Ok, let's break it down. First, - to find today as a date we use the date() function, to which we can add days using addDays(). Next we need to figure out how to take a date and convert it to an…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: DistinctCount with filter
Hi @Michael Connelly The approach is to create the measures in the model, and the aggregations in the formulate. I assume [measures].[Impressions Impressions] is defined as a count() in the model,…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: End of Month custom column (EOMONTH formula)
@Jashanpreet Sandhu Yes, the CreateDate function isn't granular. Here's What you can do: 1. Add 1 month, and then reduce the number of days in that added month date: Or if you prefer script:…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Truncating decimal numbers in dimensions
@Michael Daun Yes, you will need to convert it to the string. The idea can be adding scale to ToNumber() or formatting number columns in the model (you can already format date fields, by the way).
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Truncating decimal numbers in dimensions
@Michael Daun First of all notice this is an old post - today you can also use custom columns to achieve this - that would work in direct query as well (albeit - I would recommend adding the column…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Alerts that loop through multiple data points
@dgf Seems like what you want to do is maintain one discover that will serve both the dashboard and the publication. The idea is the same - you create a publication with the discover that you have in…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 6

Back to top

Home

View all topics