search

bezlio / bezlio-gallery

Collection of bezls that you can import and use in your Bezlio account
MIT License
3 stars 0 forks source link

Sales Manager - Win / Loss By Territory - Heat Map #24

Open aellis opened 7 years ago

aellis commented 7 years ago

The query on this one and corresponding Excel file should provide the following:

Description: Show a rolling 12 months summary by territory of wins versus losses as reported on quotes. Simply return a territory column, a customer name, a quote number, and a won / lost column.

The visualization will be a heat map as per here (https://www.fusioncharts.com/charts/heat-map-charts/) where each territory is a row and each month is a column. Won / lost will be represented as a color coded percentage.

aellis commented 7 years ago

Updated query to conform to standards specified to Raman:

WonNLoss By Territory.txt