tag:blogger.com,1999:blog-3998628784041768080.post643903822684687978..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Makeover Monday: Are We Nearing the Death of Chicago Taxis?VizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3998628784041768080.post-83923633359910263052017-02-09T23:28:54.248+00:002017-02-09T23:28:54.248+00:00Ah great catch! Thanks Kuba!Ah great catch! Thanks Kuba!VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-2515555781796172092017-02-08T15:20:06.556+00:002017-02-08T15:20:06.556+00:00Hi Andy :),
First of all I'm a big fan of yo...Hi Andy :), <br /><br />First of all I'm a big fan of yours work. Dashboard looks awesome. <br />I have one question - after digging into calculations (i always learn something new from yours dashboards) i believe that Dot Color field is now working as should. We always will see false value because "Last value" < 0 Example is MOUNT GREENWOOD<br />I added exclude to duplicate dataKubahttps://www.blogger.com/profile/02079786895582162078noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-70735276290002906482017-02-07T18:05:54.604+00:002017-02-07T18:05:54.604+00:00Correct, it's a boolean test. I can then write...Correct, it's a boolean test. I can then write another calc to do something else based on the result of the boolean.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-20389842746881214302017-02-07T17:43:34.536+00:002017-02-07T17:43:34.536+00:00That's what I'm needing, I think. My under...That's what I'm needing, I think. My understanding is that it serves as a boolean test that will only return a result if the record is either the first or last month, but I'm not sure how it works. My first thought was you could just use a LAST()=0 calculation, then put it on color. It would work fine for a dual axis line, but that would show a point at each month (which would be Vincehttps://www.blogger.com/profile/02994259172039560562noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-13120980465894145972017-02-06T23:38:04.311+00:002017-02-06T23:38:04.311+00:00You can download the workbook and see how it works...You can download the workbook and see how it works. Or did you do that already and just need a plain English explanation?VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-85664727508191881092017-02-06T21:35:11.629+00:002017-02-06T21:35:11.629+00:00Great work, Andy! Could you walk me through the Do...Great work, Andy! Could you walk me through the Dot Color calc though? I can't wrap my head around that one.Vincehttps://www.blogger.com/profile/02994259172039560562noreply@blogger.com