need help

[mshailaja]

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

];

[MK_QSL]

Canonical Date

[mshailaja]

I want to show the incidents opened date and time in drill down/cyclic , in chart , how to do?

[Anil_Babu_Samineni]

May be use Cyclic with the dimensions are [opened date] and SubField([opened date],'-', -1) and then use metric like Sum(Measure)

[rahulpawarb]

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