Candidate details sheet doesnt contain candidate name, how many candidates were sourced position wise which are important data as far a recruitment tracker is concerned. Appreciate if you have a sheet with those details as well and how we can bring it to the dashboard as a metric
Hi, will adding this data to Data Model, the excel (Pivot) throw an error of "We can't summarize this field with Average because it's not a supported calculation for Text data types." Please help!!!
Hi, it is due to the fact that you are using the formula "ISBLANK" => is recognized as "Text" in Power Pivot. You can't calculate the average of a Text
@@dhawal481 Replace " " in the formula ISBLANK with 0. All blanks should become a zero (0). In the pivot-table only check the closed positions (Uncheck blanks and yes), then refresh the pivottable. The average of only the closed positions will be calculated
Thank you so much for sharing the useful information. The recruitment process can be streamlined and simplified by the use of some suitable tools like the Recruitment Management System "HireME cloud". HireMe is the most trusted and useful recruitment management software, currently used by more than 100 companies.
![Pivot Table for HR Professionals [Part 1]](http://i.ytimg.com/vi/JHxc70l3Aic/mqdefault.jpg)
Thanks for the video . Please share the data sheet so i can practice as guided
Very aptly explained, Keep it up! And help us with more videos 🌺
Need few more metrics to be covered. Do upload many more videos like this.
Do you have a downloadable excel that we can use and fill in all required information?
Hi mam can you share the worksheet so that I can try it myself. It will help alot
Do you have any tutorials for Campus Recruitment as well?
Candidate details sheet doesnt contain candidate name, how many candidates were sourced position wise which are important data as far a recruitment tracker is concerned. Appreciate if you have a sheet with those details as well and how we can bring it to the dashboard as a metric
if i will do this in PowerBI than how can i make relationship between these table . Please reply
Nice video...
How you got Role A as 20 and Role B as 30
Hi, you have very neatly explained in this video. Can we do this same using power bi?
Thanks ... yes you can... I will be making a video on power bi as well
@@bitbycuriosity8925 I need your help on the same for the data set available with me. can we connect?
I want to use it for a research paper
@bit by curiosity, saanvi jakati is my another mail id
Hi sure will try to help you may drop me an email on bitbycuriosity@gmail.com
Can u help us getting one rect dahsboatd for us
Are you from Trinidad 🇹🇹? You sound Trinindian.
I am not able to calculate average time to fill as it says it cannot be calculated as its not supported calculation for text data types
Please help how to resolve
Hi, will adding this data to Data Model, the excel (Pivot) throw an error of "We can't summarize this field with Average because it's not a supported calculation for Text data types."
Please help!!!
Even I am also facing the same issue. Can somebody please help
awaiting your response
Same error can you please help
Hi, it is due to the fact that you are using the formula "ISBLANK" => is recognized as "Text" in Power Pivot. You can't calculate the average of a Text
@@dhawal481 Replace " " in the formula ISBLANK with 0. All blanks should become a zero (0). In the pivot-table only check the closed positions (Uncheck blanks and yes), then refresh the pivottable. The average of only the closed positions will be calculated
Fast to understand
Thank you so much for sharing the useful information.
The recruitment process can be streamlined and simplified by the use of some suitable tools like the Recruitment Management System "HireME cloud". HireMe is the most trusted and useful recruitment management software, currently used by more than 100 companies.