Last answered:

15 Jun 2020

Posted on:

14 Jun 2020

0

Creating a Custom Field and Adding Calculations to a Table

Hi! I just started to watch the course video under Tableau part. I found out that I did not have the auto generated 'number of records' measurement, thus making it impossible for me to calculate a new field 'revenue' which need to multiple the 'number of records' and 'price'. I tried to multiple 'price' by 'Data(Count)' which I believe is the most similar measurement I could find in my tableau interface. However, [Price]*COUNT([Data]) shows a error of 'Cannot mix aggregate and non-aggregate arguments with this function.  Hope my description is clear. Thank you and look forward to your reply!  Best, Wenhao
1 answers ( 0 marked as helpful)
Instructor
Posted on:

15 Jun 2020

0
Hello, Please take a look at the following thread. https://365datascience.com/question/tableau-number-of-records/ Thanks!

Submit an answer