Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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)
Hi Sunny T. This solution fixed the problem. Thanks a lot and have a nice day.