Expression to show 7 days forward - forecasting

[#1]

Howdy. Trying to display the rolling 7 days (future) of data to show up and coming work to be realized. How would I write and expression to dynamically show future 7 days based off my established 'Target Date of Completion'

=Count ({<Status={'New', 'In Progress'}, [Target Completion Date]={"<=$(=DATE(MAX(DATE)))>=$(=DATE(MAX(DATE)+7))"} , Account -={'Sage Atlanta CBC'}, Type = {'Trial', 'Pre-production'}, [Account Sales Office] = {'Atlanta CBC'}>}[Success Plan: ID])

[sunny_talwar]

The date set analysis looks good to me, it isn't working?

[#3]

Hi Sunny, it’s not working. No matter what I set the days to (e.g. +10, +20, etc…) I’m getting zero as a return when I have upcoming work to realize.

[sunny_talwar]

Would you be able to share a sample to look at?

[#5]

On the 'Copy of Copy of Activity' tab.

The number should be 4.. Over the next 7 days, I have 4 accounts converting based on the 'Target Completion Date'

[sunny_talwar · Accepted solution]

Can you check this expression:

=Count ({<Status={'New', 'In Progress'}, [Target Completion Date]={"$(='>=' & Date(Today()) & '<=' & Date(Today()+7))"} ,Account -={'Sage Atlanta CBC'}, Type = {'Trial', 'Pre-production'}, [Account Sales Office] = {'Atlanta CBC'}>}[Success Plan: ID])

[#7]

very strange...I copied your code, and still get 0 returned results. . Still troubleshooting

[sunny_talwar]

Did you open the QVW and check if you see the right number?

[Anonymous]

i have emp_id, date, HOURS field! but i want to show hours of per empid in per date! how to do? if i group by the emp_id means it will show the all the data, but i want to single date?

[Heena]

Hi ,

 I have data as below.

RN_EXECUTION_DATE	count(RN_RUN_ID)
2018-06-30	18
2018-07-01	24
2018-07-02	55
2018-07-03	101
2018-07-04	79
2018-07-05	93
2018-07-06	83
2018-07-07	2
2018-07-08	4
2018-07-09	5
2018-07-10	20
2018-07-11	8
2018-07-12	11
2018-07-13	15
2018-07-15	176

I need to forecast for next 5 days - count(RN_RUN_ID), i have added days though in the script.

Date(RN_EXECUTION_DATE + 5) as RN_EXECUTION_DATE_Forecast.

but its not working.

measure: count(RN_RUN_ID).

Thanks in Advance!