date duplicated at bar charts

[murti]

Hello, 

I tried to count the leads which created at the last 30 days all the lead id s have a date which refers the creation of leads. To make it more accurate

I created the master calendar and I connected it with my table by created_at however as the output I get multiple copies of each date from the last 30days or earlier it doesnt matter. How am i gonna resolve the problem? AS THE LENGTH OF THE BARS I USED THIS : =Count({<created_at = {"$(='>=' & Date(Today()-30, 'MM/DD/YYYY'))"}>} lead_id)

for the dimension I used only created_at field Help is appreciated.

[Lech_Miszkiewicz · Accepted solution]

Your date field in fact table i assume is created_at and it still has timestamp in it, so when loading fact table you also need to do 

Date(floor(your date)) as created_at

cheers