Re: Graphical display of sales volume
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47583
interpreted = N
texte = Thanks guys...That definitely gets me started...!On Saturday, February 8, 2003, at 09:16 PM, Gary Krockover wrote:> Nice, added that to my personal snippet collection, thanks!>> GK>>>> On 2/8/03 12:30 PM, Alex McCombie
wrote:>> Sorry about that. I missed the 4 searches (you may only need one >> depending>> on how many things you would want to compare) that set the max >> variables> of>> which 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 >> isnt>> quiet right. But this tracks various increments in a partner only >> area of> a>> client site and displays those totals graphically.>>>> It does so by comparing the current total against the maximum totals >> found>> for each field to create a dynamic range from 0-100% (which changes >> every>> chart 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.gif>>>> HTH>> Alex>>>>>> [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&totalorderstyp > e=num>> ]>> [founditems][showif>>> [index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/ > search>> ]>>>> [search>>> db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGt > ype=n>> um]>> [founditems][showif>>> [index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/ > founditems][/sear>> ch]>>>> [search>> db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=n >> um]>> [founditems][showif>>> [index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/ > search>> ]>>>> [search>> db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DAT >> E]>> [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]>>>>>>>> | > size=1>[totalPA] | > size=1> > src=bar.gif height=10 width=[Format>> .0f][math][totalPA]/[maxpa]*100[/math][/format]> [Format>> .0f][mathpa][/format]% | >>>> SIZE=1>[totalorders] | >> > height=10 width=[Format>> .0f][math][totalorders]/[maxorders]*100[/math][/format]> [Format>> .0f][mathorders][/format]% | >>>> > size=1>[totalPRICING] | >> > height=10 width=[Format>> .0f][math][totalPRICING]/[maxPRICING]*100[/math][/format]> [Format>> .0f][mathPRICING][/format]% | >>>> > size=1>[IVISITORS] | >> > height=10 width=[Format>> .0f][math][IVISITORS]/[maxVISITORS]*100[/math][/format]> [Format>> .0f][mathVISITORS][/format]% | >>>>>> [/founditems][/search]>>>>>>>> Alex J McCombie New World Media>> Chief Information Officer Drawer 607>> 800/724.8973 Fair Haven, NY 13064>> Alex@NewWorldMedia.com http://OurClients.com>>>> Interface 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/>>--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@novaderm.com-------------------------------------------------------------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:
Thanks guys...That definitely gets me started...!On Saturday, February 8, 2003, at 09:16 PM, Gary Krockover wrote:> Nice, added that to my personal snippet collection, thanks!>> GK>>>> On 2/8/03 12:30 PM, Alex McCombie wrote:>> Sorry about that. I missed the 4 searches (you may only need one >> depending>> on how many things you would want to compare) that set the max >> variables> of>> which 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 >> isnt>> quiet right. But this tracks various increments in a partner only >> area of> a>> client site and displays those totals graphically.>>>> It does so by comparing the current total against the maximum totals >> found>> for each field to create a dynamic range from 0-100% (which changes >> every>> chart 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.gif>>>> HTH>> Alex>>>>>> [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&totalorderstyp > e=num>> ]>> [founditems][showif>>> [index]=1][text]maxorders=[totalorders][/text][/showif][/founditems][/ > search>> ]>>>> [search>>> db=daily.db&neDATEINFOdatarq=findall&detotalPRICINGsort=1&totalPRICINGt > ype=n>> um]>> [founditems][showif>>> [index]=1][text]maxPRICING=[totalPRICING][/text][/showif][/ > founditems][/sear>> ch]>>>> [search>> db=daily.db&neDATEINFOdatarq=findall&deIVISITORSsort=1&IVISITORStype=n >> um]>> [founditems][showif>>> [index]=1][text]maxVISITORS=[IVISITORS][/text][/showif][/founditems][/ > search>> ]>>>> [search>> db=daily.db&neDATEINFOdatarq=findall&deDATEINFOsort=1&DATEINFOtype=DAT >> E]>> [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]>>>>>>>> | > size=1>[totalPA] | > size=1> > src=bar.gif height=10 width=[Format>> .0f][math][totalPA]/[maxpa]*100[/math][/format]> [Format>> .0f][mathpa][/format]% | >>>> SIZE=1>[totalorders] | >> > height=10 width=[Format>> .0f][math][totalorders]/[maxorders]*100[/math][/format]> [Format>> .0f][mathorders][/format]% | >>>> > size=1>[totalPRICING] | >> > height=10 width=[Format>> .0f][math][totalPRICING]/[maxPRICING]*100[/math][/format]> [Format>> .0f][mathPRICING][/format]% | >>>> > size=1>[IVISITORS] | >> > height=10 width=[Format>> .0f][math][IVISITORS]/[maxVISITORS]*100[/math][/format]> [Format>> .0f][mathVISITORS][/format]% | >>>>>> [/founditems][/search]>>>>>>>> Alex J McCombie New World Media>> Chief Information Officer Drawer 607>> 800/724.8973 Fair Haven, NY 13064>> Alex@NewWorldMedia.com http://OurClients.com>>>> Interface 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/>>--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@novaderm.com-------------------------------------------------------------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/
WJ Starck
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 Database Format (1997)
Extended [ConvertChars] (1997)
unable to launch acgi in WebCat (1997)
upgrading (1997)
Change Subtotal (2000)
Help Please WebDNA 6 Secure Forms Problem (2004)
Forms Search Questions (1997)
Re[2]: HELP: OS X Problem... (2000)
Generating Searches on the fly? (1999)
[WebDNA] TCPCONNECT & Timeout (2015)
WebCat2.0 [format thousands .0f] no go (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Webmerchant confirmation hooks? (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Search/sort in URL Was: GuestBook example (1997)
merchant accts. (1997)
Re:Emailer tracking (1997)
value=[variable] (2001)
[SearchString] problem with [search] context (1997)
Re:Still More on EudoraPro Email (1998)