Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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