Turning Values into Percentages for a Pivot Chart Visual

[RoyceGoodwin]

How can you look at daily percentages of the Yes/No/Null values in the Pivot table on the right side per the daily values? Is there a quick way to reproduce the Chart with Percentages?

[Max]

Can you add a calculated field:

percentOfTotal
(
     {workbox_customer_issue_resolved}, 
     ,[{call_timestamp} ] 
)

Then add this as a value as well.

[RoyceGoodwin]

I copy and pasted what you wrote above and getting Errors found in the Calculated field.
What am I doing wrong? Are the two fields separated by commas?

[Max]

You only need 1 comma.

percentOfTotal
(
{workbox_customer_issue_resolved}
,[{call_timestamp} ]
)

[RoyceGoodwin]

I’ve tried every which way I can and no win… Any other suggestions?

[RoyceGoodwin]

[Max]

Is your field a measure? For instance count({field}) or sum({field})?

percentOfTotal - Amazon QuickSight

[Ramon_Lopez]

Hi-
You would need to do something like this:

percentOfTotal(count({workbox_XYZ_123}),[timestamp])

This do the trick?
Thanks!

[Kellie_Burton]

@RoyceGoodwin -
Did Ramon’s suggestion fix your calculation issue? If so, would you mark this as a Solution. If not, please let us know where you still need help.

[Max]

Hi @RoyceGoodwin

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question

[Max]

@RoyceGoodwin

Since we have not received a response from you on this question, we are going to archive the question. If you still need this question answered, please create a new question topic.