Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: In a Data Model, I want to use one column as the description for another
@Michael Raam Nice!
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Hello from a Junior BI Analyst – Eager to Learn & Connect!
Hello @Elango. V Welcome to the community - looking forward to your questions and contributions
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 1
- Member Lounge
- Reported - view
Re: 2025 Feature Highlight: Layered Maps
Awesome!
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Product Highlights
- Reported - view
Re: Using CustomerID instead of their address to look up location
Hi @Stefano Sena I think what you want to do is add a customer id filter, and an address filter. Then create an interaction between the customer id and the address filter.…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: The unrestricted rights of administrators
@Michael Daun Well, maybe we should take it a step back: Enterprise Admins in Pyramid have full access to everything in Pyramid - that is the only way an admin makes sense.…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: The unrestricted rights of administrators
Hi @Michael Daun I had a discussion on this with a client recently. They had a request that some data will not be exposed even to the Pyramid Enterprise admins.…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to manage security with migrations between environments?
@Jeanre Van Wyk Notice I was just informed that my initial message may not be accurate - but I think if you can get it to work with the API it's a solid solution.…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Top 10 filter doesn't take each year into account separately.
@Ricky Melamed just add a sort to the years and sort by label.
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Top 10 filter doesn't take each year into account separately.
Hi @Ricky Melamed This can be done using N of N - just select a large number of the first N and 10 for the second one. Here is where you start - all products, all years:…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Cascade for date filter as Date Calendar Type
@Jeevitha Unfortunately not. Calendar and tree filters are both built on the concept of showing all the data in the column / hierarchy. If you want it to work this way,…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Exclude a specific relationship from a Discovery
@itay karkason Sorry still trying to understand. The relationship between project and invoices is one to many. Project have dates and invoices have dates.…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Exclude a specific relationship from a Discovery
@itay karkason Ok, this looks like what you have is invoices that are joined with the project through a project I'd or something like that. Projects have dates, and invoices have dates,…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Exclude a specific relationship from a Discovery
Hi @itay karkason Can you share a screenshot of the model and mark the relationship you don't want to apply? Also I don't understand how come this relationship overrides the date dimension.…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Slicer to switch between months and weeks with same amount of bars in a barchart
@Michael Daun Well I had to go down the rabbit hole - this should probably be fixed for the next release. Moshe
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Cascade for date filter
@Mohit Bhandari Not sure I understand. If you need help can you elaborate on what you're trying to achieve?
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Reordering Columns Once Model Has Processed
@Cindy It isn't clear from your question if you mean the columns in the model (yellow app) or in the discover (green app). In a discover the columns are always ordered alphabetically,…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Cascade for date filter
@Mohit Bhandari In a present it is typically easier than when cascading in a discover - because you don't need to do set up cascade - you just create an interaction between the filters - if you add 3…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Customizing specific background colors in a discovery - Version 2020.16.031
Hi @Yolanda Heldsinger On top of @Mark Oldfield 's answer, if you have a measure you want to color based on a values of a measure, you can do it like this: On the grid you have,…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Cascade for date filter
Hi @Jeevitha So I assume you want to choose a date, and only show Zip Codes from this date, then only show customers from this ZIP code. Step 1: Put the Customer name on the filters.…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Shareable rolling average formula
@Shir Ben-Gal Try extending the range list, and then putting it in nonempty clause, and finish with a tail. Tail( Nonempty( Range(10 dates) ), 5) I think this will likely also exist for days without…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: model development
@Tabitha DeCaprio Looks like the order of columns might be out of order - can you share some screen shots of the data flow - particularly of the nodes entering the union nodes with their columns?
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: model development
Hi @Tabitha DeCaprio Also please make sure the columns are in the same order in both source nodes of the union.
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Shareable rolling average formula
Hi @Shir Ben-Gal The way to do it is to create a formulate that calculates an average over a range for dates form the 4 elements before the current member and current element.…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Slicer to switch between months and weeks with same amount of bars in a barchart
@Michael Daun So essentially, you have 2 custom columns. 1. Switches between month and weeks. 2. Switches between the month sequence (-1, -2 etc) and week sequence (same values, for weeks).…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Slicer to switch between months and weeks with same amount of bars in a barchart
@Fabian Frank While I would use the mini tabs 9/10, if there is a significant requirement for this to work that way - here's what you can do: The key problem here is that you have 2 different column…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- 2
- Questions & Answers
- Reported - view

1 2 3 4 5

Back to top

Home

View all topics