Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the visualizations featured earlier.
Anatomy of a Great Speech – Obama’s acceptance speech at DNC
Presentation Zen captures Obama’s symphony like acceptance speech in a graph shown above. Do read Garr Reynold’s remarks.
Tracking Hurricane Gustav a la infographic style
These days telling a complex story like how a hurricane strikes is made easy, thanks to tons of flash based visualization tools available for news reporters. [via Flowing Data]
How would tell your story if you are aiming to change a habit? – Google Chrome Comic Book
Google has launched their open source browser Chrome. Now this is a very bold step, when millions of people have developed a hobby of using IE or Firefox and pretty much satisfied with them. How did Google tell their story of new browser and created a need for it ? By creating a comic book and telling every one how browsers work, about memory leaks, garbage collection, UI design. Very effective.
More Olympics visualizations – News paper comes to life and tells impressive stories
What would you do when you are revamping infographics department of a leading news paper? Folks at El Heraldo have done a fantastic job.
Sony Walkman Subway map advertisement
Okay, this is not infographic, but it is a very creative way to tell that Sony Walkman is a constant companion no matter which route you take on the metro. Very creative, very effective. I can’t imagine taking metro to anywhere without company or music. [via cool infographics]
Click here to check out other cool infographics. 🙂
11 Responses to “Who is the most consistent seller? [BYOD]”
The Date column in the sample file is Text not Dates
[…] http://chandoo.org/wp/2015/02/18/calculating-consistency-in-excel/?utm_source=feedburner&utm_med… […]
Great Chandoo. Keep it up, Looking forward more from BYOD..
Thanks
With Excel 2013 the pivot table could be connected to the data model which provides a distinct count.
This will do for invoice count
=COUNTIF(F:F,H12)
Instead of
=COUNTIFS(sales[SELLER],$H12)
Excellent document. How did you make the last graphic? Witch app. Thanks for answer.
Can someone tell me what =countif(sales[date],sales[date]) is counting? The value is 19. Its found in the =SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))
Hi Chris,
=countif(sales [date],sales[date]) function is counting the unique dates in the table.
Vândalo
Excellent document!
Can you explain more about the calculation on Weighted consistency? More specific the small number is 0,00001 ?
How come the number should be smaller if there is more sellers?
Hi,
Not understood this formula: {=SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))}
Please explain.
Thanks.