Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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
- 8 days ago
- 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
- 11 days 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
- 2 wk ago
- Questions & Answers
- Reported - view
Re: MTD YTD QTD manual functions
Hi @Sanjai I am not sure I understand what you want to achieve. What will the user select (a switch button and what else?) and what do you want them to see on the discover?
- Customer Solutions Architect
- Moshe_Yossef
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Pattern for expected behaviour (general Q)
Hi @Emily Kund , In order to do this you need to add the measures to the shapes: or simply drag and drop:
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- Questions & Answers
- Reported - view
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
- 1 mth 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
- 2 mths ago
- 67
- 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
- 2 mths 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
- 2 mths 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
- 2 mths 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
- 2 mths 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
- 2 mths 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
- 2 mths 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
- 3 mths 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
- 4 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
- 4 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
- 4 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
- 5 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 mths ago
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

Questions & Answers

View all topics