Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
In below filter it is showing multiple same dates. I want display the only single date in the chart.6/8/2022 is repeated 4 times but want show single.
Thanks
Rajneesh
in your script, use date(floor(datefield)) as datefield.
Regards,
Prashant Sangle
your dates are in fact timestamps that just have been formatted to not show the time part.
You could load the date field e.g. like:
LOAD DayName(date) as date
FROM ...