3 Replies Latest reply on Aug 10, 2017 3:50 AM by Zhouyi Zhang

# To get the total count of field per day

Hi Everyone,

I am having an issue in getting the total count of a field..

I have attached the particular workbook please go through the below link:

Tableau Public

I have two fields in the column bar : Day and Status of Transaction

and i have a field in the row that is count of total number of transaction.

So the result is coming as total count of transaction per day per status but i need to calculate the percentage of the transaction per status per day.

• ###### 1. Re: To get the total count of field per day

Hi, Superan Verma

below is a sample result.

Hope this could help

ZZ

• ###### 2. Re: To get the total count of field per day

Hi Zhang,

Can you please let me know the exact formula you used for the sum(%) measure.

• ###### 3. Re: To get the total count of field per day

Hi, Superan

If you open my attached workbook, you will find the below formula I use to calculate the %