Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
- 13 days 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
- 2 wk 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
- 2 wk 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 wk 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 wk 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 wk 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 wk 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Slicer to switch between months and weeks with same amount of bars in a barchart
Hi @Fabian Frank My first tip would be doing this with a minitab in present. create two discovers - one with last 12 week, the other with the last 12 moths,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Alerts that loop through multiple data points
Hi @Shir Ben-Gal , Well, the easy way is to create a warning that will be sent if there is any row in the report that exceeds 20%. In your trigger definition you can try the following code:…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: 2 elements in 1 minitab
@Ricky Melamed Here: I have a parameter called switch with 3 values. I am adding actions: adding action to switch 3 tabs in the first mini tab element: the second: and the third: I hope this helps.…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: 2 elements in 1 minitab
Hi @Ricky Melamed When I ran into this requirement, what I did is: 1. I created 2 minitab elements, put in each one the number of mini tabs I needed (say 3) 2.…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: is there a way to calculate an mesure avarage for the last year from yestrday?
Hi @Irad What is your data source? Is this an OLAP cube or a Pyramid Model? (As I recall it is OLAP - correct me if I'm wrong). Do you have a hierarchy that is just date or do you use a date…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Multiple slicers in Mini-Tabs
Hi @Aufrida Pamungkas Like @Eduardo Azanza wrote, there is no straight way to do it. You could allow the user to choose one of 4 visuals on their own. There is another alternative,…
Attachment
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Tenant-localizable field names
Hi @Jen Hoecht Adding to @NPANS remark, you could add an overlay using API3: Adding Hierarchy overlay Adding Measure Overlay
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Publication Subject - Bold
Hi @Aaron Yohannan From the other messages here it seems like there isn't a way to achieve a bold text in an email subject. Just think about it - a bold email subjects is already used to indicate an…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Report shows unwanted data after user adds new Dimension in Analyze Further
@Moshe Shaked In your example, The measure called "NACD Incoming calls all groups" and the following measure, both have data for all the rows. I assume this is why you see agents you don't wish to…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Report shows unwanted data after user adds new Dimension in Analyze Further
Hi Moshe, Some of your measures appear to have data for all these agents, which is why they appear in the grid. Can you explain what these calculations do? look here:
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

View all topics