Forum Discussion

New Member

9 years ago

Solved

Struggling with DATEDIFF

Hi, this is my first post and my first report where I am trying dynamic date/time measures and visuals, not much success so far but almost certainly down to user error. I am trying to find the di...

AndyAtDukes
9 years ago
Matt,

Actually I have found another solution to this, I created a column that works out the difference in days between TODAY() and the quotation date. I can then use this to filter any metric on any number of days.

Thanks

Andy

Icon for Community Champion rank

Community Champion

9 years ago

It is hard to follow your post. What are you actually trying to do?

New Member

9 years ago

Hi Matt, thanks for your reply.

I have a data set of quotations created by our sales team, I am trying to build a quote performance report which will show;

Last 30, 90 & 180 days rolling number of quotes, value of quotes, conversion ratio etc with year/year comparison.

In addition I have a calendar table with sequential dates, months, years etc

I was trying to create the IsMonth column in order to then be able to filter by this to get that 30 days rolling data.

Hope that makes some sense,

Andy