8.03.404A dashboard filters

Yahoo Archive
1
Thanks Ken,



I am pretty new to 8.03.404



I was hoping to do all my filtering at the dashboard level, and to be
able to change the date at the dashboard level like a parameter field
in Crystal. Perhapsf I put one filter on the BAQ and the other on the
dashboard?



Thanks,



Dan





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Williams
Sent: Wednesday, April 23, 2008 3:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03.404A dashboard filters



The only way I've been able to do this is through a calculated field on
the BAQ itself.

For instance, I wanted to be able to show actual hours as green if we
were below 90% of estimated, yellow if we were 90-100% and red if we
were over 100%.

if (JobOper.EstProdHours = 0) then 0 //protect divison by 0
else if (JobOper.ActProdHours = 0) then 0 //0 is green
else if ((JobOper.ActProdHours / JobOper.EstProdHours * 100) > 100)
then 2 //2 is red
else if ((JobOper.ActProdHours / JobOper.EstProdHours * 100) > 90)
then 1 //1 is yellow
else 0

Then on my dashboard I just reference my calculated field of "Hours = 0"
then "act. hours = OK", "Hours = 2" then "act. hours = Error".

Hope this helps.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dan Shallbetter
Sent: Wednesday, April 23, 2008 1:45 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 8.03.404A dashboard filters

Is it possible to create a dashboard filter that uses "OR" logic? I
created the filter at the BAQ level put would like to do it at the
dashboard instead.

I am trying to create this filter "(JOB COMPLETE = NO) OR (JOB COMPLETE
DATE IS GREATER THAN DD/MM/YY)"

Thanks,

Dan Shallbetter

States Electric Mfg.

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

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





[Non-text portions of this message have been removed]
2
Is it possible to create a dashboard filter that uses "OR" logic? I
created the filter at the BAQ level put would like to do it at the
dashboard instead.



I am trying to create this filter "(JOB COMPLETE = NO) OR (JOB COMPLETE
DATE IS GREATER THAN DD/MM/YY)"



Thanks,



Dan Shallbetter

States Electric Mfg.





[Non-text portions of this message have been removed]
3
The only way I've been able to do this is through a calculated field on
the BAQ itself.

For instance, I wanted to be able to show actual hours as green if we
were below 90% of estimated, yellow if we were 90-100% and red if we
were over 100%.

if (JobOper.EstProdHours = 0) then 0 //protect divison by 0
else if (JobOper.ActProdHours = 0) then 0 //0 is green
else if ((JobOper.ActProdHours / JobOper.EstProdHours * 100) > 100)
then 2 //2 is red
else if ((JobOper.ActProdHours / JobOper.EstProdHours * 100) > 90)
then 1 //1 is yellow
else 0

Then on my dashboard I just reference my calculated field of "Hours = 0"
then "act. hours = OK", "Hours = 2" then "act. hours = Error".

Hope this helps.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Wednesday, April 23, 2008 1:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 8.03.404A dashboard filters



Is it possible to create a dashboard filter that uses "OR" logic? I
created the filter at the BAQ level put would like to do it at the
dashboard instead.

I am trying to create this filter "(JOB COMPLETE = NO) OR (JOB COMPLETE
DATE IS GREATER THAN DD/MM/YY)"

Thanks,

Dan Shallbetter

States Electric Mfg.

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






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