Class Function with Max Interval?

[cbaqir]

I am using a class function that shows =class(WORKFLOW_DURATION,30,WORKFLOW_DURATION) .

I want the largest interval to show >120. Rather than 120 - 150, etc... How can I do this?

Thanks,

Cassandra

[sunny_talwar]

Can you share a sample?

[sunny_talwar]

I am seeing just one bar for the selection you have in your application.

[cbaqir]

If you Clear the selections, however, now the intervals don't look right.

If you look at the expression I am using, it is now Dual(If(WORKFLOW_DURATION <= 120, Class(Sum(total WORKFLOW_DURATION), 60), '>120'),
If(WORKFLOW_DURATION <= 120, Class(Sum(total WORKFLOW_DURATION), 60), 120))

[#5]

Create the Buckets in the script with IntervalMatch function.

[cbaqir]

Do you have a reference for that?

[cbaqir]

Please see updated sample.

[sunny_talwar]

Can you point out what isn't working? May be tell us what selections to make and what are the expected result based on those selections

[cbaqir]

if you select REQUEST_ID 182921, you will see two versions of the chart. The top one shows two buckets for one request (not sure why). The second chart looks correct with the  60-120 bucket compared to the data on the bottom showing 101 business days.

However, if you clear the selections, you will see the buckets for the second chart no longer reflect 0-60, 60-120 and >120. This is why I was playing with the Class(Sum(total))) in the expression...

Does that help? Sorry for the confusion.

[sunny_talwar]

Based on the REQUEST_ID selection, there are two rows of data one is between 0 and 60 and other is between 60 and 120. That is why you see two bars. Would you want to add them together when you create classes?

[sunny_talwar]

See if this is what you want?