Hi All
Can anybody help me understand why the % amounts in the caseid% columns pictured are not correct for the caseid columns (ie 3 of 30 should be 10%, etc.) ? Both columns are Values, with the caseid% being set to ‘Percentage of Total’ with the calculation ‘Table down’.
Thanks!
Hi @hopeah,
Is your ‘caseid%’ field a calculated field or did you just add caseid a second time and do a table calculation?
If it’s a calculated field, could you please share?
Also, is it possible for your ‘caseid’ field to have decimals?
Hi @Brett, the caseid% is a duplicate of the caseid field, with the table calculation.
I should have specified that the caseid field has a count distinct aggregation. I’ve used the calculation distinct_count(caseid)/sumOver(distinct_count(caseid),[]) in tables where I’ve wanted to identify the % value of the overall total, but in this instance I can’t see a way to do the equivalent for a ‘table down’ calculation.
Hi @hopeah,
Apologies for missing your last response. My thoughts are that the count distinct is what’s throwing this off. Have you tried creating a calculated field to create the distinct count, that may create more firm numbers that will run percentages more accurately.
If you were able to find a different work around in the time since, feel free to share what worked for your scenario!
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @hopeah,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!
