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

    How do I prevent data fields from being combined?

      Hi,

       

      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.