Distinct Count LAC Workaround

Q&A
,
1

It appears that out of the box Quicksight doesn’t support any type of distinct count level aware calculations.

Does anyone know of any work arounds?

I have a dataset like this:

customer_id event_type event first_period cohort_month vertical
cus_EmwpgeOVwihaBQ feature_usage login 1 2026-02-01 investor
cus_EmwpgeOVwihaBQ feature_usage Viewed Profile 1 2026-02-01 investor
cus_EmwpgeOVwihaBQ feature_usage Printed Report 1 2026-02-01 investor
cus_Eoppet1VxDPwh3 feature_usage Viewed Profile 1 2026-01-01 commercial
cus_Eoppet1VxDPwh3 feature_usage login 1 2026-01-01 commercial
cus_ErToGpAnXzw4OZ purchase_transaction Criteria Bot 1 2025-11-01 commercial
cus_ErToGpAnXzw4OZ feature_usage Viewed Profile 1 2025-11-01 commercial
cus_ErToGpAnXzw4OZ feature_usage Printed Report 1 2025-11-01 commercial
cus_ErToGpAnXzw4OZ feature_usage login 1 2025-11-01 commercial
cus_EsDTFS9eV7YHdX feature_usage login 1 2026-02-01 commercial
cus_Eu60j7sq0Qzgnw feature_usage Viewed Profile 1 2026-01-01 residential
cus_Eu60j7sq0Qzgnw feature_usage login 1 2026-01-01 residential
cus_Eu60j7sq0Qzgnw purchase_transaction Criteria Bot 2 2026-01-01 residential
cus_Eu60j7sq0Qzgnw feature_usage Created List 2 2026-01-01 residential
cus_Eu60j7sq0Qzgnw feature_usage Added to List 3 2026-01-01 residential

What I want to accomplish is to utilize a barchart visual and have it display the percentage of customers that have completed an action AND be able to filter by vertical.

I can probably create a new dataset specifically for this purpose, but I’d love to be able to actually just use quicksight directly rather than having to make new datasets to fill in all the gaps quicksight has in its feature set.

2

Hi @mjproperty,
Have you explored the ‘distinctCountOver’ function as this may be able to assist with your case:

3

@Brett yeah, discountCountOver doesnt work with filters, its exclusively a pre_agg filter per the documentation.

”POST_AGG_FILTER is not a valid level for this operation and will result in an error message.”

Why in the world they would ever design it that way is beyond me lol but its restriction is exactly what I’m trying to solve for.

4

Hi @mjproperty,
Could you share the syntax you’ve tested out so far for your calculated field, so that I can fully understand the fields and logic you’re trying to complete?

5

Hi @mjproperty,

Just checking back in since this thread hasn’t received a response in a while. Were you able to see Brett’s most recent reply or find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!

Thank you!

6

Hi @mjproperty,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you!