Grouping a Dashboard

You may be able to do this with a BAQ without adding BPMs. I have not
fully tested this.



Master Table = JobOper

Alias Table Join to JobOper renaming it JobPriorOper.

Find First or Last to get just one operation prior not all, depends if
your sorting.

Criteria = JobPriorOper.OprSeq < JobOper.OprSeq.



EXPECTED WORK you can filter for Actual Time or Pieces turned in.

AVALIABLE WORK filter if prior operation is complete.

Since your bringing all the fields you can tune as you like.



for each JobOper no-lock , first JobPriorOper no-lock where
(JobOper.Company = JobPriorOper.Company and JobOper.JobNum =
JobPriorOper.JobNum and JobOper.AssemblySeq = JobPriorOper.AssemblySeq )
and JobPriorOper.OprSeq < JobOper.OprSeq .



It would be fantastic if Epicor would two fields to each JobOper record.
PriorOperationSequence and NextOperationSequence this would make
creating BAQs for all kinds of Scheduling stuff much easier.



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, June 13, 2012 08:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Grouping a Dashboard





What I am looking to do is I am re-creating the Work Queue\Priority
Dispatch
report Functionality in a Dashboard. I placed a UD field on Job
Operation
(JobOper.ShortChar01) and through 4 different BPMs I have setup this
field
to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much
like
the Priority Dispatch Report uses.

Now I want to create a Dashboard that will display Jobs that have been
released and is scheduled for a Resource or Resource Group and show in
three
different groups corresponding to the Job Operation status. I have the
BAQ
and Dashboard built that does this, and with the code from the group to
automatically open the groups, but want it Grouped in the exact order of
CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.

The plan is to then run a large display next to these Resources or
Resource
Groups (Machines or Departments) using these Dashboards so the operator
of a
Machine or the Department can easily see what the status is on all Jobs
related to that Machine or Department. Then possibly place a button on a
Dashboard where they can clock into and out of Jobs\Operations without
using
MES. Then the goal would be to try to go without needing Job Travelers.
The Dashboards make scheduling more dynamic\real time without having to
talk
directly to an operator or department, we do a lot of rearranging with
the
schedule on a day to day basis due to rush jobs.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Jose Gomez
Sent: Tuesday, June 12, 2012 7:32 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Grouping a Dashboard

Add te grouping and sorting then right click save layout go into dev
mode
and make a small change. save

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...
<mailto:scott.litzau%40olympusgrp.com> >wrote:

> **
>
>
> I would like to have a Dashboard that when it opens it Groups in a
> Specific Order and not sort Alphabetically (ascending or Descending).
> Is this possible?
>
> Scott
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
I would like to have a Dashboard that when it opens it Groups in a Specific Order and not sort Alphabetically (ascending or Descending). Is this possible?

Scott
Add te grouping and sorting then right click save layout go into dev mode
and make a small change. save

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...>wrote:

> **
>
>
> I would like to have a Dashboard that when it opens it Groups in a
> Specific Order and not sort Alphabetically (ascending or Descending). Is
> this possible?
>
> Scott
>
>
>


[Non-text portions of this message have been removed]
What I am looking to do is I am re-creating the Work Queue\Priority Dispatch
report Functionality in a Dashboard. I placed a UD field on Job Operation
(JobOper.ShortChar01) and through 4 different BPMs I have setup this field
to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much like
the Priority Dispatch Report uses.

Now I want to create a Dashboard that will display Jobs that have been
released and is scheduled for a Resource or Resource Group and show in three
different groups corresponding to the Job Operation status. I have the BAQ
and Dashboard built that does this, and with the code from the group to
automatically open the groups, but want it Grouped in the exact order of
CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.

The plan is to then run a large display next to these Resources or Resource
Groups (Machines or Departments) using these Dashboards so the operator of a
Machine or the Department can easily see what the status is on all Jobs
related to that Machine or Department. Then possibly place a button on a
Dashboard where they can clock into and out of Jobs\Operations without using
MES. Then the goal would be to try to go without needing Job Travelers.
The Dashboards make scheduling more dynamic\real time without having to talk
directly to an operator or department, we do a lot of rearranging with the
schedule on a day to day basis due to rush jobs.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, June 12, 2012 7:32 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Grouping a Dashboard

Add te grouping and sorting then right click save layout go into dev mode
and make a small change. save

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...>wrote:

> **
>
>
> I would like to have a Dashboard that when it opens it Groups in a
> Specific Order and not sort Alphabetically (ascending or Descending).
> Is this possible?
>
> Scott
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Scott,

I have a version of the priority dispatch list I built as a dashboard. I'm very interested in the process youre using to set available, expected etc.. I'm willing to share my dashboard, are you open to sharing those BPM's? Contact me offline if so. Thanks!



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Scott Litzau
Sent: Wednesday, June 13, 2012 8:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Grouping a Dashboard



