Chart with unique values on Dimension

[#1]

Hello,

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?

[Anonymous]

The DayName() and DayStart() functions also remove / zero the time decimals.

But I still prefer using the Floor() function as it is far easier to see what is happening in the script from a quick eyeball.

[brijesh1991]

Add a new field in your script:

Load *,

Date(MakeDate(Year(SubmitDate),Month(SubmitDate),Day(SubmitDate)),'DD/MM/YYYY') as SubmitDateNew

From Table

Use this new field in your chart dimention.
Expression: Count(Distinct Email)

[#4]

Hi Sunny T. This solution fixed the problem. Thanks a lot and have a nice day.