Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Right now I am using the following Dimension for my interval buckets:
=replace(aggr(Class(count(GOV_DECISION_BODY_SUB),2), DEFECT_ID), '<= x <','-')
What I am trying to accomplish is 3 things:
Any suggestions?
Thanks in advance!
Awesome!! Thank you! How do I change the sort order for the Legend?
Just the legend or the bars also? What order do you want?
And what about hard coding the selections? Any ideas?
both..if possible, in numerical order?
I have use dual function to create the dimension, I think all you need to do is to select numerical sorting on the sort tab for this dimension (GDB Count)
So you would need 8 charts, one for each PROCESS_STEP?
the chart returns values based on two PROCESS_STEP selections and either the number of tickets from one step to the other or, in another chart, avg # days. I will be creating views for Submitted to Routing to Routed, Routed to Fully Approved (Moved to resourcing) and Routed to Ticket Closed.
Duh thanks.
I am confused.... you want to PROCESS_STEPS then in this first view (let's take one view at a time)
The calculations are based on the selection of 2 PROCESS_STEP.
Here is my first selections of Submitted to Routing and Routed. Is there a way to hardcode these selections in the charts so the user doesn't have to select them in the list box? These charts will be exported to a PPT file via Nprinting. The other views I will need are: Routed to Fully Approved (Moved to resourcing) and Routed to Ticket Closed