User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Latest Posts
Re: After focusing on a member in a Discovery, how do you unfocus?
Thanks for the reply Ian. I like the fact that we can right click and focus on an item. I wish it would display somewhere on the screen that there is a background filter.…
Robert Clark
Top Contributor
Robert_Clark
2 mths ago
1
Q&A
Reported - view
Re: After focusing on a member in a Discovery, how do you unfocus?
Here are some more details. If they focus on an item and then remove the background chip the Discovery continues to focus on that member and we aren't able to unfocus.…
Robert Clark
Top Contributor
Robert_Clark
2 mths ago
Q&A
Reported - view
0
After focusing on a member in a Discovery, how do you unfocus?
Hello, We have had a couple of occasions where users have focused on something and saved the report. How do I turn off the focus so it goes back to it's original state? Thanks, Rob Clark
Robert Clark
Top Contributor
Robert_Clark
2 mths ago
4
replies
38
Q&A
Answered
Answered
Re: How to reset running total by a dimension value
Thank you so much @Ian Macdonald !!
Robert Clark
Top Contributor
Robert_Clark
2 mths ago
Q&A
Accepted
Reported - view
0
How to reset running total by a dimension value
We want to create a running total over time for each state and we want it to reset for each state. If I create a running total quick calc off of an existing measure it totals across all states.…
Robert Clark
Top Contributor
Robert_Clark
2 mths ago
3
replies
31
Q&A
Answered
Answered
Re: Find Difference between two dates
Hi Richard, I know that we can do both measures and dimensions of of a single data model attribute. However, I’m wanting to calculate the age using a date difference between today and their…
Robert Clark
Top Contributor
Robert_Clark
5 mths ago
Q&A
Reported - view
Re: Find Difference between two dates
This is great information on identifying a date difference. Is there anyway to see the date difference as a dimension? We are calculating the age of automobile drivers and want to see it as a…
Robert Clark
Top Contributor
Robert_Clark
6 mths ago
Q&A
Reported - view
Re: Is there a way to move a CMS repository to different database vendor?
Thank you Devon! This is very helpful!
Robert Clark
Top Contributor
Robert_Clark
6 mths ago
Q&A
Reported - view
0
Is there a way to move a CMS repository to different database vendor?
Hello, We want to move the CMS repository to a different database. We have them in Postgres and want to move them to SQL Server. Is there a way to port from one database to the other? Thanks,…
Robert Clark
Top Contributor
Robert_Clark
updated
7 mths ago
4
replies
29
Q&A
Answered
Answered
1
Display "all" in dynamic text when user selects all options in multiselect dropdown
We have a multiselect dropdown slicer that has a lot of values and when a user clicks the All button in the dropdown it is populating the dynamic text with all the options.…
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
1
reply
20
1
Q&A
Answered
Answered
Re: How to create a loss triangle in Pyramid Analytics
Our model is direct querying Snowflake so maybe that's part of why I needed to do it.
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
Q&A
Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Ian, I worked with @Jason Picker and we figured out how to do it. We added an if statement so that it would not calculate a value if measure was null. Here's a screen shot. Thanks, Rob Clark
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
Q&A
Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Ian, Thank you for the response. If I just put in the measure, without the formula, this is what I get. Which looks correct. There are no values in those other periods.
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
Q&A
Reported - view
Re: How to create a loss triangle in Pyramid Analytics
Hi Ian, This is all great stuff! I do have an issue though. I am getting values for development periods that are in the future. Here's an example. I checked my formula and it exactly matches yours.…
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
Q&A
Reported - view
1
Display weather on map with data points
Hello, We are trying to identify if there is a way to map customers address on a weather map to identify who would be affected by a storm. Do you have some ideas on how this might be accomplished.…
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
1
reply
29
1
Q&A
Answered
Answered
Re: How to create a loss triangle in Pyramid Analytics
Thank you Ian! This is exactly what I needed. I couldn't figure out how to get it to sum properly, but now I know the trick.
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
Q&A
Reported - view
6
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
11
replies
165
6
Q&A
Answered
Answered
0
Authenticating with ADS when Pyramid Analytics hosted on AWS
Hello, Does anyone have tips on setting up Active Directory Services (ADS) authentication in Pyramid Analytics running on AWS. ADS is running on local network and Pyramid Analytics is running on AWS.…
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
1
reply
12
Q&A
Answered
Answered
1
What are the best practices with the new migration capability?
Hello, We are trying to use the migration utility to promote content from development to production. However, we are getting duplicate content suffixed with a number e.g.…
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
1
reply
52
1
Q&A
Answered
Answered
2
Multi-factor Authentication
Is there a way to enable multi-factor authentication (MFA)? If not directly through Pyramid, is there third party tools to provide something like this?…
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
4
replies
42
2
Q&A
Answered
Answered
Re: Can you change filter conditions in discoveries be OR rather than AND?
@avi perez thank you that’s what we ended up doing. I was just wondering if there was an easier way built in.
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
Q&A
Reported - view
0
Can you change filter conditions in discoveries be OR rather than AND?
We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero. So the condition would look like this: Measure A !…
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
3
replies
47
Q&A
Answered
Answered
0
Is there a way to change date formats in a model?
We are located in the US and would like to change the date formats to a format that our users are used to, such as mm/dd/yyyy. I don't see a way in the model to set the date format displayed.…
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
1
reply
35
Q&A
Answered
Answered
0
In Explore Further is there any easy way to filter out records with $0 measures?
We have users using explore further and add a measure but have no way, that we can see, to easily filter out the records with 0 as the measure value. Is there a way for them to do this?
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
1
reply
19
Q&A
Answered
Answered
1
Best practice for embedding Pyramid presentation into Salesforce
We want to embed graphs and presentations into Salesforce. What is the recommended approach for doing this?
Robert Clark
Top Contributor
Robert_Clark
2 yrs ago
1
reply
28
1
Q&A
Answered
Answered
1
2
Next
Top Contributor
Robert Clark
Robert_Clark
57
92
0
Joined: 16 May 2019
Follow
Cloverleaf Analytics
United States
Home
Q&A
Best Practices
Learning Live Archive
Learning Live Topic Suggestions
Tips & Tricks
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help