{"action":"closed","issue":{"url":"https://api.github.com/repos/billchen198318/bamboobsc/issues/53","repository_url":"https://api.github.com/repos/billchen198318/bamboobsc","labels_url":"https://api.github.com/repos/billchen198318/bamboobsc/issues/53/labels{/name}","comments_url":"https://api.github.com/repos/billchen198318/bamboobsc/issues/53/comments","events_url":"https://api.github.com/repos/billchen198318/bamboobsc/issues/53/events","html_url":"https://github.com/billchen198318/bamboobsc/issues/53","id":250196535,"number":53,"title":"[User question] Measure data's Target and KPI's Target difference","user":{"login":"billchen198318","id":11564867,"avatar_url":"https://avatars1.githubusercontent.com/u/11564867?v=4","gravatar_id":"","url":"https://api.github.com/users/billchen198318","html_url":"https://github.com/billchen198318","followers_url":"https://api.github.com/users/billchen198318/followers","following_url":"https://api.github.com/users/billchen198318/following{/other_user}","gists_url":"https://api.github.com/users/billchen198318/gists{/gist_id}","starred_url":"https://api.github.com/users/billchen198318/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/billchen198318/subscriptions","organizations_url":"https://api.github.com/users/billchen198318/orgs","repos_url":"https://api.github.com/users/billchen198318/repos","events_url":"https://api.github.com/users/billchen198318/events{/privacy}","received_events_url":"https://api.github.com/users/billchen198318/received_events","type":"User","site_admin":false},"labels":[{"id":189636231,"url":"https://api.github.com/repos/billchen198318/bamboobsc/labels/question","name":"question","color":"cc317c","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-08-15T01:17:46Z","updated_at":"2018-02-24T23:52:41Z","closed_at":"2018-02-24T23:52:41Z","author_association":"OWNER","body":"**Question:**\r\n\r\nCongrats for the BambooBSC project. I've downloaded it about two weeks ago to use it as my BSC system. I have just entered the basic information like: Employee, organization, Vision, perspectives, objectives, KPIs.\r\n\r\nRight now i'm testing the system with de measure data but i've some questions, and i wondering if you could help me with them.\r\n\r\n\r\nAs you can see on the image, for every measure of any KPI, there is a need to enter both the Target and the actual data. Even if the KPI has already the target value defined. \r\n\r\nAlso, de frequency must relay on every KPI definition and not for every measure data.\r\n\r\nWith the situations explain above, when i am going to create a KPI report, i can just obtain the report for the KPI in the same frequency as they have been entered. If people enter a measure data in different frequencies, how can a report be build for the whole year with all the KPIs? \r\n\r\nI don't know if maybe there is an issue with this or i don't know how to use Bamboo BSC.\r\n\r\n![kpi measure](https://user-images.githubusercontent.com/11564867/29298505-bbeacbce-819a-11e7-93c6-3628710772bd.png)\r\n\r\n\r\n\r\n\r\n**1.**\r\n**As you can see on the image, for every measure of any KPI, there is a need to enter both the Target and the actual data. Even if the KPI has already the target value defined. \r\nAlso, de frequency must relay on every KPI definition and not for every measure data.**\r\n\r\n**Ans:**\r\n \r\nKPIs Target is scored value, it means measure data into formula and kpi aggregation method calculation result.\r\n\tMeasure target is means this measure target, it not calculation score result.\r\n\tThe are difference.\r\n\r\nExample :\r\n2017/01 need create product 10 carts. but actual complete 8 carts.\r\n2017/02 need create product 8 carts. but actual complete 8 carts.\r\n\r\nQuery date range 2017 , frequency is month.\r\n\t\r\nKPI target min is 60 , target is 110, max is 150. KPI's formual is F001 percent of target, aggregation method is AVG.\r\nF001 = actual ÷ target × 100; aggregation method is AVG;\r\nmeasure 2017/01, target input 10 . acutal input 8 , KPI date range  score is 8 ÷ 10 × 100 = 80\r\nmeasure 2017/02, target input 8 . acutal input 8 , KPI date range score  is 8 ÷ 8 × 100 = 100\r\n2017/01 score 80 + 2017/02 score 100 = 180 / 2 = 90 , the 90 is KPIs default score.\r\n\r\nin the bambooBSC report or dashboard , Often take the calculation result score(90) to compare with the KPIs target(110) , to check whether to achieve the goal.\r\n\t\r\n\r\n**2.** \r\n**If people enter a measure data in different frequencies, how can a report be build for the whole year with all the KPIs?** \t\r\n\r\n**Ans:**\r\n\r\nExample :\r\nEmployee(bill) input measure data frequency is \"month\". but employee(tiffany) input measure data frequency is \"year\".\r\nQuery report frequency select \"year\" tiffany has score, but bill will zero score. because no bill's year measure data.\r\nso need year frequency report need input year measure-data, need month frequency report need input month measure-data.\r\n\r\nbambooBSC Can not help you frequency-month to integrate the adult frequency-year.\r\nBut you can use bambooBSC Expression and Expression-JOB to do similar work, need self write Expression and config expression-job. it maybe not easy.\r\n\t\r\nMay not be able to meet your request, but a reference.\r\n"}}
{"actor":{"display_login":"billchen198318"}}