| [totalPA] | [Format.0f][mathpa][/format]% | [totalorders] | [Format.0f][mathorders][/format]% | [totalPRICING] | [Format.0f][mathPRICING][/format]% | [IVISITORS] | [Format.0f][mathVISITORS][/format]% | [/founditems][/search]Alex J McCombie New World MediaChief Information Officer Drawer 607800/724.8973 Fair Haven, NY 13064Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On 2/8/03 12:30 PM, Alex McCombie wrote:Sorry about that. I missed the 4 searches (you may only need one dependingon how many things you would want to compare) that set the max variables ofwhich everything is compared against.Again... Hope this helps.Alex >> Anyone have any pointers on how to tackle this? I'm not sure where to>> start. I guess I could make tables and color the cells as needed, but>> maybe someone who has been down this path has another suggestion...?>> >> Thanks,I pulled this quickly and sanitized it so my apologies if something isntquiet right. But this tracks various increments in a partner only area of aclient site and displays those totals graphically.It does so by comparing the current total against the maximum totals foundfor each field to create a dynamic range from 0-100% (which changes everychart as soon as a new 100% is reached. Actually it is quite snappy as well.The client has gotten addicted to watching it ;-) You can see a screen image of it here:http://NewWorldMedia.com/chart.gifHTHAlex[search db=daily.db&neDATEINFOdatarq=findall&detotalpasort=1&totalpatype=num][founditems][showif[index]=1][text]maxPA=[totalpa][/text][/showif][/founditems][/search][search db=daily.db&neDATEINFOdatarq=findall&detotalorderssort=1&totalorderstype=num][founditems][showif[index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/search][search db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGtype=num][founditems][showif[index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/founditems][/search][search db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=num][founditems][showif[index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/search][search db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DATE][founditems][text]mathPA=[math][totalPA]/[maxpa]*100[/math][/text][text]mathorders=[math][totalorders]/[maxorders]*100[/math][/text][text]mathPRICING=[math][totalPRICING]/[maxPRICING]*100[/math][/text][text]mathVISITORS=[math][IVISITORS]/[maxVISITORS]*100[/math][/text] | [totalPA] | [math][totalPA]/[maxpa]*100[/math][/format]> [Format.0f][mathpa][/format]% | [totalorders] | [math][totalorders]/[maxorders]*100[/math][/format]> [Format.0f][mathorders][/format]% | [totalPRICING] | [math][totalPRICING]/[maxPRICING]*100[/math][/format]> [Format.0f][mathPRICING][/format]% | [IVISITORS] | [math][IVISITORS]/[maxVISITORS]*100[/math][/format]> [Format.0f][mathVISITORS][/format]% | [/founditems][/search]Alex J McCombie New World MediaChief Information Officer Drawer 607800/724.8973 Fair Haven, NY 13064Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Alex McCombie
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
emailer (1998)
WebCatalog can't find database (1997)
expire headers in mac305b11 (1999)
AppleScript: Tell application:app location? (1998)
searchable list archive (1997)
Transfer of data from Invoice to thank you templates (1998)
Just Testing (1997)
http upload (2001)
RE: Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
Problem (1997)
[include file=filename.inc&strip=t] (2002)
Grepping to remove text & code (2004)
Navigator 4.01 (1997)
2nd WebCatalog2 Feature Request (1996)
[LOOKUP] (1997)
Netscape 3.01 can't see db in form (was problems problemsproblems) (1997)
WebCat2b15MacPlugin - showing [math] (1997)
DNS Lookup 2 (2000)
protect tag not working (1998)
Checking for blank form fields (sort of...) (1998)