What I am looking to do is I am re-creating the Work Queue\Priority Dispatch
report Functionality in a Dashboard. I placed a UD field on Job Operation
(JobOper.ShortChar01) and through 4 different BPMs I have setup this field
to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much like
the Priority Dispatch Report uses.

Now I want to create a Dashboard that will display Jobs that have been
released and is scheduled for a Resource or Resource Group and show in three
different groups corresponding to the Job Operation status. I have the BAQ
and Dashboard built that does this, and with the code from the group to
automatically open the groups, but want it Grouped in the exact order of
CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.

The plan is to then run a large display next to these Resources or Resource
Groups (Machines or Departments) using these Dashboards so the operator of a
Machine or the Department can easily see what the status is on all Jobs
related to that Machine or Department. Then possibly place a button on a
Dashboard where they can clock into and out of Jobs\Operations without using
MES. Then the goal would be to try to go without needing Job Travelers.
The Dashboards make scheduling more dynamic\real time without having to talk
directly to an operator or department, we do a lot of rearranging with the
schedule on a day to day basis due to rush jobs.

Scott

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Jose Gomez
Sent: Tuesday, June 12, 2012 7:32 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Grouping a Dashboard

Add te grouping and sorting then right click save layout go into dev mode
and make a small change. save

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...<mailto:scott.litzau%40olympusgrp.com>>wrote:

> **
>
>
> I would like to have a Dashboard that when it opens it Groups in a
> Specific Order and not sort Alphabetically (ascending or Descending).
> Is this possible?
>
> Scott
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
Use a numeric UD field as a "sort" variable and as you generate your status, fill it with 1(Current), 2(Available), 3(Expected). Then sort on that.

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...> wrote:
>
> What I am looking to do is I am re-creating the Work Queue\Priority Dispatch
> report Functionality in a Dashboard. I placed a UD field on Job Operation
> (JobOper.ShortChar01) and through 4 different BPMs I have setup this field
> to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much like
> the Priority Dispatch Report uses.
>
> Now I want to create a Dashboard that will display Jobs that have been
> released and is scheduled for a Resource or Resource Group and show in three
> different groups corresponding to the Job Operation status. I have the BAQ
> and Dashboard built that does this, and with the code from the group to
> automatically open the groups, but want it Grouped in the exact order of
> CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
> Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.
>
> The plan is to then run a large display next to these Resources or Resource
> Groups (Machines or Departments) using these Dashboards so the operator of a
> Machine or the Department can easily see what the status is on all Jobs
> related to that Machine or Department. Then possibly place a button on a
> Dashboard where they can clock into and out of Jobs\Operations without using
> MES. Then the goal would be to try to go without needing Job Travelers.
> The Dashboards make scheduling more dynamic\real time without having to talk
> directly to an operator or department, we do a lot of rearranging with the
> schedule on a day to day basis due to rush jobs.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Jose Gomez
> Sent: Tuesday, June 12, 2012 7:32 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Grouping a Dashboard
>
> Add te grouping and sorting then right click save layout go into dev mode
> and make a small change. save
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...>wrote:
>
> > **
> >
> >
> > I would like to have a Dashboard that when it opens it Groups in a
> > Specific Order and not sort Alphabetically (ascending or Descending).
> > Is this possible?
> >
> > Scott
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
Sounds like a good setup. If you want the Status to go Current, Available or Expected. I would assign a StatusID to each and sort by that. Current ID1, Available ID2, Expected ID3

Miguel A. Santillan
Compass Components, Inc.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Wednesday, June 13, 2012 7:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Grouping a Dashboard



Scott,

I have a version of the priority dispatch list I built as a dashboard. I'm very interested in the process youre using to set available, expected etc.. I'm willing to share my dashboard, are you open to sharing those BPM's? Contact me offline if so. Thanks!

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Scott Litzau
Sent: Wednesday, June 13, 2012 8:49 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Grouping a Dashboard

What I am looking to do is I am re-creating the Work Queue\Priority Dispatch
report Functionality in a Dashboard. I placed a UD field on Job Operation
(JobOper.ShortChar01) and through 4 different BPMs I have setup this field
to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much like
the Priority Dispatch Report uses.

Now I want to create a Dashboard that will display Jobs that have been
released and is scheduled for a Resource or Resource Group and show in three
different groups corresponding to the Job Operation status. I have the BAQ
and Dashboard built that does this, and with the code from the group to
automatically open the groups, but want it Grouped in the exact order of
CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.

The plan is to then run a large display next to these Resources or Resource
Groups (Machines or Departments) using these Dashboards so the operator of a
Machine or the Department can easily see what the status is on all Jobs
related to that Machine or Department. Then possibly place a button on a
Dashboard where they can clock into and out of Jobs\Operations without using
MES. Then the goal would be to try to go without needing Job Travelers.
The Dashboards make scheduling more dynamic\real time without having to talk
directly to an operator or department, we do a lot of rearranging with the
schedule on a day to day basis due to rush jobs.

