Display user for all possible dates

[Anonymous]

Hi All,

I have data as in table1 and want to display user across each date(as table 2).

eg.: 'a' is present at two different time stamps on 10/10/2017. But I need to display only once across 10/10/2017

Please let me know how this can be possible at script end and in chart expressions.

[Anil_Babu_Samineni]

Use DISTINCT after Load statement like

Load DISTINCT F1, F2, .....

[tresesco]

Create a Date field in the script using floor() like:

Load

          user,

          Date(Floor(date)) as NewDate

Now if you take this user and NewDate in the table box, it should give your expected output.

[Anonymous]

Got null values in date column

[tresesco · Accepted solution]

That could be if your date field is not really a date but string. Try using parsing function date#(), like :

Load

          user,

          Date(Floor(date#(date,'DD/MM/YYYY hh:mm:ss'))) as NewDate

Note: Check the date format and change if required.

[Anonymous]

Thanks. it worked