Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
Creator
Creator

Bullet Graph Design by Stephen Few (QV practice)

Dear, Experts.

I'm working on Sales Managers Dashboards and need more practice examples and details about how can I realize Bullet Graph Design by Stephen Few in my QV project.

For example, I wants to show  for Sales Managers progress of sales plan development day by day (Plan development vs. Time).

Plan: Plan -1000, working days - 22

Facts: Actuals  - 100, working days passed - 3

Forecast: Actuals that must be on current date -  1000/22*3= 136, GAP (by date) = 136 -100 = 36, Forecast = 100/3*22= 733, GAP (by Forecast) = 1000-733 = 267. Must to sell by day to achive Plan  / Reduce  GAP = (1000 -100) / (22-3)= 47,4.

Thanks a lot for any  recomendations, examples and details realization Bullet Graph Design by Stephen Few in your projects!

hicrwunderlichjohnwext_aaqstalwar1bwisenosimenkgahaahaaha

2 Replies
DavidFoster1
Specialist
Specialist

Hi Vadim

If you are looking at a day-by-day trend then a bullet chart is not ideal. I would use a bullet chart to show the year-to-date or month-to-date total actuals against the equivalent plan values.

To show day by day a cumulative line chart will be more effective. They are often called run rate charts as the planned line tends to be a straight line a planned values accumulate of the days while the actuals snake around as the actual values fluctuate.

I hope that helps.

vadim_grab
Creator
Creator
Author

David, hi

Thank you for your comments. I necessarily try to use run rate charts