I want to calculate threshold on multiple different parameters. ie year, month, day, hours etc for certain catagory.
1) what is the best way to show all these analysis in same chart, can it be done or should I use seperate charts for each catagory.
should i use guage chart, bar chart, line chart. give your ideas and point to example if there are any.
2) Whats the formula to calculate. Average total sales (as per user selection of either year, month, day, hours) *120% and use it as threshold ot mark high performers.