Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Dynamic SQL - Field Name Changes
@Stephen Murfitt This is exactly what translations do. Suppose your model default language is English, your Product column will be Product_En. Then you add a translation to French,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Dynamic SQL - Field Name Changes
Here are links to translations in our help section: Translation panel in model definitions Translation attributes Let us know if this helps, Regards, Moshe
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Dynamic SQL - Field Name Changes
Hi Stephen, Can you elaborate on the structure of your data? I would expect our support for translations in a model to be sufficient for what you're asking, are you familiar with this option?
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Scheduling during work hours
Also - you can create a schedule and call it using the API - and then schedule the API call using whatever scheduler you have.
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Scheduling during work hours
@Bruce Campbell Well you were very close :-) here's my code debugged: hour(datetime()) >= 8 && hour(datetime()) <20 or (this is yours with proper brackets :-) ) ConvertToNumber(DateFormat(DateTime(),…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Scheduling during work hours
Hi @Jen Hoecht One solution could be: 1. create a one time schedule for the desired model (Model A). 2. Create a new model file, go to master flow, delete the default data falow. 3.…
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- Questions & Answers
- Reported - view
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
- 151
- 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
- 318
- 8
- Formulate

1 2 3 4 5

Back to top

Home

View all topics