Create Metric With Excel Data
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.
Excel file will be attached
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
