Forum Discussion

New Member

3 years ago

Measure Trouble with Percent Total

Hi all, I’m been struggling with this and would be ridiculously appreciative for any guidance. I have a table RequestMetrics with Column METER_NAME. METER_NAME has the format $REQUESTNAME_$SUCC...

Anonymous

Not applicable

3 years ago

I think your calculation is based on your data model. Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

whoopsy
New Member
3 years ago
Rico,

Thank you so much for your reply.

Here is the ultimate result I'm shooting for - only achieved here by cheating. I want to take the difference between the filtered rate (FILTERED MEASURE COUNT BY NAME/FILTERED MEASURE COUNT BY BASE) to an overall historical rate (HISTORICAL COUNT BY NAME/HISTORICAL COUNT BY BASE) to flag failures/success that differ greatly from the baseline historical rate.

Here are the sample RequestMetric with related tables RequestLookup and RequestBaseLookup. Thanks again as I'm hard stuck at the moment.

RequestMetric
https://docs.google.com/spreadsheets/d/1uKi5GOUrpbYxWB3tmsp_t2KipFSe95tz/edit?usp=share_link&ouid=110011765506534734973&rtpof=true&sd=true

RequestLookup
https://docs.google.com/spreadsheets/d/1UDfj5Ql-8XthYdmiHuxUwdmz81Ajv70e/edit?usp=share_link&ouid=110011765506534734973&rtpof=true&sd=true

RequestBaseLookup
https://docs.google.com/spreadsheets/d/1q98Gg3QIi5l9-VvLe6YBxl0FMjlRbhEc/edit?usp=share_link&ouid=110011765506534734973&rtpof=true&sd=true

- Dan