KPIs formula (Average Discount %)
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Tableau - Adding KPIs to the Tableau Dashboard
Can you clarify why we divide by "SUM (gross sales)" in the first formula ? Because as I know, the average is the sum of the terms divide by the number of terms
For example, the average of (2, 3, 3, 5, 7, 10) = 30 divided by 6, which is 5
shouldn't we use COUNT instead of SUM ?
Thanks.
0 answers ( 0 marked as helpful)