Ying Dong's Profile - Pyramid Analytics Community Forum

Badges

Company

Strata Health

Country

Latest Posts

Re: How to: Create a dynamic set of dates
@Moshe Yossef Yes, there have first_referral_date in referrals table. For example, the user pick date range Oct 1, 2024- Oct 8, 2024, my goal is count the referral numbers which first_referral_date…
- Ying_Dong
- 2 mths ago
- Discover
- Reported - view
Re: How to: Create a dynamic set of dates
@Moshe Yossef I want it the first date in the range.
- Ying_Dong
- 2 mths ago
- Discover
- Reported - view
Re: How to: Create a dynamic set of dates
@Moshe Yossef , this is really helpful. Just further this method, can we change today or max date to any date, like the user can pick any date from date slicer, and provide the last 10 days data?…
- Ying_Dong
- 2 mths ago
- Discover
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ian Macdonald Thank you so much Ian, that is help
- Ying_Dong
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ian Macdonald Thanks Ian, I do set geospatial defaults to Canada and specific State too, it works for street address, but not postal code in my case, here is my screenshot.
Attachments
- Ying_Dong
- 7 mths ago
- Questions & Answers
- Reported - view
Pyramid Geospatial for Postal Code

I am working on bubble map chart in Pyramid (2023.10) to show our clients number in a map using street address or postal code (default country is Canada),…
- Ying_Dong
- 7 mths ago
- 6replies
- 36
- Questions & Answers
- Answered
- Answered
Re: Pyramid 2018 Geospatial Shapes summary
How is Canada detail?
- Ying_Dong
- 7 mths ago
- Tech Blogs & Webinars
- Reported - view
Re: How to calculate 90 percentile based on category
@David Gordon Thanks David, this works
- Ying_Dong
- 8 mths ago
- 2
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
@imbar that is correct, the problem I met is the value calculated from percentile directly (from Postgres) and using calculation with stdev*1.2+median are the different after using category column.
- Ying_Dong
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
@imbar Thanks Imbar. stdev(measure)*1.2+ median(measure) should work, but the value does not the same when I use percentile (0.9) in Postgres, which is so confuse.
- Ying_Dong
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
@Christian Langmayr Thanks, yes there has some customer data, need to remove the column A
- Ying_Dong
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
@Obee1 forgot to mention, I am using Pyramid
- Ying_Dong
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to calculate 90 percentile based on category
Thanks@Obee1 for replay, I attached the sample dataset and the result I want using the query, it is 90 percentile of the values at the row level, the same as result of average and median.
- Ying_Dong
- 8 mths ago
- Questions & Answers
- Reported - view
How to calculate 90 percentile based on category

I need to calculate 90 percentile in one of my discovery (there is no option in model). Since there is no direct way to have 90 percentile, instead I am trying using standard deviation (1.…
- Ying_Dong
- 8 mths ago
- 11replies
- 106
- Questions & Answers
- Answered
- Answered
Question on - How to print a Publication from a Dashboard

Thanks for this video, it works great but not for calendar slicer for me when I pick date range, any suggestions?…
- Ying_Dong
- 9 mths ago
- 1reply
- 54
- Questions & Answers
- Answered
- Answered
Re: Chart Top 5 Along with an Aggregate of the Others
@samuel alma Yes it works now
- Ying_Dong
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Chart Top 5 Along with an Aggregate of the Others
@samuel alma Tried this and works great for grid and bar chart, I started as grid and split Horizontal, then I changed one of them to bar chart and works automatically, but not for pie chart.…
- Ying_Dong
- 1 yr ago
- 1
- Questions & Answers
- Reported - view

Welcome to the Pyramid User Community

Pyramid User Community

Ying Dong

Re: How to: Create a dynamic set of dates

Re: How to: Create a dynamic set of dates

Re: How to: Create a dynamic set of dates

Re: Pyramid Geospatial for Postal Code

Re: Pyramid Geospatial for Postal Code

Pyramid Geospatial for Postal Code

Re: Pyramid 2018 Geospatial Shapes summary

Re: How to calculate 90 percentile based on category

Re: How to calculate 90 percentile based on category

Re: How to calculate 90 percentile based on category

Re: How to calculate 90 percentile based on category

Re: How to calculate 90 percentile based on category

Re: How to calculate 90 percentile based on category

How to calculate 90 percentile based on category

Question on - How to print a Publication from a Dashboard

Re: Chart Top 5 Along with an Aggregate of the Others

Re: Chart Top 5 Along with an Aggregate of the Others

Home