Scott

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of
Jose Gomez
Sent: Tuesday, June 12, 2012 7:32 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Grouping a Dashboard

Add te grouping and sorting then right click save layout go into dev mode
and make a small change. save

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...<mailto:jose%40josecgomez.com><mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...<mailto:scott.litzau%40olympusgrp.com><mailto:scott.litzau%40olympusgrp.com>>wrote:

> **
>
>
> I would like to have a Dashboard that when it opens it Groups in a
> Specific Order and not sort Alphabetically (ascending or Descending).
> Is this possible?
>
> Scott
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/><http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Oops! Hit send too soon. If you don't want to use up another UD field, just change your status to "1-Current", etc.

--- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@...> wrote:
>
> Use a numeric UD field as a "sort" variable and as you generate your status, fill it with 1(Current), 2(Available), 3(Expected). Then sort on that.
>
> --- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@> wrote:
> >
> > What I am looking to do is I am re-creating the Work Queue\Priority Dispatch
> > report Functionality in a Dashboard. I placed a UD field on Job Operation
> > (JobOper.ShortChar01) and through 4 different BPMs I have setup this field
> > to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much like
> > the Priority Dispatch Report uses.
> >
> > Now I want to create a Dashboard that will display Jobs that have been
> > released and is scheduled for a Resource or Resource Group and show in three
> > different groups corresponding to the Job Operation status. I have the BAQ
> > and Dashboard built that does this, and with the code from the group to
> > automatically open the groups, but want it Grouped in the exact order of
> > CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
> > Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.
> >
> > The plan is to then run a large display next to these Resources or Resource
> > Groups (Machines or Departments) using these Dashboards so the operator of a
> > Machine or the Department can easily see what the status is on all Jobs
> > related to that Machine or Department. Then possibly place a button on a
> > Dashboard where they can clock into and out of Jobs\Operations without using
> > MES. Then the goal would be to try to go without needing Job Travelers.
> > The Dashboards make scheduling more dynamic\real time without having to talk
> > directly to an operator or department, we do a lot of rearranging with the
> > schedule on a day to day basis due to rush jobs.
> >
> > Scott
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > Jose Gomez
> > Sent: Tuesday, June 12, 2012 7:32 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Grouping a Dashboard
> >
> > Add te grouping and sorting then right click save layout go into dev mode
> > and make a small change. save
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@>wrote:
> >
> > > **
> > >
> > >
> > > I would like to have a Dashboard that when it opens it Groups in a
> > > Specific Order and not sort Alphabetically (ascending or Descending).
> > > Is this possible?
> > >
> > > Scott
> > >
> > >
>
What a great and simple idea. I will give it a shot.



Scott



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kirstin Brandt
Sent: Wednesday, June 13, 2012 9:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Grouping a Dashboard





Use a numeric UD field as a "sort" variable and as you generate your status,
fill it with 1(Current), 2(Available), 3(Expected). Then sort on that.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Scott
Litzau" <scott.litzau@...> wrote:
>
> What I am looking to do is I am re-creating the Work Queue\Priority
Dispatch
> report Functionality in a Dashboard. I placed a UD field on Job Operation
> (JobOper.ShortChar01) and through 4 different BPMs I have setup this field
> to update with a status of either CURRENT, AVAILABLE or EXPECTED. Much
like
> the Priority Dispatch Report uses.
>
> Now I want to create a Dashboard that will display Jobs that have been
> released and is scheduled for a Resource or Resource Group and show in
three
> different groups corresponding to the Job Operation status. I have the BAQ
> and Dashboard built that does this, and with the code from the group to
> automatically open the groups, but want it Grouped in the exact order of
> CURRENT at the Top, AVAILABLE in the middle and EXPECTED at the bottom.
> Instead of it being AVAILABLE, CURRENT EXPECTED or visa-versa.
>
> The plan is to then run a large display next to these Resources or
Resource
> Groups (Machines or Departments) using these Dashboards so the operator of
a
> Machine or the Department can easily see what the status is on all Jobs
> related to that Machine or Department. Then possibly place a button on a
> Dashboard where they can clock into and out of Jobs\Operations without
using
> MES. Then the goal would be to try to go without needing Job Travelers.
> The Dashboards make scheduling more dynamic\real time without having to
talk
> directly to an operator or department, we do a lot of rearranging with the
> schedule on a day to day basis due to rush jobs.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Jose Gomez
> Sent: Tuesday, June 12, 2012 7:32 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Grouping a Dashboard
>
> Add te grouping and sorting then right click save layout go into dev mode
> and make a small change. save
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, Jun 12, 2012 at 6:05 PM, litzer1 <scott.litzau@...>wrote:
>
> > **
> >
> >
> > I would like to have a Dashboard that when it opens it Groups in a
> > Specific Order and not sort Alphabetically (ascending or Descending).
> > Is this possible?
> >
> > Scott
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>





[Non-text portions of this message have been removed]