8 Replies Latest reply: Feb 17, 2016 11:12 AM by Cassandra Baqir RSS

    Class() Data Issue

    Cassandra Baqir

      As you can see, it seems to be counting REQUEST_IDs that are not within the Business Days Turn Around Time indicated in the class.

       

      For example, I would expect to see 16 REQUEST_IDs in Close Out for more than 120 days in the bottom table, but in reality there only appear to be 6.

       

      How do I get both charts to reflect the correct counts?

       

      2-3-2016 4-16-42 PM.jpg

        • Re: Class() Data Issue
          Stefan Wühl

          I think your two tables show different Business Days, second table uses set analysis which you need to include to first chart aggr() dimension to match

           

          =Dual(If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),

             If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

           

          edit:

          Or alternatively adapt the second chart's expression to match count of the first chart, i.e. remove the set expression.

            • Re: Class() Data Issue
              Cassandra Baqir

              What would I do without you, Stefan? Thank you!

              • Re: Class() Data Issue
                Cassandra Baqir

                Follow up question for you... when I use this expression in a list box, selecting >120 makes the other options disappear. It worked fine with the old expression. Any idea how to overcome this?

                 

                2-9-2016 2-17-09 PM.jpg

                  • Re: Class() Data Issue
                    Sunny Talwar

                    Try this (Note the 1s in red)

                     

                    =Dual(If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),

                      If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

                      • Re: Class() Data Issue
                        Cassandra Baqir

                        Thanks!

                        • Re: Class() Data Issue
                          Cassandra Baqir

                          Ok, so here are the questions of the day related to this change:

                           

                          I am now looking at a Historical WorkFlow Step instead of the Current Workflow Step.

                           

                          If I use this expression, the chart is adding the different step days together and producing a chart that is incorrect:

                           

                          2-16-2016 2-51-01 PM.jpg

                           

                          =Dual(If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),
                          If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

                          What I would expect here is this view:

                          =DualIf(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 60), '>120'),  If(WORKFLOW_DURATION <= 120, Class(WORKFLOW_DURATION, 60), 120)  )

                          2-16-2016 3-16-32 PM.jpg

                           

                          Not sure if it makes sense to use these two different expressions - but one for Current Workflow Step charts (previous in thread) and one for Historical view (this one).

                           

                          Also, we noticed that now the List Box value does not stay green if other list box filters are also selected.

                           

                          It shows green when it's the only filter but if this and something else is selected, we get this:

                           

                          2-11-2016 3-55-44 PM.jpg

                          I believe it's not staying green because I am using the expression with the aggr and flag:

                           

                          =Dual(If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),
                          If(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({1<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

                          2-17-2016 9-05-24 AM.jpg

                           

                          How can I get this expression list box to work in both scenarios for current and historical views?

                           

                          Thanks!