I need to compute the P50, P80 distribution of # of transaction count per consumer over a rolling period of last 3 months, and trend over months. My raw table contains records with following fields transaction_month consumer_id transaction_id I created a calculated field called transaction count…

Hello @Shiyan ! When you say just show consumer here that you mean you want only to show it across the whole field as a total of sorts. To achieve this I believe you would need to either remove the customer_id partition from your first calculated field or remove the customer_id field from your fie…

@Shiyan - Thank you for posting your query. It seems that the fields that you are using to calculate are not part of the visual; hence it is giving that MISSING_REFERENCE error. This is my initial hunch based on the details that you provided. Can you please see if this problems gets resolved when yo…

@sagmukhe Thanks for the reply! I am able to display the chart now. However, my intention is not to compute nor show P50 for every single individual. It is meant to show P50 across the consumers.

Hello @Shiyan - In that case, can you please share a sample dataset and the visual details where you are expecting to see the value. If possible please share the expected outcome as well so that I can try to replicate exactly what you are trying to do. Thanks!

[image] Shiyan: P50, P80 distribution of # of transaction count per consumer over a rolling period of last 3 months, and trend over months I have attached a sample data, and the chart that i expect to get. Thanks! [Screenshot 2023-07-18 at 2.30.51 PM] Sample data

hi @sagmukhe , may i know if you manage to figure out? Thanks.

Sorry @Shiyan - I could not access the Sample Data that you shared as it is giving access denied error. A Sample snapshot with 8 - 10 rows would also work in case that makes sense. [image]

[Sample data] I have put a screenshot here. Thank you!

hi @sagmukhe , may i know if you manage to figure out? Thanks.

Hello @Shiyan ! For now I am going to mark my comment above as the solution, but if you still need help with this problem please feel free to repost in the community. You can link to this topic.

Window Sum over aggregation, and Percentile aggregation after

Q&A

Shiyan July 18, 2023, 6:35am 5

I have attached a sample data, and the chart that i expect to get. Thanks!

Sample data

Topic		Replies	Views
Can i use Level-aware aggregation with a windowCount function? Q&A quick-sight , calculations	6	510	October 23, 2024
Store value of calculated field as a Number Q&A developer , error , quick-sight	6	61	October 24, 2024
How to create a percentage difference calculated field from an aggregate calculated field? Q&A formulas , period-over-period , quick-sight , calculations , Business-Intelligence-Engineer	5	736	February 27, 2024
Percentof Total with distinct count Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	416	November 29, 2023
Bar chart to show Percent Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	2	39	February 25, 2025

Window Sum over aggregation, and Percentile aggregation after

Related topics