12 Replies Latest reply: May 25, 2015 3:03 AM by Yun Zheng Soh RSS

    How do I prevent data fields from being combined?



      I have this data set where I have several entries containing the date in the DD/MM/YYYY format. Since I don't want it to be displayed that way, I used


      MonthName("Date") as Date


      in the data load editor to load the data. There are supposed to be 11 data points in that data set.


      However, when I do that I lose 1 data point! There are two rows in my excel file that are exactly the same bar one field, and those 2 got combined. I do not want that to happen, so what do I have to do?


      I know that they got combined in some way because when I applied the Count(Date) to a certain visualisation that I had, it gave me a value of 10 instead of 11.