I have a line chart with Date as dimension and count Email address as expression.
The problem is that the chart shows all dates, instead of aggregating per date.
How can I show only unique values as dimension?
I think your date field might look like a date field, but may contain time information making it to repeat in the chart. I suggest fixing this within your script. You can do something like this:
LOAD SubmitDate as SubmitTimeStamp,
Date(Floor(SubmitDate)) as SubmidDate
If you have a timestamp field and the goal is to extract just the date portion, I am almost certain that you cannot do it without using Floor function. Because without floor the date will look like a date, but it will still contain the decimals representing time portion.
try to do it in script like below
load distinct SubmitDate,
SubmitDate as SubmitDateNew
Count(distinct Email) as EmailCount
resident your Data
group by SubmitDate;
Now Create the Chart,