please help on below requirement?

[daisy1438]

Hi

I need help for the below requirement.I attached one sample  Excel data above.

-------------------------------------------------------

Fields in my table are

table A:

Issue_ID Issue_status Date_Upload Tareget_date Action_ID Action_status

--------------------------------------------------------------------------------------------------------

Requirement 1:

count the ID's for newly opened status.

In the above table i have issue_status and date_upload fields.

->KPI chart by default in the date_upload field we need to compare maximum_date and maximum previous date.if maximum previous date status is draft and maximum date status is open then count the issue_id's.

->On the same KPI chart if the user selects any two dates compare those two dates(ex:the dates are 01-01-2018 to 10-01-2018.if the user selects 02-01-2018 and 06-01-2018 in these date 02-01-2018 is minimum and 06-01-208 is maximum. we need to compare those two dates no need to compare between dates)if minimum date satus is draft and maximum date status is open then count the issue_id's.

example:

01-01-2018                    

02-01-2018                      

03-01-2018                 

04-01-2018

05-01-2018

06-01-2018

max date= 06-01-2018

max previous date=05-01-2018

if user selects dates 02-01-2018 and 05-01-2018 then 02-01-2018 is minimum and 05-01-2018 is maximum.

---------------------------------------------------------------------------------------------------------------------------------

Requirement 2:

count the ID's for  closed status.

same as requirement 1 but maximum previous date status is open and maximum date status is closed then count the issue_id's.

-------------------------------------------------------------------------------------------------------------------------------------

Requirement 3:

target date changed count the ID's.

In the above table i have Taget_date and date_upload fields.

->KPI chart by default in the date_upload field we need to compare maximum_date and maximum previous date.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.

->On the same KPI chart if the user selects any two dates compare those two dates.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.

Example:

Issue_ID      Date_upload      Target_date

01                01-01-2018           10-05-2018

01                03-01-2018           15-05-2018

02                01-01-2018           10-05-2018

02                03-01-2018           10-05-2018

03                01-01-2018           10-05-2018

03                03-01-2018           16-05-2018

In the above table if we select dates in the date upload field i.e., 01-01-2018 and 03-03-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.

I need quires for the above requirements in the back-end level.

i have written quires in the front end level but the performance is slow and it is showing an error in the chart i.e., time out.

Thanking you.

[bwisealiahmad]

Hi,

There are a lot of great people here trying to help out and more than willing to, but you are basically asking someone to do everything for you instead of asking for help to solve something you've tried to do.

Best,

Ali A

[daisy1438]

Hi Ali ,

if have any idea below requirement please help.

I have table with fields ID and date and region and risks.

Some Id s not available in previous date and some id are available in current date.

using above date field divided into previous date and current date .

I have inline table

load * inline

risksselection,

newly links risks

de-linked risks

1)when user select newly linked risks(get field selection(risks=newly links risks)and  previous date and current date count the Id what are the id not available in previous date and available in current date

2)same way user select previous date and current date what are the Id s available  in previous date and not available in current date than count the ids.(de linked risks)

I am writing the below expression.

if(GetFieldSelections([Risks]) = ' Newly linked to Risks',

count(distinct{<[Date as at] = Date_as_at_Current,

ID = e({$<[Date as at] = Date_as_at_previous>}Id)>} ID))

I am not get exact value. Please tell me how to do this requirement.  

Ex:we have 4 months dates jan to apr.

if user select  previous date 10-feb-18  and  current date 23-apr-18 than count the id s.

compare only 10 feb and 23 apr .not in between dates.if user not select any dates showing the entire Id s.