visual analytics

Number Calculations.twb

Country 129 [Country] [Extract] Country 0 'Sales Quotas$' string Count 15 1 1073741823 false "Australia" "United States of America" "en_US_CI" true "heap" true "asc" 4294967292 0 "asc" 1 true "str" Number of Records 16 [Number of Records] [Extract] Number of Records 1 integer Sum 1 false 1 1 "asc" 1 "sint8" Quotas 3 [Quotas] [Extract] Quotas 2 'Sales Quotas$' integer Sum 9 true 115000 500000 true "array" true 4 1 "asc" 1 "sint32" Sales 3 [Sales] [Extract] Sales 3 'Sales Quotas$' integer Sum 15 false 132488 524616 4 true "sint32" Country 129 [Country] [Extract] Country 0 'Sales Quotas$' string Count 15 1 1073741823 false "Australia" "United States of America" "en_US_CI" true "heap" true "asc" 4294967292 0 "asc" 1 true "str" Number of Records 16 [Number of Records] [Extract] Number of Records 1 integer Sum 1 false 1 1 "asc" 1 "sint8" Quotas 3 [Quotas] [Extract] Quotas 2 'Sales Quotas$' integer Sum 9 true 115000 500000 true "array" true 4 1 "asc" 1 "sint32" Sales 3 [Sales] [Extract] Sales 3 'Sales Quotas$' integer Sum 15 false 132488 524616 4 true "sint32" Create a calculated field that will return a zero when Quota is Null. Create a calculated field that calculates the difference between each Country's sales and their quota.Then place this calculation on color to show the variation. iVBORw0KGgoAAAANSUhEUgAAAK4AAACQCAYAAACRfFAzAAAACXBIWXMAAA7DAAAOwwHHb6hk AAABmUlEQVR4nO3SQQ0AIBDAMMC/58MDH7KkVbDH9szMgpjzOwBeGJck45JkXJKMS5JxSTIu ScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45Jk XJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYl ybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKM S5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgk GZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5Jx STIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck 45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuSRePYgUc7kJNEQAAAABJRU5ErkJg gg== iVBORw0KGgoAAAANSUhEUgAAAK4AAACQCAYAAACRfFAzAAAACXBIWXMAAA7DAAAOwwHHb6hk AAABmUlEQVR4nO3SQQ0AIBDAMMC/58MDH7KkVbDH9szMgpjzOwBeGJck45JkXJKMS5JxSTIu ScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45Jk XJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYl ybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKM S5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgk GZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5Jx STIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuScYlybgkGZck 45JkXJKMS5JxSTIuScYlybgkGZck45JkXJKMS5JxSTIuSRePYgUc7kJNEQAAAABJRU5ErkJg gg==