Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a Dashboard with Monthly % calculation by task, By monthwise and Yearwise based on Task Completion Time. I Created a Piovt Table with my data, but the % values are not coming correctly.
Here iam attaching the datewise date, based upon data we need to calculate the Monthwise reload completion % and yearwise reload completion % Value.
Please help me how to calculate the % calculation by Monthly and yearly for each task.
Not sure I understand?
Please check below screen shot. I don't show each Task 1 data as a separate row. I need to merge all Task 1 data in one row.
Best way to handle this would be to cleanse your data in the script using ApplyMap
HI Sunny,
I have applied the same expression in my data, But % values are not coming exactly for some task due to the SLA timing is considering properly. I have attached my actual data with task name, please refer Actual Data.xlxs and do the needful.
iam using below expression for my tasks, but it is considering the SLA timings
=Num(Alt(Count(Aggr(If(([Reload Time])<=
Pick(Num(KeepChar([Task Name], '01234566789')), MakeTime(5), MakeTime(5), MakeTime(5,15), MakeTime(5,30)),
([Reload Time])), [Task Name], Date))/Count({<[Reload Time] -= {'-'}>}Date), 0), '#.%')
Can you load the data into a qvw file and show me the incorrect numbers please?
Please check below screen shot, most of the Task % is showing as 0%.
screenshot? How will I check the expression in screenshot?
I used same expression, but i changed only Make time fields based upon the task names.
=Num(Alt(Count(Aggr(If(Max([Task Completion Time])<=
Pick(Num(KeepChar([Task Name], '0123456789')), MakeTime(5), MakeTime(5),MakeTime(5, 15),MakeTime(5, 30)),
Max([Task Completion Time])), [Task Name], Date))/Count({<[Task Completion Time] -= {'-'}>}Date), 0), '#.%')
Your task names changed from Task_1 to something else... you will need a mapping or something else to check which MakeTime() belongs to which task