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?

[Chanty4u]

hi,

Count or Count distinct?

= count(DISTINCT aggr(count( email),submtdate))

count( {<Column name={'Name'}>}Distinct Documnent2)

• Re: calculation distinct

[sunny_talwar]

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

          ..

FROM Source

[amayuresh]

Please post your sample Data.

Do you have time in Date field ?

[Anonymous]

may be this?

In Dimension Tab - > Update your Date Dimension with this -> Date(DateField)

[sunny_talwar]

Balraj that won't change a thing. You can do this instead -> Date(Floor(DateField)) to get rid of time portion

[Anonymous]

Is floor() really required??

In some cases I extract date from Date/Time field using same

[sunny_talwar]

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.

[Kushal_Chawda]

try to do it in script like below

EmailCount:

load distinct SubmitDate,

                   SubmitDate as SubmitDateNew

                  Count(distinct Email) as EmailCount

resident your Data

group by SubmitDate;

Now Create the Chart,

Dimension:

SubmitDateNew

Expression:

Sum(EmailCount)

[Digvijay_Singh]

Good one