Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have tickets raising daily to particular group with opendate time , Now the user is asking me to show the no of incidents raised for the particular date and hour(drill down/cyclic) , how can i show? i want to show in calender object also how?
below is the sample data
Load *inline
[
Group, NO, Opendate, Closed date
abc,12,12-02-2016-5pm,12-02-2016 7pm
abcq,122,12-02-2016-6pm,13-02-2016 pm
abcq,121,12-02-2016-7pm,13-02-2016 7pm
abca,124,12-02-2016-8pm,13-02-2016 7pm
abcs,123,12-02-2016-9pm,13-02-20161pm
abce,1321,12-02-2016-10pm,13-02-2016 4pm
abc3,132,12-02-2016-11pm,13-02-2016 7pm
abc4,112,12-02-2016-12pm,13-02-201647pm
ab4c,1222,12-02-2016-2pm,13-02-2016 3pm
ab5c,1122,12-02-2016-3pm,13-02-2016 7pm
ab3c,1232,12-02-2016-1pm,13-02-2016 7pm
ab2c,1432,12-02-2016-2pm,13-02-2016 7pm
ab6c,1452,12-02-2016-4pm,13-02-2016 7pm
];
I want to show the incidents opened date and time in drill down/cyclic , in chart , how to do?
May be use Cyclic with the dimensions are [opened date] and SubField([opened date],'-', -1) and then use metric like Sum(Measure)
Hello Sailaja,
Trust that you are doing well!
Considering given requirement, I have drafted below script (please review and modify it, if required):
Data:
LOAD *,
Date(Date#(Left(Opendate, 10),'DD-MM-YYYY')) AS Date,
SubField(Opendate, '-', 4) AS Time
;
LOAD * INLINE
[
Group, NO, Opendate, Closed date
abc,12,12-02-2016-5pm,12-02-2016 7pm
abcq,122,12-02-2016-6pm,13-02-2016 pm
abcq,121,12-02-2016-7pm,13-02-2016 7pm
abca,124,12-02-2016-8pm,13-02-2016 7pm
abcs,123,12-02-2016-9pm,13-02-20161pm
abce,1321,12-02-2016-10pm,13-02-2016 4pm
abc3,132,12-02-2016-11pm,13-02-2016 7pm
abc4,112,12-02-2016-12pm,13-02-201647pm
ab4c,1222,12-02-2016-2pm,13-02-2016 3pm
ab5c,1122,12-02-2016-3pm,13-02-2016 7pm
ab3c,1232,12-02-2016-1pm,13-02-2016 7pm
ab2c,1432,12-02-2016-2pm,13-02-2016 7pm
ab6c,1452,12-02-2016-4am,13-02-2016 7pm
];
Also refer the attached sample application.
Hope this will be helpful.
Regards!
Rahul