Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to find weighted average using formulate to be able to use it in reports
Hi @Chaitali Bhavik Sanghavi Weighted average is by definition Sum(weight * measure) / Sum(Weight). So I would follow these steps: 1. create a calculated column (in the model or in formulate,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 3
- Questions & Answers
- Official response
- Reported - view
Re: Obtaining accurate summations in a Many-to-One Relationship
Hi @John Fonte Trying to make sense of this: Facility 1 used to purchase Items A, B and C, and is now purchasing X in their stead? You want to show both the original purchase (A,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Is there a way to filter out rows that are only showing inf and -nan(ind)?
It looks like you have quite a few formulations in this grid. the inf and nan values are most likely a result of division by 0. I would find the formulate where this division takes place,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Difference actual week- week prev year
@Janine Ellner So you want to show 6 weeks on the X axis, and have 3 trellis, current year, previous year and the difference?
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: number formatting: negative numbers in parentheses
Hi, already exists: Here is a tabulate sheet with negative values: Now I will select the column with negative values, and open the formatting panel: next I will replace general with custom,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 2
- Questions & Answers
- Official response
- Reported - view
Re: Introduction
Welcome, looking forward to your questions. Make sure you also follow the learning live sessions: https://community.pyramidanalytics.com/category/Learning-Live-Content Regards,
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Show an average of the selected members of a filter.
@Jair Rangel Just make sure when you create the parameter to mark it as a multi select Parameter :
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Feature Request: Reversing Axis Value Order in Attached Image
Also, if you want to completely avoid showing the minus sign, you could use the format for the measure in the following way: It will then show the number in brackets - and you will avoid the minus…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Feature Request: Reversing Axis Value Order in Attached Image
Well, an immediate solution would be to define a negative measure... I would name that measure just "Y Axis" or something like that, and then put the actual measure in the tooltip - so users will see…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Can I create a custom hierarchy of measures
@Christopher Tecchio You don't need a new model file. Use the same model, add a data source with the role playing dimension table (MeasuresTable) - it can come from an excel file or txt or whatever,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Previous Month Value
Just adding to @Obee1 's great answer - This is not a contextual calculation, it is a semantic calculation, as you want it to be based on the data, not on the data shown in the discover.…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Can I create a custom hierarchy of measures
Another Approach is to use formatting to differentiate the total from the components. using a bold header, a background color etc. Regards, Moshe
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Can I create a custom hierarchy of measures
Hi @Christopher Tecchio , You could try to create a dimension table (suppose it's called MeasuresTable), which will have 2 columns, like this: Bottom Measure Top Measure Measure A Measure Total…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
@Malavika Nair I assume Ian will also address this, however I don't understand how can the return% aggregate as a product? If I have one row in the data where the return % is 5%,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
How to customize the Breadcrumb Subtitles

How to customize the Breadcrumb Subtitles Breadcrumbs are little texts displayed in reports and presentations that give the users orientation about the whereabouts of the content of the displayed…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 133
- 1
- Discover
Re: Customize a Breadcrumb Subtitle
Hi @Bruce Campbell , Well here's what I just got working with a place holder. Notice that I can manipulate the Value() in the placeholder. So I used the following code:…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Customize a Breadcrumb Subtitle
Also, you could replace the breadcrumbs with dynamic text. You can create a dynamic text with 3 place holders, and interact each filter with one place holder.
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Customize a Breadcrumb Subtitle
Hi Bruce, If you change the filters, they should show the selection in the breadcrumbs, don't they?
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
How to: Display Daily Data in a Calendar View

How to: Display Daily Data in a Calendar View When you are working with Daily Data it will sometimes make sense to display the information in a Calendar view.…
- Customer Solutions Architect
- Moshe_Yossef
- updated 1 yr ago
- 304
- 8
- Formulate
How to: Create a dynamic set of dates

Question: How to create a dynamic set of dates During a recent discussion we got asked how to create a dynamic set of dates. There are two approaches to the tasks,…
- Customer Solutions Architect
- Moshe_Yossef
- updated 1 yr ago
- 5replies
- 395
- 5
- Discover
Re: Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?
Hi @Paul Narup I see in the screenshot you're showing a query, not a table. What Ian wrote is also true for queries - once created, a query has an internal name that cannot be altered - only the…
- Customer Solutions Architect
- Moshe_Yossef
- 2 yrs ago
- 1
- Questions & Answers
- Answer
- Reported - view
Re: Sortting on aggregated measure on PostgreSQL
Hi @Fergus Ustianowski I think a max aggregation on a date returns a text, which is probably why the sort doesn't work. Could you create in your model an integer column representing the date -…
- Customer Solutions Architect
- Moshe_Yossef
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?
@anonymous client Hi, What happens is that you have the same street names in various cities. So the cascading takes the city ("Seattle" for example), and creates a list which only has the street…
- Customer Solutions Architect
- Moshe_Yossef
- 2 yrs ago
- Questions & Answers
- Reported - view
How to build Dynamic Today, current month, Previous Month etc. in Pyramid Formulate

How to build Dynamic Today, current month, Previous Month etc. in Formulate Get Dynamic Dates Using Formulate Wizard. To make the access on the latest information,…
- Customer Solutions Architect
- Moshe_Yossef
- updated 2 yrs ago
- 365
- 3
- Formulate
Re: smart discover - change order of nesting
@Avi Perez I meant in smart discover, without going to full discover mode
- Customer Solutions Architect
- Moshe_Yossef
- 4 yrs ago
- Questions & Answers
- Reported - view

1 2 3 4 5

Back to top

Home

View all topics