Hello, I am stuck in the lesson Tesla – “Creating Custom fields”.
In my Tableau Desktop v.020.20.0415.1946 64-bit, when I generate the data, the field “Number of records” is not automatically generated, as it is shown on videos. On the other hand, I get another field which is not shown on the videos, called “Data (Count)”. Unfortunately, the latter cannot be used the same way as you use the Number of records in the next videos.
Could you please provide some instructions on how to create the measure “Number of records”, or on how to force Tableau to automatically generate this field.
N.B. To avoid any further mismatch problems like this, it would be nice to have the latest Tableau version used in your videos.
Thank you very much for your assistance.
Hello,
I had the same issue this morning because I also have the latest version of Tableau so I checked online. So the Data (count) seems to be the same as the “number of records” but is a non-aggregate argument unlike the number of records. In the calculation field you would have to add “{fixed: ” as a prefix to the data (count). Please note that you have to drag and drop the data (count) into the opened dialog box so that you would get the function for the data (count) 《I think it is something like Count ([data]) I am not really sure》.
So it should look like this:
[Price]*{fixed: Count ([data])}
**Please note that I am not sure of the proper arrangement of the function for data (count).
Also in the end you may not need to use it because it looks like the latest version of Tableau already did the multiplication as the value of price ie. calculated the revenue as price.
So if you drag and drop your price into the sheet, you will notice that the figures are the same as the revenue in the video.
The reason why the fixed prefix is added is so that Tableau can read it as an aggregate argument because it is the result of the count function. Just like how count in excel is seen as ‘general’ not ‘numerical’, I think that’s what’s happened there.
I am also having the same issue. They need to get this sorted
Hi, am having the same issue right now. I’ve tried to manipulate the data, but couldn’t generate the “number of records”
Oh, I think its best to download the lesson 7 tableau file and do the calculations in there. that solves the problem ultimately.
How do you do that?
Hi, only add a calculation field, name Number of Records, in formula space just harcode the value 1