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)
Hello, Please take a look at the following thread. https://365datascience.com/question/tableau-number-of-records/ Thanks!