Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Access Multiselect Parameters values in Formulate
Hi @Raja Sambasivam I have found a way to achieve this. It works, but you need to notice how it performs: 1. in the model (or in forlmulate): create a custom column which is the same as the column…
- Customer Solutions Architect
- Moshe_Yossef
- 3 days ago
- 1
- Questions & Answers
- Reported - view
How to use KPIs and Gauges in a Dynamic Way

How to use KPIs and Gauges in a Dynamic Way The Use Case Working with a customer, I recently ran into an interesting use case that required dynamic band values in a KPI and a gauge view.…
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- 58
- 4
- Formulate
Re: How to: Create a dynamic set of dates
@Ying Dong I don't understand then. Can you explain a little more - you have a table with "referrals" that have "first_referral_date" you want to choose MinDate and MaxDate, and receive:…
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- Discover
- Reported - view
Re: How to: Create a dynamic set of dates
@Ying Dong the first thing can be done just by using formula in a calendar filter. The second is more complicated. Just to be sure - you want a user to select a range,…
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- Discover
- Reported - view
Re: Help needed with Real-time data input and String search
@Sanjeeth Baliga I know this may seem simplistic, but if you put the customer attribute in a filter, open the filter and search "Angela", won't you get exactly what you're asking for?…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Schedule Model Refreshes for a window of time
Hi @Mad Amruthur , There is another option, it's not ideal but it is simpler: You can create a schedule that runs every 15 minutes, and in the master flow create a condition that checks the day of…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 3
- Questions & Answers
- Reported - view
Re: Replace no values with -, N/A, or no data
Hi @Emily Kund, there is a way to achieve this, although it has it's limits. Adding to @Michael Daun 's post here. The problem like he wrote so well is that this isn't a null value,…
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds
@Achim Stump just remove the auto format from the axis:
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- 1
- Discover
- Reported - view
Re: Creating a formulate based on the caption of the current member for a different dimension
Hi @Niko Z , Try using: {StrToMember([B].[Year],[A].[Year]CurrentMember.caption())} This worked for me.
- Customer Solutions Architect
- Moshe_Yossef
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How can I get the count of days for every month using Formulate (Custom column)?
@Raja Sambasivam Do you have a separate table for dates or are the date columns in the main fact tables (so - are they filtered by the age or not)?
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic caption for lag member
Hi @Katie Easton , First of all, this looks like you're in a Pyramid model, so the language is PQL, the differences from MDX are small but you should pay attention to them.…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Last 'N' dates list Based on Date Filter
This might help: https://community.pyramidanalytics.com/t/83hcjz5/how-to-build-dynamic-today-current-month-previous-month-etc-in-pyramid-formulate
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Calculation based on Date Filter Range
@John Fonte Sorry I missed this notification. You can add a dates dimension that will have all the months and dates.
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Font color not working on light blue color background .Ex Font color :#FFFFFF, Background Color:#85CCDB
Hi @Vijayan Krishnan Please make sure auto color is off, and you will likely need to turn off readability.
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: How to define a common scale for primary and secondary Y-axis?
Hi @Michael Daun You don't need a secondary axis for it, you need to use the primary axis for both measures. When you drag the second measure to the values, select primary axis,…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Calculation based on Date Filter Range
@John Fonte happy to help. Any granular measure is defined the context of the model, it can be very helpful.
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Case Statement in model
@Tabitha DeCaprio Can describe what your model looks like? What are the tables participating in your example and how are they related?
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Case Statement in model
@Tabitha DeCaprio Can you try a custom column: IF( [Term_ID]=[Term_ID], [AID_TOTAL], 0 ) And then define a sum on this custom column?
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Calculation based on Date Filter Range
The easy option is to create a granular measure in the model that will be a count distinct on the months (or actually on the full month name or something like that).…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Granular Size and Position Control
@Rima Issa Also notice each item's position can be set to the pixel in the component tab:
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
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
- 5 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
- 5 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
- 5 mths ago
- 2replies
- 122
- 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
- 6 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
- 7 mths ago
- 2
- Questions & Answers
- Reported - view

1 2 3

Back to top

Home

Questions & Answers

View all topics