Multiple Transaction Dates

[evansabres]

Hello -

I have a data set of transactional data, containing sale dates, item types, sales totals, etc. The problem I am running into is for many dates, there are multiple transactions and what I want to do is show a chart that has the date as the dimension and total sales as the expression (or similar) but only show one iteration of each date.

For example, if on January 15th, 2016 there were 19 transactions, I just want to show 1/15/2016 once on the chart.

is this possible?

Thank you.

[sunny_talwar · Accepted solution]

I think your date might look like a date field, but may actually be a timestamp field. You can fix this in the script or you can change it in the chart.

For Script:

Date(Floor(DateField)) as DateField

For Chart use a calculated dimension

Date(Floor(DateField))

[swuehl]

Just use your date field as dimension and

=Sum(Sales)

as expression. If you still see multiple entries for 1/15/2016, I assume your dates are in fact timestamps.

Then either create a date field in the script, or use a calculated dimension

=Date(Floor( [Sales Date]))