Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Help: Alert Only on Sales > 0
Hi @Beck Salmon , Can you share a little more on what you did? what does the alert look like and the discover it's based on? Also when you say that if you set it for 3PM it works as expected what…
- Customer Solutions Architect
- Moshe_Yossef
- 3 days ago
- Questions & Answers
- Reported - view
Re: Filter
Notice my example uses a list - you may want to create it as a calculation (in which case you need to lose all the curly brackets).
- Customer Solutions Architect
- Moshe_Yossef
- 4 days ago
- Questions & Answers
- Reported - view
Re: Filter
Ok, let's break it down. First, - to find today as a date we use the date() function, to which we can add days using addDays(). Next we need to figure out how to take a date and convert it to an…
- Customer Solutions Architect
- Moshe_Yossef
- 4 days ago
- Questions & Answers
- Reported - view
Re: DistinctCount with filter
Hi @Michael Connelly The approach is to create the measures in the model, and the aggregations in the formulate. I assume [measures].[Impressions Impressions] is defined as a count() in the model,…
- Customer Solutions Architect
- Moshe_Yossef
- 5 days ago
- 1
- Questions & Answers
- Reported - view
Re: End of Month custom column (EOMONTH formula)
@Jashanpreet Sandhu Yes, the CreateDate function isn't granular. Here's What you can do: 1. Add 1 month, and then reduce the number of days in that added month date: Or if you prefer script:…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Truncating decimal numbers in dimensions
@Michael Daun Yes, you will need to convert it to the string. The idea can be adding scale to ToNumber() or formatting number columns in the model (you can already format date fields, by the way).
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Truncating decimal numbers in dimensions
@Michael Daun First of all notice this is an old post - today you can also use custom columns to achieve this - that would work in direct query as well (albeit - I would recommend adding the column…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Alerts that loop through multiple data points
@dgf Seems like what you want to do is maintain one discover that will serve both the dashboard and the publication. The idea is the same - you create a publication with the discover that you have in…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Execution Solve Order Explanation
Hi @Darren Tuffs , Here is the thing: when you have calculations relying one on the other with no solve order applied - Pyramid's query engine has an internal logic for the solve order.…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Congratulations – Level 3 Certified: Jeevitha M - Tigma Tech
Congrats Jeevitha! Reach out if you need anything :-)
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 2
- Member Lounge
- Reported - view
Re: New in 2025.01 Dimension multi Add To - Did you know?
NICE!!
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- 1
- Member Lounge
- Reported - view
Re: Choose which 6 options are available on the popup
@Ricky Melamed That sounds like a feature request.
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Choose which 6 options are available on the popup
@Ricky Melamed Look at the Report meta actions segment in Runtime Settings. You can remove analyze further, lasso, smart insights, conversations, and chat.…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Open Linked Dashboards in a New Slide Instead of a New Tab
Hi @sanjay Adding to Ian's note - you can also add an image that looks like a home to each one of the dashboards, and create an action that will load the original dashboard,…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Dashboard Interactions
hi @Jona Löneke you can right click on the interaction, edit it, and set the interaction as "data interaction". that will allow both tables to filter. however notice this mechanism does not get…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Target Interaction - Background Filters
In Principle, Pyramid does not pass background filters in interactions. A possible solution is to add it to the background filter to the visual itself. If you want to avoid showing it on the columns…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Custom Filter
@sanjay I am a little short in time for a full example, here is the idea in short: 1. Create a present 2. Add the discover that you need and all other filters. 3.…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Custom Filter
First I would look at the calendar filter - it offers many fast selections for weeks, months, etc. Alternatively - you can use formulate to aggregate the desired dates.…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- 2
- Questions & Answers
- Reported - view
Re: In a Data Model, I want to use one column as the description for another
@Michael Raam Nice!
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Hello from a Junior BI Analyst – Eager to Learn & Connect!
Hello @Elango. V Welcome to the community - looking forward to your questions and contributions
- Customer Solutions Architect
- Moshe_Yossef
- 6 mths ago
- 1
- Member Lounge
- Reported - view
Re: 2025 Feature Highlight: Layered Maps
Awesome!
- Customer Solutions Architect
- Moshe_Yossef
- 6 mths ago
- Product Highlights
- Reported - view
Re: Using CustomerID instead of their address to look up location
Hi @Stefano Sena I think what you want to do is add a customer id filter, and an address filter. Then create an interaction between the customer id and the address filter.…
- Customer Solutions Architect
- Moshe_Yossef
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: The unrestricted rights of administrators
@Michael Daun Well, maybe we should take it a step back: Enterprise Admins in Pyramid have full access to everything in Pyramid - that is the only way an admin makes sense.…
- Customer Solutions Architect
- Moshe_Yossef
- 6 mths ago
- 2
- Questions & Answers
- Reported - view
Re: The unrestricted rights of administrators
Hi @Michael Daun I had a discussion on this with a client recently. They had a request that some data will not be exposed even to the Pyramid Enterprise admins.…
- Customer Solutions Architect
- Moshe_Yossef
- 6 mths ago
- Questions & Answers
- Reported - view
Re: How to manage security with migrations between environments?
@Jeanre Van Wyk Notice I was just informed that my initial message may not be accurate - but I think if you can get it to work with the API it's a solid solution.…
- Customer Solutions Architect
- Moshe_Yossef
- 6 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 6

Back to top

Home

View all topics