Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to create a Automation Dashboard with task finish time and by task wise. I Created a Piovt Table with my data, but iam unable remove the duplicate date entries in the pivot table, and the source files pulling the data from log files(Operational Monitor Dashboard).
I have attached the final output screen shot and source data. Please help me how to create the dashboard as like my output screen shot.
I have attached a spread sheet (Required Output.xls) in Main description. Please check and do the needful.
The sample data you have provided is for only one month... can you provide few months to test this out?
Hi Sunny, I have attached the updated spread sheet with Jan'17-Jun'17 data in the main description. Please use Required Output.xls for remaining Months Data.
Hi Sunny, Can you please help me, it is urgent. Please help me on % calculation per month wise
I am using below expression but month % is not coming correctly, can any one please check and correct me the expression.
=If(SecondaryDimensionality() = 0, Num(Alt(Count(Aggr(If(Max(Month)<= Month(now()),Max(Month)), [Task Name], Date))/Count(Date), 0), '#.%'),Time(Max([Reload Time])))
I would suggest you to create a new thread as it has been a while and I am not even completely sure where we left of.
Created a new thread.
Checking...