| [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:
WC 4.0 on OSX 10.0.4 problems (2001)
Fun with dates (1997)
WCS Newbie question (1997)
[WebDNA] Formatting text (2011)
Its not that weird. (1997)
StoreBuilder and PayPal (2002)
Download URL & access on the fly ? (1997)
Trouble with adding multiple items to cart (1999)
Another question (1997)
sorting... (2003)
[cart]'s ever get recycled? (2000)
WebCat2b15MacPlugin - [protect] (1997)
Ship Cost Calculated via Subtotal (1998)
Trouble with formula.db (1997)
[WebDNA] HTML [sendmail] revisited (2009)
Attn: Bug in GeneralStore example b15 (1997)
Newbie questions (2000)
Deleting Orders (1997)
Searching an Email database (1997)
restart needed???? (1997)