Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan Can explain what your model looks like and what you're trying to do? Do you want one list that will have all the values from B.Description and C.…
- Customer Solutions Architect
- Moshe_Yossef
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
Hi @Vijayan Krishnan A list is always designated to a specific table and column /hierarchy. Can you perhaps explain what you are trying to achieve? I'm confident we can achieve the required…
- Customer Solutions Architect
- Moshe_Yossef
- 7 mths ago
- Questions & Answers
- Reported - view
Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds

How to format a measure that is in seconds as hours minutes and seconds Imagine you have a table column in a model that represents the duration of a period in seconds,…
- Customer Solutions Architect
- Moshe_Yossef
- 7 mths ago
- 2replies
- 140
- 6
- Discover
Re: Automated Export/Extract to SQL Server
You can create a data flow in the model. The data source is the discover. The target node is the SQL target. Run the model with an API call, and you're done.…
- Customer Solutions Architect
- Moshe_Yossef
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to have a field ignore a filter in a visual
Hi, Look at this video: https://community.pyramidanalytics.com/t/x2y8fsj/tip-of-the-day-use-formulate-to-calculate-percentages-of-some-elements In this example (the last example on the video) we're…
- Customer Solutions Architect
- Moshe_Yossef
- 8 mths ago
- 2
- Questions & Answers
- Reported - view
Tip of the Day - use formulate to calculate percentages of some elements

Our video of the day looks at a way to calculate percentages of elements A question came up from a client on how to calculate the percentage of two elements in a dimension from the total of this…
- Customer Solutions Architect
- Moshe_Yossef
- updated 8 mths ago
- 161
- 4
- Discover
Re: Question on - How to print a Publication from a Dashboard
Hi @Ying Dong , I suspect the issue is that the publication cannot take a multi select filter, which is what a calendar filter is. You might want to add it as an idea in the ideas section,…
- Customer Solutions Architect
- Moshe_Yossef
- 9 mths ago
- 1
- Questions & Answers
- Reported - view
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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 11 mths 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
- 11 mths 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

1 2 3 4

Back to top

Home

Questions & Answers

View all topics