How to estimate crude rates with distinct_count

Question & Answer
, , ,
1

–Read and delete–
If your question is about data calculation/presentation, we encourage you to create a sample dashboard in Arena and include it with your question. This makes it easier for other users to try solving your problem and highly improves your chances of getting a solution quickly.
Read more about Arena here: QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community
(Copy / right click link in preview on a PC --or-- highlight / control / click link on a Mac and open in new tab.)
–
Hi, I am trying to create a calculated field for estimating crude rate per 10000 using the dist_count. For example, dist_count*10000/total population. I would like to use it with several variables (gender, race etc.) in visuals. How do I do that? Thanks,

2

Hi Mpat,

Thank you for your question.
Can you explain more on “I would like to use it with several variables (gender, race etc.) in visuals”?

3

I want to create visuals using this crude birth rate and add race or gender in the field well. I am trying this syntax but getting errors.
distinctCountOver(births, [race],PRE_AGG)*10000/sumOver({Population_nodup},[births],PRE_FILTER)
Error message: LAC agg functions cannot be used as operands of LAC window functions.

4

I am still waiting for your response, thanks.

5

Not yet, I am still waiting for your response…