Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Simple one I'm sure.
I have a table with Date, Issue ID and Issue Category. All i want to do it create a simple table showing the number of issues by issue category but need it for the current week only and last week. My week needs to start on a sunday.
Thanks
Kev
This week: 5/8 - 5/10
{<Date = {"$(='>=' & Date(WeekStart(Today(), 0, 6)) & '<=' & Date(Today()))"}>}
Last Week: 5/1 - 5/7
{<Date = {"$(='>=' & Date(WeekStart(Today(), -1, 6)) & '<=' & Date(WeekEnd(Today(), -1, 6)))"}>}
May be add this as set analysis to your expression:
{<Date = {"$(='>=' & Date(WeekStart(Today(), -1, 6)) & '<=' & Date(Today()))"}>}
Sorry, I meant a calculation for this week and another for last week
try expression like
// for current week
count({<Date={">(=weekstart(Today(),0,-1))"}>} [Issue ID])
//for last week
count({<Date={">(=weekstart(Today(),-1,-1))"}>} [Issue ID])
This week: 5/8 - 5/10
{<Date = {"$(='>=' & Date(WeekStart(Today(), 0, 6)) & '<=' & Date(Today()))"}>}
Last Week: 5/1 - 5/7
{<Date = {"$(='>=' & Date(WeekStart(Today(), -1, 6)) & '<=' & Date(WeekEnd(Today(), -1, 6)))"}>}