How many total for each “Creator” ?

Create a high standard metric showing the below. Show all pivot table fields and metrics/charts used in separate tabs if needed. .

⦁ How many total for each “Creator” ?
⦁ For each “Creator” how many have ‘DEFAULT DOCUMENT TITLE’ in “Title” field out of the total they have done.
⦁ For each “Creator” how many have blank/null  in “Comments (b2Comments)” field out of the total they have done
⦁ Translate the “Creator id"field into a real name. Creator ID and corresponding name can be found in second tab.  Maybe write a query that will pull the name from the second tab(creator name), just incase i add new Creator ID. So the metric should show Creator name instead of ID.

In the future , I will want to do the same thing multiple times by just copy and paste details into the excel sheet with headings remaining the same.  Therefore, I am looking for a repeatable way to do this so all i have to do is paste new data and i can spit out or refresh  the metric quickly.

  • Assignment status: Solved by our Writing Team at EssayCabinet.com
  •  
  • CLICK HERE TO ORDER THIS PAPER AT EssayCabinet.com

    • Comments

    Post a Comment

    Popular posts from this blog

    Create Thread”. Do not create a new forum.

    Image
    This assignment allows students to develop exam study guides, while also helping classmates. Students have been divided into groups (approximately 4 people in each group). To work with your group, and post the two required postings, go to the Blackboard course website and choose “My Groups” from the left side menu. Click on the group, then, under “Group Tools” click “Group Discussion Board”. For further instructions regarding how to use/post to the discussion board, I have attached instructions to this assignment. Students may only consult, and cite, the textbook, the assigned supplemental readings/video, and the narrated lectures for this assignment.    Part 1: The first part of this assignment is to post to your GROUP DISCUSSION BOARD (not the class discussion board), an open-ended question (requiring more than a yes or no answer) from the chapter you have been assigned. Do not post an answer; just a question. To post, click on the Student Study Guide assignment in your group disc
    Read more

    Discuss the notion that firms should stop doing business with customers who constantly generate losses versus the notion that the customer is always right.

    Image
      Discuss the notion that firms should stop doing business with customers who constantly generate losses versus the notion that the customer is always right.   Assignment status :    Get solution from our writing team CLICK HERE TO ORDER THIS PAPER AT PrimeWritersBay.com PAPER COMPLETED BY OUR WRITING EXPERTS    FREE FROM PLAGIARISM  
    Read more

    Access AHIMA: What is Health Information

    Image
      Reflection Students are encouraged to create portfolios and begin to "manage" their careers. When you began a college education you took the first step. You now need to begin to reflect on the next goal, then medium, and long-term goals. I did not complete my final degree until well into my 50's. And that is fine, I loved my health care career. I was eager to care for patients and did not leave direct patient care for many decades. I did know the time would come to do so however, and began to earn the college degrees I would need at the proper time. This is what is meant by managing your career. This is an entry level program. It is designed to assist you in getting your "foot in the door" where you can learn valuable clinical skills. A common and important degree is the Bachelor of Health Information Management (BS-HIM). This is a reflective assignment. After you have earned your Associate Degree, what would you like to do next? Explore your next step in Care
    Read more