Hi, hello. My name is Elsie Dama, and we're here to welcome you to the Lesson 11, which is Get Over Yourself. This is going to be done by the teens class. And for the mission, we'll have Elsie Ciro. For the orchestra, we're going to have Amy Andagalu, sorry, Elsie Dama. We're going to also have Marinya Numba. For the panel discussion, we're going to have Elsie Dama, Amara Tatiana, Bilmi Tcheka, and Tichayu Jino Kumo. And for the orchestra, they're going to be playing song number 529. I do hope you have a nice time and that you learn some things at Jesus Feet. Thank you. Hi, my name is Elsie Ciro, and I'll be doing this week's mission. The title of the mission is called Baptized Again, and it's from Portugal. It's about a young lady named Salome. So Salome was baptized out of the Seventh Day Adventist Church, but didn't find the church interesting. She didn't seem quite right about her church teachings, and as Salome grew older, she stopped going to church altogether. She didn't want anything to do with the church, but then she still believed in God and asked Him for His guidance. Salome began to think a lot about God. When her four-year-old grandson, Jorge, was enrolled in Seventh Day Adventist School in Portuguese island of Madeira. The island is located on an hour away by plain south of Portugal and off Africa's west coasts. The family had entrepreneurs who said, Jorge, to their Adventist School. Instead, the boy's mother took him to a public preschool for several days, where Jorge cried and cried, and no one could understand why Jorge was crying. His parents didn't know what to do, and Salome also didn't know what to do. Then the boy and his parents travelled to Funchal, the biggest city on the island, to carry out some errands. As the family went about their business, they noticed a neat skull surrounded by a fence with a metal gate. They went inside to take a closer look. The moment Jorge stepped onto the school grounds, he exclaimed, he loved the school. He then saw other children playing the playground and decided that he did not want to go back to the other school. He looked up at his mother and father with great determination and his tiny face. Stumping his feet on the ground, he yelled, I don't want to go to the other school. So it was Jorge that was enrolled in the Seventh Day Adventist School. The teachers allowed Salome to accompany her grandson to classes for the first two months to make sure that he adjusted well to the school. Salome liked her school. She liked the teachers. It was clear that Jorge also liked the school. He never cried or asked to go home. The pastor of an Adventist Church that met on the second floor of the school invited Salome to take part in Bible studies. I don't mind having Bible studies, Salome replied. I can't go to the Bible studies anytime, but I'm not going to be baptized again. No one is going to put water on my head again. She didn't go to the Bible studies, but after some time, Jorge and his parents started attending prayer meetings every Wednesday at the school. Then the parents started to take Bible studies. Seeing that they were studying the Bible, Salome agreed to the Bible studies. At the end of the Bible studies, Anna, a Seventh Day Adventist who was doing the Bible studies, asked if she wanted to pray again. Salome shook her head. It was her first Bible study, and she had mixed feelings about what was going on. Anna suggested that they sing a song instead, and Salome agreed. She opened her hymnal and held it out so she and Salome could sing together. Anna began to sing, I am the porter, you are the clay. Immediately Salome burst into tears. She tried, but she couldn't sing a single word. Surprised, Anna stopped singing. She got up and gave Salome a big hug. Don't cry, she said. The song was very meaningful for Salome. She explained that the song, which Anna had chosen at random, had been played at the memorial service of her mother. Anna also began to weep. The two women wept together. Salome continued the Bible studies with Anna. She learned about Jesus' example of baptism by immersion. She saw that the Bible did not teach infant baptism. She also went to prayer meetings with her grandson and his parents. Then his parents declared that they planned to get baptized. Two weeks before the baptism, Salome called Anna. I want to speak with the pastor, she said. Anna guessed what was on Salome's mind. Do you want to do what I think that you want to do? She asked. The pastor was surprised that Salome wanted to be baptized after being so adamant about not needing to be baptized again. She suggested that she take her time in making a decision. Five months later, Salome gave her heart to Jesus in baptism. Today, Salome serves as in the woman ministry's department at her Adventist Church.  Jorge was baptized at the age of 12. And to this day, Salome does not understand why Jorge cried at the public preschool and was happy at the Adventist school. But one thing is clear. Because Jorge went to the Adventist school, her life has changed completely. The Holy Spirit touched my heart, Salome said. That was when she knew that I had to be baptized. This quarter, Statenza, by offering will go to building schools in Portugal. On my far right, I have Elsie. Next to me is Tatiana. And on my left, I have Bill. We'll begin with a word of prayer from Tatiana. That's by our heads for a word of prayer. How can in Heavenly Father, Lord, you want to thank you for this beautiful day that you have granted unto us? Now as we may start our connoisseur lesson connection, please may you get us and protect us. I would also like to pray for all those who are on the other side of the screen, Lord, that they may also understand the lesson and also enjoy. And this is all we pray in just mighty name. Amen. So today, we are going to be looking at lesson 11, the story of the children of Israel before they enter the land of Canaan. And Elsie will take us through into the story and out of the story. Elsie. Moses. Okay. The Lord commanded Moses to send some men to go and explore the land of the Canaanites, which he had promised to give to the Israelites. And he told Moses that from each tribe, they should choose one man to go and represent. So Moses did as God had commanded him and he sent out men from the desert of Paran. Now, when Moses was sending this man out, he told them that they should go out through Negev and on into the hill countryside. They were to look at what the countryside, what the land was like, what the people were like there, were they strong or were they weak, were they few or were they many? Was the land good or was it bad? So when the men came back, they came back with reports and they reported what they had seen before Moses and Aaron and the whole Israelite community at Kadesh in the desert of Paran. And they also brought fruits from that land which they showed to the whole community. Now, they gave Moses this account. The land is indeed flowing with milk and honey, but the people there are too strong and the cities are very large and heavily fortified. But Kaleb, son of Jeffhune, who was one of the men who had gone to explore, said that we should certainly go up and take possession of the land because God has promised us victory and we can certainly do it. But the men who had gone with Kaleb were adamant and they said, no, we cannot, we cannot attack those men because they are much stronger than we are. And so this meant that the whole night, the whole community of the Israelites raised the voices and wept aloud and they grumbled against Moses and Aaron and the entire assembly and they were asking them, why did you let us to come here out of Egypt to come and die in the wilderness? You'd have just let us die in Egypt or in the wilderness. Why did you come to let us suffer here? Then Moses and Aaron, they fell on their faces before the assembly and the whole Israelite community. Joshua, son of Nan and Kaleb, son of Jeffhune, tore their clothes and they were wailing and they were asking themselves before the Israelites, why do you fear those people? They said that the land is indeed certainly good. It is flowing with milk and honey. But if we are afraid, if we do not rebel, God will certainly give us victory over these people because God is with us. They do not have protection. God is our main protection and we should just go forward and conquer and conquer the cities because God will always grant us victory. Great. Let us go to the into, well, out of the story and answer a few questions from the story. Elsie, please take us through the first question. Last question is why do you think God wanted them to explore? Why do you think he wanted them to send men to go and see and then come and tell the Israelites? I mean, he's omnipresent, right? He's everywhere. He can see and then he can tell the Israelites directly. But why did he have to send Moses to send men to go and then come back? Why do you think he did that? Bill, what do you think? So for me, what I think is that God decided to send these guys out of the wilderness to look over the land of Canaan so that they can be able to see what awaits them there because there are times in life where we feel like it's better if we find out what's waiting for us, what's ahead of us. Such can be able to prepare adequately for it. So I think that it was good enough for God to tell Moses to send these people out so that they can see what's in store for them in the land of Canaan. Amen. I also think God sent them to test them. What do you guys think? Maybe he was trying to test whether they believed in him. So he decided to send them out and see their reaction. Another question that is there, Elsie, is why do you think Caleb and Joshua were not terrified? It's a good question, right? Tatiana, what do you think? I think the reason why they were not scared was because they knew they serve a living God and they knew that he was there and he knew that in whatever that all the Israelites did, he knew all their answers. And Joshua and Caleb were also strong in faith. Yeah. I discovered something so interesting when I was reading the lesson. Caleb was from the tribe of Judah. And we all know that Christ is called the lion from the tribe of Judah. And we know lions to be very bold animals. So part of the reason Caleb I think wasn't terrified was because of the tribe he came from. The Bible says in the book of Proverbs 28 verse 1 that the righteous are as bold as lions but the wicked flee when no one pursues. Whenever you're righteous, you have boldness that comes with that. One theologian called Oswald Chambers said, when you fear God, you fear nothing else. Or when you do not fear God, you have a fear of everything else. And then secondly, in the case of Joshua, we read about Joshua in the early books of Moses that Joshua was always in the tent with Moses, right? He was always in the tent with Moses. And in Proverbs, we also read that the companion of the wise will be wise but the companion of fools will be destroyed. So some of the courage that Joshua had, he got from spending so much time with Moses. And then lastly, Elsie, there's an application question at the end of the Out of the Story question. Please read it for us. Oh, which life lessons can you apply when you are faced with frightening situations in life out of this story? From this story, what can you pick that can help you to face difficult situations that you might think are impossible? So to answer this question, I would like to take Joshua and Caleb from the story as an example. We can see how they were not scared at all and how they were willing to conquer the land. And I think this is because of a strong faith in God. So if we have a strong faith in God, then we'll be scared of nothing because we know automatically that God is there to guide us and to take care of us and to see us through our situations. So I think what I can learn from this, so what I can learn from this passage is that God is there for us and that if we just learn to trust Him and let Him take over our lives, it's okay because we won't be scared anymore. Tatiana, any lessons from the story? A lesson that I think we can learn from this story. In life, we always have to have faith and faith without action is dead. So in life, we should also have strong faith in God because with God in our lives, anything is possible. Amen. One lesson I learned from the story is that when we are under God's wings, when we are under His protection, we have no cause for fear at all because God will always be there to protect us like an eagle protects her children under her wings. So it is very important for us to always find ourselves, find a place under the wings of God that He may protect us and guide us and be our shield in times when we feel afraid. I also noticed something very interesting that I will share with you even as we prepare for a special item we've prepared for you today. God's will is not always in the majority. Alright, Calib and Joshua were only two but the other spies who had a bad report were ten. So in your life, never feel the pressure to be part of the crowd. That is why I love this hymn so much under His wings. I am safely abiding though the night deepens and temp tests are wild. Still I can trust Him. I know He will keep me. He has redeemed me and I am His child. Back to our lesson. The key text is from the book of Numbers 14 verse 8 and 9 and it says, If the Lord is pleased with us, He will lead us into the land, a land flowing with milk and honey and will give it to us. Only do not rebel against the Lord and do not be afraid. Their protection is gone but the Lord is with us. Tatiana, could you take us through the flashlight of lesson 11? Yes. So the flashlight says, Hope and courage gave place to cowardly despair as the spies uttered the sentiments of their unbelieving hearts which were filled with discouragement prompted by Satan. Their unbelief cast a gloomy shadow over the congregation and the mighty power of God so often manifested in behalf of the chosen nation was forgotten. The people did not wait to reflect. They did not reason that He who had brought them thus far would certainly give them the land. As we can say from this that fear and courage does not occupy the same space and in the context that says the unbelief cast a gloomy shadow over the congregation nothing spreads like fear. Amen. Nothing spreads like fear indeed. Fear is a very contagious emotion and whenever you are around people that are fearful you might catch that flu from them. I'd like to welcome Finley who has just joined us. Finley, could you take us through the Sabbath section? Good morning everyone and so on the Sabbath part we're going to read Isaiah chapter 41 verse 10 and it says, Fear not for I am with you be not dismayed for I am your God I will strengthen you yes I will help you I will uphold you with my ratios at right hand. So the what do you think section of the lesson ask some ask some questions about fear as you answer those questions think about fear in your life. So in the what do you think section it says that what scares you? Write A for agree or D for disagree next to each of the following statements. So the first statement is I think of myself as a brief person they agree because back in 2021 I was given a someone need to present to the whole church. The second statement is I'm scared of a lot of things I disagree yes they are some things I'm scared about but not lots of things. Finley how about we ask Elsie what she thinks about the second one do you agree or disagree are you afraid of a lot of things? Yes I'm terrified of a lot of things I remember and I also wanted to add something on the flashlight I remember in school one time okay in school the last week before we closed it's normally we don't do anything because we're done with exams and we're just waiting for results so go to class but just don't come and remember this time I was asleep and there was someone who's telling a horror story at the front of the class then people started screaming and then I wake up I don't know why they're screaming but then I'm also screaming so fear does spread when I see someone else who's afraid I'll just be afraid even though I don't know what's going on so from that I know I'm afraid of a lot of things be it people, crowds I don't like snakes particularly I'm afraid of heights I'm a scared cat really I'm afraid of a lot of things yeah then you could read the next one maybe we'll find out what Bill thinks so the third statement is I think I handled fear well I agree by having more faith in God and also praying to him the first statement is fear holds me back from doing things I'd like to do I agree because fear will not let you do things the way you want Bill does fear hold you back from doing things you want to do? for me yes, fear holds me back because there are some instances I mean there are times where I'm faced with fear like one time I had to make a presentation in front of this church and the thing is I was scared because like it was during VBS and around that time the church is usually very packed so the thing is like looking at so many faces that you're not necessarily familiar with can be very difficult to do so there are times where I kept on bargaining and negotiating with the person who gave me the role and I kept on trying to ask them to prevent me from doing this but then I as I went on stage I managed to find out that everything was okay and it was all fine because God had given me the courage but yes it did hold me back in terms of preparation for this presentation because I kept on being worried about the people or I kept on being worried about what if I started on stage what do people think stuff like that so it did hold me back in terms of preparation for this presentation but then I realized that when I went there to present myself I found out that I was okay and that God had given me the courage Amen, Tatiana what is your worst fear? that's a good one my worst fear is actually that I fear God that's my number one fear how about you Finley what's your worst fear? my worst fear is the fear of the unknown fear of the unknown? yeah wow spooky how about you Bill? I fear snakes and nuts yeah Elsie? I fear darkness I don't like darkness you're not a night person I even when I sleep I have to put myself in a box and put myself in a bright situation like in my head so that I can sleep because I don't like darkness even in school I have to sleep before the lights go off because I can't survive in darkness I'll just pee on myself or something oh in our story we read something very interesting in the book of Numbers 13 and verse 33 I'll read in your hearing there we saw the giants the descendants of Anak came from the giants and we were like grasshoppers in our old sight and so we were in their sight so when these guys walked into the land of Canaan the giants were so tall that in their sight they looked like grasshoppers when I was young I used to trap grasshoppers and put them in jars and play with them I can imagine the catternites doing that to the Israelites you know they were that tiny but even though we all have fears if we read in the book of Isaiah 40 maybe else you can read for us Isaiah 40 we find out that before God we have no reason to fear Isaiah 40 and verse 22 so Isaiah 40 verse 22 says it is he who sits above the circle of the earth and its inhabitants are like grasshoppers who stretches out the heavens like a curtain who spreads them like a tent to dwell in so here we see that even though the Israelites looked like grasshoppers the eyes of the Canaanites to God we all look like grasshoppers have you ever been on a tall building that was so tall when you got to the top people looked like dots from up there can you imagine how we look to God from up there in the sky? so whatever you fear always remember that God is bigger God is greater and to him we're all like grasshoppers then maybe you can continue so the next statement is I'm afraid of new or unfamiliar situations I agree because just like I've said the few of them are known the next statement is trusting God helps me when I'm scared this I agree with it right so Tatiana maybe you can take us through Tuesday can read the text Tuesday first text is Timothy second Timothy fasts for seven and it says fear God for God has not given us a spirit of fear but of power and of love and of a sound mind I think the scripture speaks for itself and for God has not given us a spirit of fear but of God but of power and of love God has given us the the power and fear is not of God yeah fear is not of God guys fear does not come naturally to us it is something we learn and it is something of course we can unlearn it is something we can overcome what did we have on Thursday in terms of the texts? I mean Thursday we have fast Corinthians 16 verse 13 and it says be on your guard stand firm in the faith be courageous and be strong here we see that faith is always tested faith is always tested you can talk big but eventually God is going to bring a test to test whether you actually believe him in the book of Luke 12 from verse 4 to 5 we read something very interesting about fearing the right thing fearing the right thing maybe Bill you can read for us Luke 12 from verse 4 to 5 because sometimes our fears can be unreasonable don't you think? I mean there are people who are afraid of the number 13 for example which is kind of strange to be afraid of a number people are afraid of such strange things our fears can be so unreasonable but in that text that Bill is about to read we find what we are supposed to be afraid of Bill Luke 12 from verse 4 to 5 so Luke chapter 12 from verse 4 to 5 and says dear friends do not be afraid of those who want to kill your body they cannot do any more to you after that but I'll tell you whom to fear fear God who has the power to kill you and then throw you into hell yes he's the one to fear right so here we see it's only reasonable to fear God because God is above all God is all powerful and God has the ability either to take you to heaven or to take you to hell you know every other fear is unreasonable because everyone else is mortal everyone else is born and everyone else has a day that they will that they will die that they will die Finley let's go back to the punchlines please read us the punchline from Deuteronomy 31 verse 6 Deuteronomy 31 verse 6 says be strong and courageous do not be afraid or terrified because of them for the Lord your God goes with you he will never leave you nor forsake you Amen here God is speaking to Moses and he tells him to be strong and courageous because God is going to go with him wheresoever he goes and we have a similar verse in the book of Joshua chapter 1 and I'll read it in your hearing from verse 8 Joshua 1 and verse 8 the Bible says this book of the law shall not depart from your mouth but you shall meditate in it day and night that you may observe to do according to all that is written in it for then you will make your way prosperous and then you will have good success this is very important guys faith is neutral whatever you feed it grows alright whatever you feed your faith will grow you can have faith for everything it is important to cultivate a faith in God by meditating on scripture because it will make you bolder and bolder and bolder so Joshua was being told by God here this book of the law shall be in your mouth and you shall meditate upon it day and night day and night you know many times you watch a horror film and you're not you're afraid of going to bed right you think someone is going to come and take you in your sleep that is because that's what you fed your spirit imagine if rather than watch a horror film you read your Bible would you still be afraid to go to sleep? it's unlikely would you still be afraid to switch off the light? it's unlikely but if you study the word of God you feed your faith in God and it enables you to face very scary situations in life how do you guys handle fear? Elsie I'm going to speak on two ways I handle fear that is before we had this lesson and after now how we'll be handling fear from now onwards before how I'd handle fear I wouldn't even handle it it would handle me like it it overcomes me because I will if I'm supposed to do something and it's something maybe before a crowd that fear in me will tell me that I can't do it and it will convince me and make abnormal situations in my head because I believe I can't do it and I won't do it because of that fear but since now I have gone through this lesson I think from now onwards I'll be handling fear by taking a moment to reflect on what God has done for me before I mean 15 years of my life there's so much that God has done for me that this one thing that I'm fearing is it's nothing he'll just he'll do it for me like he's done for me for other things and I'll take a moment to reflect and absorb that into my head and then ask God to help me and hold my hand through whatever it is that I'm about to do because he is my father right he's on who he's formed this whole earth he's done all these marvelous things why am I not trusting in him so I will I'll trust him more from now on and I'll close the lights yes Amen Tatiana how do you handle fear? Personally handling fear for me was very hard and I don't think I handle it but I'd just run away from the fear and and it would also overcome me but I think after this lesson how I'm going to handle it is let's come back to the story there the name of the theme of the story is get over yourself so I feel like in this context I'd literally get over myself and have that at the back of my mind God is bigger than the fear and that and that's going to help me overcome Bill how do you handle fear? So for me I have two ways in terms of going about it so I do what people usually advise other people to do like take deep breaths like you just breathe in hold it for like three, four, five seconds then I let it all out and then another way is that if I'm fearful in a situation that I know I cannot change that I have to indulge in this anyway what I do is I'll close my eyes count down five, four, three, two, one then go straight into it so that's like I'll be able to have the courage to do it and after this lesson we'll be fight out to this lesson I like what the last line of the third stanza in the song under his wing says the last line says resting in Jesus I'm safe evermore so what I learn is that when we rest in Jesus when we let Jesus take control we find out that everything falls into place I remember reading this book by Ben Carson Think Big and it says that all we should do we do our best and let God do the rest so yeah that's how I'm going to be tackling fear from now on yeah Amen Bill Finley how about you how do you handle fear? so I'll handle fear by trusting God and in real life situation you can ask people have gone through the same situation how you go about it that's right that's a good one as well because in life there's always someone who's gone through what you're about to go through or what you're facing like we saw with Joshua these were the first giants that Joshua was facing but Moses in the book of Deuteronomy killed a giant called King Og whose bed was about 13 feet tall right so you can always speak to people who have had an experience similar to yours but I love something that Tatiana said and she talks back to the title of the lesson which is get over yourself for every one glance at yourself the Puritans used to say take 10 glances at Christ for every one glance at yourself take 10 glances at who? at Jesus Christ so that it can dissuade you from your fear so that it can shift you from your fear for every one glance at yourself take 10 glances at Christ Hunters have this saying that when you encounter a wolf in the forest hold his gaze what do you guys think about that? would you hold the gaze or run? Bill? to be honest with you I'd run yeah cause holding a gaze against a wolf that's tough cause like a wolf is a wolf you know it's scary it's big and yeah I would try run away yeah how about you Tatiana would you hold the gaze of a wolf if you encountered one? no I wouldn't I'd personally also run but then come to think of it when you run wouldn't he chase you? exactly exactly so one thing I've learnt about fear is fear is a mental thing it happens in the mind some people have said that fear is negative faith is faith in the devil the same way hope is faith in God right? when David says in Psalm 33 even though I walk through the valley of the shadow of death notice he says shadow it's not really real but your fear gives that shadow form so it's always important to face down your fears some have said when a dog runs to you call it instead of running you know play a mind game on the dog so that you you mess with it and it wouldn't be as sure about chasing you as it was maybe we can read a few more punchlines and then we'll close with a prayer Bill I'd like you to read the punchline from 1st John 4 let's say 18 1st John 4 18 and it says there is no fear in love but perfect love drives out fear because fear has to do with punishment the one who fears is not made of is not made perfect in love Amen there is no fear in love one of the most popular sentiments in our time is love don't you think? in fact on Instagram what do you do all day? you just love stuff right? you just tap away and love stuff but we have really misunderstood what love really means the first thing we've been told by the Apostle John here is there is no fear in love so whenever you want to know whether there is real love in a situation how do you know? am I afraid? am I? comfortable you know? if people make you fearful then there's no love there but if you feel comfortable to be yourself then it is quite likely that there is love that is present in that situation and then lastly Elsie you can read us the further insight came to God's love and distrust His promises we dishonour Him and grieve His Holy Spirit let us keep fresh in our memory all the tender masses that God has shown us the tears He has wiped away the pains He has soothed the anxieties removed the fears dispelled the ones supplied the blessings bestowed thus strengthening ourselves for all that is before us through the remainder of our pilgrimage amen, amen I love what she says there let us keep fresh in our memory fresh in our memory all the tender masses that God has shown us one guy in his house he has a prayer room and on one side of the wall he has all his prayer requests written out in sticky notes and on the other side of his wall he has all the answered prayers so every morning when he goes to pray he gets to read what God has has done and in that way what God has done is fresh in his memory, amen that's something we should practice you never want to forget how good God has been because it will always lead you to fear and then the first part of it is also very beautiful when we seem to doubt God's love and distrust his promises we dishonor him and grieve his Holy Spirit it is better to be trusted than to be loved would you agree? it is better to be trusted than to be loved would you agree? yeah? alright that has been lesson 11 get over yourself with the teens connerstone connections I will ask Bill to end with a prayer sure, let's pray Heavenly Father thank you for this day thank you for the gift of life we thank you for your guidance and protection so far throughout the day and you pray that you take care of us and you pray that you be with us pray that you sustain us and cover us with your precious blood Heavenly Father I have learnt a lesson about handling fear and you know that it's you who keeps us away from our fears please help us to develop a strong connection with you so that you can be able to face our fears and to tackle fears in our daily lives pray that you continue to take care of all of us and be with us in Jesus name I pray amen


Hello everyone, I am Sanjay Gupta. I welcome you on Sanjay Gupta Tech School. So this is day 9 of this Salesforce Learning Bootcamp. And I hope everybody is enjoying all the sessions and you are learning Salesforce in depth. So we'll wait for a couple of minutes so that more folks can join. And then I will be starting today's session. Thank you Dori for appreciating my efforts and hello and good evening to everyone. Good morning to Western Zone US and if someone joined from any other country. So good evening, good afternoon, good morning. So I can see Kuldeep is asking a question. So Kuldeep just go ahead till the time we are waiting for more folks. You can type your question. So today's topics are like we will be discussing about how to create report types. And we will be creating reports on custom objects. Then I will demo you how we can create joint report and how to use bucket fields. Okay, so Kuldeep is asking there was question in the exercise like where case status is open. So status is open, open option was not available. So maybe it was, I think it is new, I guess. If I take you to the setup. So let's check the status field. So if I search for case object and if I go to fields and relationships. So here we can check the status field. Okay, it is new. So I'm just updating. So good catch Kuldeep. Thank you for letting me know. So I am going to modify this. So I just modified it to new, right? So those who are not able to solve it because of this issue. So now it is modified and you will be able to solve. And Sunil is saying like open is a checkbox so you can use that as well.  So sometimes it will happen in the business requirement as well. So you can just apply your common sense as well.  Okay, so let's come to today's session. So these are the topics and this is about me. So you just need to know with whom you are interacting. So in every session in the beginning I show this slide to you. Then these are virtual learning best practices that everybody needs to follow so that you can just prepare yourself well. So like this week we have three sessions based on reports and dashboard. So all the sessions are important. And I think maybe a few folks are for the first time understanding reports and dashboard and depth. And along with that you are having practice exercise. So do that so that you can build strong foundation. And this is our session timing. So today also I will be first explaining all the topics and then I will take question and answers. And because of your lots of questions, I just mentioned these three things where you can ask questions. So you can comment on YouTube videos. Many people are doing that and I'm trying to reply on their doubts. And created Telegram group as well where we can interact and Instagram. And please subscribe, follow and share this information with others as well so that they can build their Salesforce career. And soon we will be starting. So maybe like in the beginning of next month or maybe end of this month. We will be starting development. Not actually this month. I think next month we will be starting. So till the time if you don't have any knowledge about programming. So you can just explore some videos of C programming Java and HTML and CSS. So that you have something in your mind while understanding programming. So this is important. And we are right now in week three. So we are studying reports and dashboard. And today is day two for that. And in total it is day nine. And let's come to the topic report type. So first we need to understand what report type is. Okay, so yesterday I showed you different report formats. So we have total four report formats in which we have tabular. We have a summary. We have matrix and we have joint reports. Right. But before creating any format of report. You just need to select particular report type. Right. So from where you select report type. So whenever you click on new report button. So a pop up appears and you select particular report type. Right. So basis on that report type you will be able to create the report. So if I take you to the org again. So here you can see we have this new report button. And if you click on this button. So here for creation of report you need to select a report type. And we have already available lots of standard report types. Right. Now if I try to search for custom object. So you will see there is no report type available for student. If I search for instructor there is no report type available. So it means for custom objects report types you just need to create. Right. So first we will understand report type in detail. And then I will show you how you can create reports for custom objects. Okay. So basically a report type is like a template for reports. Report type determines which fields and records are available for use when one is creating a report. So basis on report type you will be able to identify the fields. Those will be available in the report. Also the records. So for example if you are creating report type for account object. So you can decide like you want to include related records related object records or not. So while creating report type we have option to select more than one objects as well. So yesterday someone asked a question like how many objects we can include while we create any report type. So the answer to this question will be four. So we can include four objects while creating report type. So we will see how we can do that. Third point says this is based on relationships between a primary object and its related objects. Right. So if you have any look up or master detail relationship implemented. So basis on that you can create report type. If there is no relationship involved then you can just select that particular object for report creation. So for example with accounts like accounts with contact report type. Account as primary and contact will be working as a related object. Okay. So you need to select primary and then secondary objects will be the related ones. And reports display those records that meet the criteria defined in the report type. So these are some important things that you need to know before creation of report type. So if you have report type created then only you will be able to create particular report. First you need to select report type and then you need to select format of report. Right. So we have four formats. Anyone you can choose on which format you want to create your report. Then while creating reports so you will see these things. So you can select any one option like primary object with related object. And second option says primary object with or without related object. So what does it mean? If you select with it means only those records will be available in the report where parent record is having any child record. It should be there. So it is must condition like parent is having child then only those parent records will be available in the report. And second option says with or without. So for example if you are creating a report type for account and contact. So in second case all accounts will be there and those accounts will also be there where some related contacts are there. So both kind of like zero contact or more contacts are available then those accounts will be available for reporting. But in first case only those accounts will be available for reporting where contact is available if we take account and contact example. So this is very important to understand. And now let's create report on custom report type. So before creation of report on custom object. So we just need to create report type first. Okay. So first I will be showing you how you can create report type and then we will be creating reports basis on that report type. And I already showed you we don't have any report type for a student and instructor object. Right. And before creation of report type you need to do one more thing. So from here you need to go to object manager and you need to search for your objects. So we are first taking student as an example. So in the details you can see we have this option enable reports. So if you want to enable this option so just click on edit. So if you enable this option. So this is optional feature which says allow reports. So if this is enabled then only you will be able to create reports for this object. So I just enabled this. So I hope now you understood like initially why we didn't enable these options. So while explaining activities I enabled this while explaining track field history I enabled this and now with reports I'm enabling this. Now you have knowledge of all three options. So now if you create any custom objects so you can decide whether to enable them initially or not. And as a good practice whenever you are creating any objects so just enable all these three because these are basic functionalities those are required for each object. So now I'm just clicking on home and here I'm searching for report type. So here you can see under analytics you will see reports and dashboard and here report types option is available. So you just need to click on it. Right. So here we have this option with custom report types you can enable users to create reports from the predefined object object relationships and field that you specify. Right. So just click on this button new custom report type. Click on that button. So you will see these options. Right. So first of all you need to select the primary object. So right now I am going to select primary object as student. Okay. And here I am going to type report type label. So I'm typing report on student. So this is my report type label. Then this is report type name. Now here compulsorily you need to define the description. So report type to create report on student object. So you can type any description that is relevant to your report type and then store in category. What is what it is. So if you click on new report. So here you see these categories. Right. So there are lots of categories already created so you can pick anyone and in that category you can just store your report type. So from here right now I am selecting other reports because this is student custom object report. It is not related to with any category. So you can just select other reports. Right. So this way I just provided all the information. Then I'm clicking on next. So when I click on next to here you will see this option. So just read it carefully. This report type will generate reports about student. So you may define which related records from other objects are returned in report results by choosing a relationship to another object. Now my student is primary object. Right. So it might be having some related child object. So if I click here. So this option will be available and from here you can choose any related object. Right. So we have STD classes. We have feed student duplicate record item activity. So these are child. Okay. So if you remember we created a junction object. So if I show you this object model. So we just created a STD class object which is having master detail to class and master detail to students. So this is child for student. Right. So here while creating report type this is available. Both the options. So first says each a record must have at least one related be record. So this I already showed you in the slides. If you select second option. So it says a records may or may not have related be records. So here a means student object and B means STD classes. If you want to pick anyone that is related to this STD classes object. So you could just click and here we have C. To see relationship. Right. So be records may or may not have related C. So this is third option. Here we have only this duplicate record items. It doesn't make any sense here. So I'm not going on the third level. I'm just selecting two levels. Okay. And I'm selecting the second option a records may or may not have related be records. So it means all student records will be available in the reports. Right. Now I'm just clicking on save. So this way you can see we created a report type. And it is also showing like for students. We will be having 28 fields and for STD classes, we will be having seven fields. Now if you want to add or remove fields, so you can just click on added layout. And here you can see all the fields are available. So we have this legend through this. You can understand not in page layout used in page layout selected checked by default added via lookup. Right. So here all available fields will be displayed. And if you want to use any field, so you just need to drag and drop. So by default all are available. If I want to remove anyone, I can just drag and drop it here. Right. But initially all the fields will be available here. If any field is not available. So you can just drag and drop it from here. Okay. So this way you can just like pick particular fields that you want to display. And here we have added properties button. So please select at least one item from within the page layout section. Okay. Okay. So this is for changing the property. So this is not required at the moment. So just you need to remember like if you want to add any field that is not added for report creation. So at right hand side, you will see all available fields. And if it is not added, you can just click drag and drop it to here. If field is available here, then only you will be able to use it in the report. Okay. And here also added delete buttons are available. So you can just add it and delete the section labeling. Okay. So this is about how we can add and remove and you can just read this description which is available here to understand more about it. Right. So now I'm just clicking on save. So this is all about how we can create report type. Right. So let's go to each and every step to create report type. Now let's create a report on this. So here I created a exercise for you, which is for day nine. And here you can see we need to create custom report type for following objects. So student we already created right now in the session instructor. I think you can just follow the same steps. Then class and student. So class will be primary and student will be secondary. One more class will be primary and student instructor will be secondary. And what you can do while creating primary class secondary student. So you can have third one as well. So primary and here you can write secondary and third you can pick STD class. So this D example will show you like how we can pick three objects together to create a report type. Okay. So I think it will be easy. You just need to select the objects and it will be created. Now I'm going to create this tabular report. Okay. So create a tabular report on student object and select a few fields to show and store the report and tabular report folder. Okay. And like now if you have created report type now, whatever type of report you want to create all the steps will be same as we saw yesterday on the standard object. So once you create a report type after that, no matter your report you are you are using custom report type or standard report type, all the steps will be same for each type of each format of report. Okay. So I'm going to create a tabular report on student object now. So here I'm going to refresh this page so that we can have that newly created report type available. So I'm just going to click on this new report now. And if I click on new reports, so in this other reports, you will see that custom report type available. So here it is report on student. Right. Now one more thing you will focus. I just enabled that checkbox. If I take you to the object manager and if I search for student. So I clicked on that. This is available reports option. So you can see some standard report types are also available student and students with student then student history. So these are created by default. And I already showed you how you can create your custom report type. So this custom report type we created it will be having two objects data student and STD class. Whereas this will be having only student related information. So here you can see objects using report type owner student user and role. This is standard one. Now if I click on this one, so here you can see it is custom and it is showing objects used in report type student and STD class. Okay. So this way I hope you understood if standard object report type is there still if your requirement is not fulfilled. So for that object, you can create custom report type as well. And this goes with standard as well as custom objects for both you can create custom report types. Okay. So now I'm selecting the one which we created. So clicking on start report. So this way you can see tabular report is created and here we are viewing two columns. So here you can just add other information as well like you can add email. Then if you want to add name, so I can just search for name. So name we can add. Then if you want to add age, so you can. So this way whatever field you want to add you can select. Right. And I showed you yesterday like if this button is enabled update preview automatically. So you will be able to see the preview available here. So this way student ID, STD class name, email name, age, record type, these fields are available. And if you want to run it, so just click on run. And here you can see the data and ages by default added because it is numeric field. So total is available. If you add it go here. So you can apply filters as well. So here we have a show me option. So you can select my student, my team student, all students. So generally we prefer all students. And in this session, I will be explaining what is filtered by scope as well. So after this explanation, I will pick that. So I'm just applying it, then selecting all time and apply. Right. So this way you can create your tabular report. And if you want to apply custom filter, so from here you can select like if you want to apply filter, let's say. You want record type equals fresher. You just want to see only those records where record type is fresher. So this way you can apply custom filter. Right. So here everything is clear. Things are same like you can just see the report which I created on this custom report type. It is same as we created yesterday on standard report types. So all the features are same. So you need to create custom report type and then you can just create reports. And if you want to save it, just click on save button. So report. So I am just storing it as tab student tabular report. And we yesterday created tabular report folder. So I'm going to select that only. So I'm selecting tabular report and saving it. So yesterday someone asked like why I created different folders with naming convention. Is it in the projects as well? So the answer will be no. In projects you will be creating folders as per the business requirement. Right. Okay. So I think this you understood. Now this is your assignment like you will be creating instructor report type. Then you can create a tabular report on instructor. So I didn't add it. So let me just add that as well. So for practice purpose, you can do that created tabular report on instructor object. And you can just select few fields and store it in tabular report folder. Now moving forward, we have summary report option. So what you can do, you can just select that report type which we created. And you need to summarize it based on Salesforce role field and select few fields. Then store it in summary report folder and create a report chatter chart as well. Okay. So I'm going to explain this requirement. And yesterday there was one question. Like can we use this tabular report to create summary report? So my answer will be yes. So if you have created tabular report, so what you can do, you can just save as this tabular report and new report like cloned report will be created. So tabular report you will be having as is and your cloned report will be available. And what you can do, you can just modify that cloned report so that it can be used as a summary report. Right. So now what I'm going to do, this is my student tabular report here. You can see this button is available just beside save. So if I click on this button, so I will find this option which is save as. So I just need to click on save as. So it will give me this pop up and here you can see copy of student tabular report. So I'm writing student summary report and I'm going to save it in summary report folder. So I selected it and I'm saving it. Right. So that report is cloned. Now we just need to verify whether we have both the reports like here you can see summary report is available. We need to check whether a tabular report is available or not. So just click on reports tab and here you can see a student summary report is available in summary report folder and student tabular report is available in tabular report folder. So this way both are available and now if you want to work on tabular, you can open it. If you want to work on summary, you can open it. And in summary report, we just need to apply a grouping. So I'm just removing a filter from here and here I am selecting Salesforce role. So you can see grouping is done. So basis on Salesforce role, you can see data is categorized. So five records are there where Salesforce role is not populated. One is related to admin two are related to developer and one is related to associate. So this way we are easily able to create summary report. Now I can save it. And if I show you tabular one, so you will be having that report as tabular. So here you can see it is having the same filter as we created filter is available here. So tabular is working separately and your mid summary report is working separately. So this way you can clone reports and you can modify as per your requirement. And if you want to add chart, you can just click on this button and from here you can select particular chart type. So let's say I'm selecting this one, but it is not showing data properly. So let's select donut. Yep. So here associate and developer. So instead of age, let's show record count. So it will be more effective. Show values show percentage. So here you can see this is showing Salesforce role blank five record count. And then if we go here, Salesforce role associate record count one, then Salesforce role developer record count two, then Salesforce role admin record count one. So this way it will be fruitful. So just add it and your summary report is ready with chart. So you can just save so that it will be available to use. So I hope this is now clear. I just explained everything till here one, two, three, four are completed. Now, okay, it is there. Sorry, this is already there. So I am just removing this statement. So if you see this point, so you just need to create tabular report on instructor object. So it is already mentioned. Then for instructor, you need to create matrix report. Right. So I'm just highlighting them so that it will be clearly understandable. So all these reports, you will be creating on custom report types, right? So I just showed you like how you can create custom report types. So apply those steps. And this I'm not showing because it is on instructor. So just implement it. And if you face any difficulty, so maybe in tomorrow's session, I will show you how we can do that so that you also get to know like whether you are understanding through these sessions. So if I solve each and every question, so that won't make much sense. So I'm explaining many examples, but few you will be implementing as your own so that you can have enough confidence. Okay. So this is it about this custom report type part. Right. So I can see there is one question. So question is, can we move reports from one private folder to another folder? So I think this we can do if you go to reports. And if you click on all folders and if I click on tabular reports, so from here, I think you will see this move button. So if you click on this move button, so right now this report is in tabular report. So you can select any other folder and it will be moved to that folder. So if you save your report mistake by mistake in a private report folder and later on you want to shift, so that is possible. Okay. So now I'm moving to next topic and as I already told you, I will be taking all the question in that, but this was like very easy. So I just picked it, but all the questions I will be taking at that. So if you are having any question in mind, so you can just keep this in your mind or you can just write it somewhere and after the session, you can just ask in the Q&A part. Now let's discuss about scoping rules. So in previous session also, someone told me, will you be explaining scoping rule? And yesterday we saw like while creating report, there was one filter option available in standard filter like show records through that scoping rule, right? So scoping rule you can use at two places. One list view and second report. So let me show you first both the places. So in report, I think you already saw it. So if we go to any report and if you go to this show me standard filter, so here we have this filter by scope option. This is one place where we are using this scope word and if I go to any objects tab and if I open, so let me open students tab where we created custom list views. So here also, like when we apply filters, so filters in this, you will see this filter by scope, right? So at two places we have this option filtering by scope. So if you want to apply this filter by scope, so for that you just need to create scoping rules and how you can do that. So I am just moving to accounts object. And here you will see the scoping rule option, right? So from here, you can just click on scoping rules. So for this object like you can see one rule is already active, which I already created. So first read this. So scoping rules are available for custom objects. So for all custom objects, scoping rules are available and a few standard objects are having a facility to create scoping rule in which account, case, contact, event, lead, opportunity and task are available. You can create up to two active rules only, okay? So here you can see in my org one is already there. So how to create it? Just click on new rule and here you need to fill the rule name, then full name, then description. Then if you want to make it active, you can. Then we have two criteria. One is user criteria and one is record criteria. So user criteria means logged in user criteria, okay? And then we have permission criteria as well. So what you can do is select user criteria and if you click on this field option, so all the fields, those are available on user object, they will be listed here. And as per the requirement, you can pick that and you can apply the criteria, right? If you fill a permission criteria here, so all the fields you will see as per the permissions, right? So here we are not able to see any field, okay? So for permission, there is no field available to use. So I think we need to go with user criteria only. And then we have record criteria. So this record criteria is having only one option, record field. If you click on this field option, so here you will see only account object fields. So from here you can select particular field and accordingly you can set the criteria, okay? And you can have only one entry for user criteria and record criteria. Then you can just save it. You can see I already created it, I am opening it. So this is my rule name, full name. Then user criteria I selected is active equals true. And for record criteria also I selected active equals true. Or yes. So if my records are matching with this criteria, then only they will be available in the list view or like your report, right? So I just saved it. Now if I go here, so here I can select this and click on done and save it. So this is for student. So I just need to go to account and I can create new list view and then use that. This is one use of scoping rule. And another we can use in reports. So if I go to reports and open account report. So here also you will be able to use that scoping rule, right? So here you can see I just use this scope. So here all those records are available where active is yes. And if I change it to all and apply. So now I can see total 13 records. So it means filter by scope is working fine because there is no other filter available. So this way you can create your scoping rule and scoping rule. You can use at two places. One is list view and one is your reports. And if you see it somewhere else with any other features so in the similar way you will be able to use it. Okay. So I think you are now able to understand it. And here also I just mentioned this requirement. So you can just create it at your own and you can test it yourself. Okay. And maybe you can test it with list view also. If you have enough time. So create a scoping rule for custom object and apply it for maybe you can create scoping rule for student object and you can apply it for student list view or student report so that you will be able to understand it. Now next is joint report. So this is fourth type of report. So yesterday we discussed three formats, tabular, summary and matrix. Now we have one more that is joint report. So let's discuss this as well. So here we have requirement for joint report. So I'm just highlighting so that you can just see what we need to implement in each example. Okay. So I think now this makes more sense. So now I'm going to create a joint report. So here I'm going to select new report and I'm selecting accounts as of now and clicking on start report. Okay. So yesterday I showed you at top left corner we have this drop down where we need to choose report format. So we have two formats. One is report and one is joint report. So whatever reports we have created so far those we implemented for this report format. Tabular, summary and matrix. Now we have another option that is joint report. So this joint report is basically used to create reports on two or more report types. So I'm just clicking here and applying it. Okay. So see it carefully. It is different and like very less we use it but in some of the projects you may be getting a chance to implement this joint report. So as you create this option as joint report so you will start seeing this like account block one accounts block one. So because we just created one block for one report type. Now if you want to add one more block for different report type in the same report you can do. So click on this add block button. It will open this report type option and here I am selecting opportunities and adding the block. So you can see this blue block blue highlighted line is showing account block and if I scroll to write so this is for opportunities and if you want to rename these block names so you can just click on this pencil and you can rename. Right. Okay. And at left hand side you can see here columns for accounts block one is available columns for opportunity block one is available. So if you want to add or remove you can then grouping across blocks. So if you summarize so it will be applied to whole block. Okay. Then go to filters and you can see different filter options are available. So for account block you have different filter for opportunity you have different filter in accounts you are not able to see any record because this filter we need to modify. Now you will be able to see records in account block. Right. And in opportunities you are able to see records. Right. And if you want to apply a custom filter so from here you can apply those as well. So this is about joint report and if you want to add more blocks so you can just click and add more blocks. So as a suggestion like don't go for beyond two or three blocks because it will be difficult to manage them. So what you can do just run it so that you can see how it will look like. So this way you will see the results. So if you want to compare the data of two or more than two objects then you can go with joint report. Right. If you want to group so here we can select account name. So let's see what happens. So this way grouping is done. So for account information is there and related opportunities are grouped together. So if I run it so you will see better picture. So here you can see account name Burlington Textile Corporate of America. So these are account information than opportunities not related. Let's see this one edge communication. So here if we take example of edge communication so these are account information and it is having two related opportunities which are available here. So this way like if you have relationship between two or more record types so then you can just go for joint report. Right. And if those two objects you are picking if they are not related then I think joint report doesn't make any sense but we can create like if I want to add blocks so if I select okay choose a different different this this one has no common field. Okay. Yeah. So sorry. So if you want to select objects for joint report so those objects should be having something in common and that you can have if you have relationship so it means if you want to create joint report it means between objects there should be relationship available. Right. Because without relationship that report doesn't make any sense. Okay. So I hope this is also clear now and I mentioned this requirement here so you will be able to implement it. Let me write summarize as well. So group records based on account name. Okay. So this is done and rest of the things are same which we applied and you can see chart option is also available so these you can play around yourself. Right. So moving forward now next we have bucket fields. Right. So this is important and we need to understand how we can create bucket fields. So I'm going to show this option to you. So to create bucket fields okay before I move to creation of bucket fields I'm just going to save this so joint report and let's say I'm saving it in private reports folder so because we won't be using it anymore. So I just saved it in private report if you want to create new folder you can. Now I'm going to open my tabular reports folder. Okay. Not tabular report. I'm going to open summary report and I am selecting this opportunity one. Okay. I'm clicking on edit. So here I'm going to show you how you can create bucket fields. So I'm just removing this grouping with account and I will be creating different grouping. Okay. So first let me explain to you what type of grouping I want and basis on that we will be creating bucket fields. Right. So here you can see we have stays field and stages having lots of fields lots of stays values pick list values. So in which two are common which is closed one and closed lost and other stays values are considered as open. So I want a bucket where I want to categorize my opportunities if it is closed one or closed lost. So they will be grouped together if it is other than closed one and closed lost so it will be grouped together. It means I need to create two buckets one for closed one closed lost and one for open. So if you have this requirement then you can go and create a bucket field. Right. So if you want to create a bucket field so you just need to click on this drop down for which field you want to create a bucket. Right. And before I explain this bucket so you can see these options are available sorting ascending sorting descending group rows by this field. So either you type it here on top left or you select so it will be grouped then show unique count then move left move right. So if you want to move this field left or right you can or you want to remove the column you can. So only option that is not explained till now that is bucket this column. Right. So I'm just clicking on it and it is very important to understand. Bhakti is asking why did I choose summary report so I just choose summary report because through this bucketing I will be grouping so I just removed that grouping so don't get confused if you have any tabular report and you want to convert the tabular report into summary that also work here. But bucketing we do so that we can apply some kind of grouping and grouping we do only in summary reports that's why I picked summary report and removed that existing grouping because now grouping I will be doing with the help of bucket field. So I'm just clicking on this drop down and clicking on bucket this column. So here I'm going to name it so bucket name is so I'm typing typing stays bucket right so this will be my stage bucket field and here you can see unbucketed values are 10 so now first of all you need to add the bucket so at bottom you can see this add bucket button is available so I'm clicking here so my bucket name is open opportunities right so here you can see this bucket is created and right now it is blank it is not having any value so click on unbucketed values and select the values that you want to move to your newly created bucket so all these values I'm going to shift into this open ops so at bottom you can see you have a pick list which is moved to click in click on it and select open ops so you can see open ops bucket is having these eight options right now unbucketed is having only two so I'm creating one more bucket and here I'm writing close ops then from here I'm choosing these two options then again move to and close ops so open ops is having eight option close ops is having two options and unbucketed values are zero so this way these two buckets are created and bucket field name is stays bucket right now I'm just clicking on apply so there is one more option is available this checkbox bucket remaining values as other so this new bucket will be created automatically but right now in our case nothing is left we just need these two options so everything is set and you can just click on apply and on left bottom you can see stays bucket field is created and if I go here so you will be able to see the values as well so I'm just clicking on run so that we can see the values clearly so check it properly here we have stays as negotiation review so it is but stays bucket is showing open ops then for sorry then for close one it is showing close ops then for ID decision maker proposal it is again showing open ops so this way we just created this categorization now how we can use this bucket field for grouping so from here I'm going to select stays so you can see above you are able to select opportunity information right and below you have bucket fields so I have created only one bucket field that is why it is available so I'm selecting it and basis on that now grouping will be done so open ops are 8 and here you can see the stays values and closed opportunities are 12 and here you can see the values so this way if you want to group basis on your basis on your custom requirement so for that purpose you can just create these buckets right so I hope this makes sense and this example is very clean so whenever you want to group basis on pick list field so you can go ahead and I would suggest to create buckets for pick list and numeric values only right because for other text and all you won't you can't predict what value will be there for numeric fields you can just have a range let's say 0 to 1 1000 1000 to 2000 2000 to 3000 so this way you can create ranges as well yes Sunil I already showed you like how we can group through bucket fields so this grouping is done through this bucket field that we created right now okay so I think this example is also done like bucket for stays now I'm going to show you how you can create bucket for numeric field so here I'm just removing this bucket now and you can see we have amount field available we have amount field available so I'm just shifting it above so here we have this amount field and amount is having different values right so I want three buckets I want to categorize opportunities basis on amount in three different ways right so what I want I want a group where opportunities if amount is 0 to 50,000 second 50,000 1 to 100,000 and third one is greater than 100,000 right so three these three buckets I want to have basis on that I want to group my records so what I need to do I need to click here and you can see here we have this option bucket this column so this is numeric field so here you will see different kind of options so here I am writing amount bucket and generally as part of best practice we don't write bucket in the this field name that we are creating for bucket we just write the name as it is suggested in the project as per the requirement but for understanding purpose I am just using this name now here we can just specify the range right so here I am writing 50,000 so first option says less than equals to 50,000 so first option says less than equals to 50,000 so like we have opportunities so we are categorizing them in three categories so low, medium and high so maybe we can say like you have lots of opportunities and you are just checking chances of conversion right or maybe you can say focus like if amount is higher then your focus will be high if amount is low so you can just have focus as medium if it is very less so you can just have focus as low so first is less than equals to 50,000 second is 50,000 to 100,000 and third one will be greater than 100,000 so this way three categories categorization I have created here and treat empty amount values in the report says zero so if you want to do this you can just enable this check box otherwise you can leave it as is okay and if you want to have more sections you can just click on add so you can have more than three levels also and click on apply so at last you can see amount bucket is created okay so for 75,000 you can see it is medium for 50,000 it is low for 60,000 medium for 235,000 it is high so this way your amount bucket is created now if you want to group so you can just search amount and bucket field is available and this way you can see we categorize and if I click on run so you will see the results of the report so low opportunities are six where amount is zero to 50,000 and here you can see these amounts are listed here and medium are nine where amount is between 50,000 to 100,000 they are listed here and then you have all the opportunities where high is mentioned so these are more than 100,000 so this way you can create bucket fields and like preferably if you create it on pick list and numeric so it makes more sense okay and for date range also you can create it so that you can try yourself so I just give you two options because these are used more so this is for pick list and this is for number or you can say currency right so this way joint report bucket fields are create like I explained scoping rule is also explained now sorry next topic is row level formula this is last topic for today's session so now I'm going to explain it okay so I'm going to get it and let's create new report I am selecting opportunities clicking on start you can choose any report type or any format for this so basically if you talk about row level formula so it is similar to the formula field that we created earlier on particular object so what you need to do if you want to have a formula field and report itself and also remember the bucket field which I created and the formula field which I'm going to create they will be available in the report only they won't be available in the actual object right so we are creating them temporarily for reporting purpose they want to be available under your actual object so let's say if you want to create a formula so we have amount and I just want to create one formula where I want to have this amount value doubled right so what you can do come here under this columns and here you will see these options so add bucket column this I already explained then we have add row level formula and I think this option we will find here as no so if you want to add formula so you have this option here only so click on add row level formula so you will have this pop-up open then here you just need to create the name of the column so I'm just creating it as double amount description you can write as your own then formula output types are for so I'm just using number because I'm creating it for number type now here you can build your formula formula so I'm just selecting this field so if you want to insert any field in this formula builder so just click on it and click on insert it will be available here now I just want to apply it like this amount multiplied by two okay if you want to validate whether it is correct or not just click on that button it will be validated as part of syntax and if you want to apply any function so those functions are also available and these functions are similar to the functions which we saw while creating formula fields for particular object right so you can pick any function but you should know the meaning of that function and I think I already gave you the formula guide if you go back to previous session so here under day one you will find this formula guide from here you can understand each and every formula use so here amount into two is created and I'm just clicking on apply so here you can see at bottom left double amount this column is created so this is actually a column which is created in report itself and if I go to write so here it is so I'm just shifting it beside amount okay so here it is now I'm just clicking on run so you can see here we have amount column and here we have double amount column and you can see whatever amount we have this double amount is having exactly double value right so this way you need to now think about the formulas and you can create so the same way you created formula under objects same way you can create here as well and you will find some more features here like summarize so this summarize option is available for numeric column so if you want to have these values like this so you can just select them so for this column some average max min and median these options are available you can have these for this field as well so for numeric this summarize option is available so if you want to summarize you can and if you run so in the results you will see this option as well so these are additional features those are available for numeric columns so I think it will be helpful okay so if you want to save it you can so I'm just okay I'm just canceling it as of now because you might be having some questions so I'm keeping it okay so this is all about today's session so I try to explain everything in detail and if you have questions so now we can take them so if you have any question you can just type so Manan your question is you have two objects ENB so I just want to know they share some relationship or not Simi is asking will you teach app builder so in app builder I will be like most of the topics of admin are available in app builder if you verify and most of the features will be covered I will be covering flow as well and like at last we will see deployment also so I think most like 80 90% topics of app builder will be covered yeah Manan I got your question but I need more reference to your question like whether ENB are related or not Sunil we can add many number of objects in the joint joint report but go for two or three only because it will be difficult if you go beyond that and if you want to check the limit you can just click on add block and try to add many so as you see like if you are adding objects so there should be some relationships and we have only three four levels of relationships so you can just go beyond that yes Dixit a bucket field is little confusing so just do practice of that and if you see any difficulty so maybe I will explain that again tomorrow but first just see the recording of this explanation that I gave you and try to implement the solution of the exercises then we will discuss thank you Radha for appreciating Manish is asking can we group reports report records by role hierarchy of user no we can just group them basis on fields Yamuna is asking what is in deployment and deployed which was there while creating reports okay so this is for just reference purpose like if we are developing something so we just select in development right and when you deployed something from one org to another then you can mark that option like deployed so those are two options but it doesn't make any sense if you choose anyone that is not making any difference so this is for understanding purpose because we have lots of developers on one project so it makes sense like if you follow that Priyanka is asking what is escalation so escalation is a rule that comes under service cloud or sales cloud so I won't be covering sales and service cloud features okay Manan they are related by master detail so in that case you will be able to select a records where they will be having at least one be record this you can do and second option says you can select a where zero related be are available and more than zero so these two options you can do with the record type sorry report type Summan is asking if creator of user no more active how to retrieve reports and dashboards so in that case your administrator will be assigning those reports to another like yeah this actually I just need to test this as well if creator of user no more active so like if you deactivate that user then there will be problem but if it is freeze then you will be able to access I just need to search like if it is deactive then what will happen so Summan I will answer this question in the FAQ document so from there you can just understand Yamuna is asking is filter by scope is like filtering records based on scoping rule along with the filters which we apply on reports yes both will be applied yeah thank you Manish for appreciating thank you Pienka Manan also explain if they are sharing a junction object yes so Manan this I already explained I think you joined late today so if you go from the beginning of this session you will be able to understand yes Parikshit you will see apex and trigger I think you have not gone through the session tracker so that session tracker link is available in the description of this video so you can just open and you can see Kalas both are different restriction rules are basically related to your data security thank you Nassar for appreciation thank you Summan so I think there are less questions today if you have more question you can ask I will just wait for two three more minutes and then we can wrap the session one question asked by asset like I'm creating new folder but that is public or hidden or private how do I know so by default they will be public so tomorrow I will be discussing about sharing of reports then you will be knowing like how we can identify whether report is shared or not okay so right now if you create any report so it will be accessible if you want to share with other users then you need to apply some sharing techniques so that I will be explaining tomorrow yes Manan that may be because of permissions and security or thank you Vishal ok Kela so maybe your org is outdated so just try to create New York and because the scoping rule is new feature so just try to create New York because in my org it is latest one so it is available thank you Sneha for appreciation yeah Jigna so it depends on the project requirement if you need to apply a filter basis on scope so then you need to create scoping rule so it totally depends on business requirement yeah it is not used much but you cannot say it is not important because if there is a requirement of business so you you will be using it okay so if you have any more question you can ask otherwise tomorrow we will be having one more session on reports and dashboard so this week I just kept three session and next week we will be having sessions on data security so maybe there will be three or four sessions so I will be just updating the session tracker so accordingly you will get to know okay so again just share the word with others as well so that they can also follow the bootcamp and thank you for joining the session thank you so much thank you everyone those who just typed the messages so I am ending the session see you tomorrow thank you bye everyone


What's going on everyone Sam here with Leighton Sports Cards ripping one box of 21 22 Penini Spectra basketball for Glory H. So good luck here. Glory. See we got in here for you Glory had a really nice Frans RPA today and Group breaks out of Spectra. So see if we can do that again. We keep our Scotty Barnes streak alive, too I guess it kind of died last break, but John and Kamingo rookie we've got that is Kazi Russell on the retrospect That is nine thirty one out of 49. It's gonna say 91 out of 49. That wouldn't be right and a kawaii silver We got a one of those die cuts Chris Paul that's Isaiah Jackson 15 out of 35 three colored RPA on the astral And we've got a Jeremiah Robinson Earl five out of eight on the rookie universal die cut There you go congrats on that glory. Those are super tough pulls That'll work for sure Jalen's Suggs rookie. We've got Rick Berry 16 out of 25 on the meta auto For the Warriors illustrious legends and Norman Powell silver DeMar DeRozan Wow Cade cutting hand That's glory on the Celestial RPA Did this stuff fit this these personal runs of spectra have been insane? Let's go can crats glory can't wait for you to see this buddy if you're not watching right now We'll have to talk about this one Heck yeah, nice keyed, and then we've got a kuzma three out of 35 for the wizards That will do it for your break there glory congrats on the hits. We'll get them right out to you my friend


Okay, it's drinking is good for your health.  I'm Rick and you call us on Instagram more juicy Patron following official Twitter countering the bell pillow in my case squad I'm ready for Yankees baseball. Let's go for not playing Nobody's playing Rick. I know it was good baseball season right now. Yeah, I don't think baseball is playing this year It'll be interesting to see a football plays this year It's it's it's awful. All right. Anyway, I'm playing baseball games in my mind anyways Shit Vir Das whom we love dropped another video of his, you know, you did that other one about The on the bright side with the coronavirus, but this one is Shakespeare explained So, oh really Vir Das explains Shakespeare. I think in terms of Bollywood movies. I think is what I heard You know, we love Shakespeare We love Shakespeare and we love your Doss. So here we go. All right three two one go Hey Hi, look The world is still very much turning unless it's flat in the light us birds are having ridiculous party outside Because we're out of the way trolls are very much still trolling unless that's just my Twitter and not yours And everyone still seems to have their vision except for the people. I'm gonna DM this shirt this pick of mine My point is this What is that? Nice, huh? So that's my neighbor. I'm not really digging right now There's been a bit of a pause in my lifestyle.  I'm not building up towards a bad man.  You listen to Celine Dion every night. It's not a secret She's a great artist secret is I love Shakespeare. So today in this pause I'm gonna take the time to complete the three Shakespeare plays. I haven't read they are Macbeth Winter's Tale and which of the third and at the end of the day, I would have completed all of Shakespeare's books Nobody cares. I care. I care. It's my branded video. I'm supposed to care Sorry about that But look just in case you're not a loser like me. You're spending your time at home doing productive things like learning music Happy birthday.  I have to complete all of Shakespeare's plays Step two mentally prepare myself Deliver Here we go All's well that ends well a woman curses it king and then she dethrones the husband But the shady husband already has a family it's fully shady but the putney or war Anthony and Cleopatra boy meets girl Then dumps an old girl then refooks up with the old girl And then like she dies and she dies and he dies and the snake wins It's like a really sad sneaky kaya matak kaya matak as you like it girl in for his cross-dressing as a dude meets a Duke falls in love turns out. She's not actually a dude and the Duke is okay with that Chachi Charso bees Henry the fifth is like a tennis ball gift and the English king invades France gets the girl That is not in the script. It's laghan Henry the six part one two and three baby king baby girl Both get married and then like they turn on each other and all the babies are dead It's very long Henry the eighth king divorces wife gets a new wife and then has a daughter who's chosen one But not like in the matrix just like this kind of chosen one is judaic Julius Caesar emperor king killed by bastard friend Friend chased out by new king hashtag Budla. It is welcomed King John two wars one marriage one poisoning pissed off France. It's Joda Akbar king King banishes a daughter daughter banishes him banished section war Everybody's angry than everybody's in love and cheerful. It's DDLJ loves labor lost for virgin dudes fall in love and propose Women take a year to find out if they actually love them turns out. They do lots of wasting turns to love Mojave. This is impressive, huh? I just wanted to take a second and point that out Hamlet a man wants to kill his uncle for killing his dad accomplishes his mission and everybody dies So head corners a man Loses an election and hooks up with this enemy and the family is very upset that he hooked up with the enemy and the family turns on The man and the man dies her car Henry the fourth Part one people want to dethrone the king then they try to kill him and the son saved the king's life Gangs it was a poor part one But then in part two the old king guys his son is now the king king banishes the back Stabbing friend and everybody's happy Bob cup but la gang so was a part two Symboline a do was to kill this lawyer girlfriend as you do man finds out she never cheated gets back together with everybody's happy It's BV number one Mary Wives of Windsor a serial ledger pursues to married women only to be like Fully humiliated by them in public in the end. It's much to do speak again Let's have a nice dream like a couple gets mixed up with like an other couple and then everybody gets Rearranged and married and everybody's happy. It's house full for much to do about nothing Two sets of lovers lead their respective partners on for a really long time until everybody eventually gets married Kabi Al Vida Na Ke Na Othello one guy tells his friend that his wife is cheating on him Then kills the wife and the friend and himself it's Omkara Pericles Meets his wife after shipwreck then loses her after an other then waits a really really long time and finds the right wife Park one Taming of the shoe a student pretends to be like a nobleman to get the girl But he's a student so student of the year tempest Using magic to teach people a lesson and winds up the king of Hogwarts You think you would stop being impressive, but still is measure for measure Imposter manipulates girl sex happen real do comes back eliminates that and marries the girl It's theory Maris Hapne merchant of Venice So like a man takes a loan for a friend's marriage cannot pay that back wife of the friend pretends to be a lawyer to save him It's like Munna Bhai MBBS everybody's impersonating something well night girl dresses up as boy falls for Duke yet again girl Not boy Duke still settles for yet again apna sapna money money Richard the second two men are banished One fights back King goes to jail man goes on pilgrimage. It is very very random just like current Arjun Richard the third king Tries to trick everyone. He's rubbish at it and is killed by everybody including his nemesis. So fan Romeo and Juliet boy and girl fall in love family is upset boy and girl die family is sad Demon of Athens boom bus friend from Athens money to a painter He's taken for granted then takes revenge with everybody else. It's Malamal weekly Titus and Veronica's dude wins war Queen is prisoner queen plots revenge dude becomes Cannibal, I don't know a Haseena tea Toilets and Kaseera Trojan war two dudes love two chicks one is bitter The other one is killed in the third one is just doing like random stuff. It's Dil Chata. Hey two gentlemen of Verona two friends Mmm, this is one real one. Yeah, they will apologize everybody gets married.    Well, I mean we know I Did all the work you're welcome. In fact, you think you can do it better Why don't you take exactly what I said and see if you can do it in under three minutes if you do There'll be a special prize waiting for you. Hey do it right again. No He just screwed down the gauntlet, bro. Take care of yourselves guys. Hey, man. I'm making lunch. You want something Got it all. Can we do coffee rolls? Okay, so what did he say was the I think try to try to try to try to I don't know what the pry He'll probably like retweet you as some but you should totally do it on your channel. That's it. Yeah, but it I am Definitely I am seriously gonna consider that but let me tell you it's content for your channel Yeah, seriously, it isn't it's an idea. I needed that. Yeah, I mean fun try to do that in three minutes That'd be impressive Yeah, that was like that's not one obviously he wrote everything down But that's not easy to do it and to do it humorously like he did It's one of the many things we love about veerdolls also the fact that he's a Shakespeare fan I would once again, yeah, and more to sit down with veerdolls And I'm not saying that there's an interview coming because there's not but I would love there to be so veerdolls hit us up Yeah, he did say that when he was in town, but he we can't do that now can we know what we can have old monk over sky Yeah, we could do sky that well a couple things first of all one of the first or second Reactions we had to his stand-up stuff. I think we both commented on how clear it was that he was an intelligent guy Just really very very intelligent his comedy has intelligence his speaking has intelligence and This what he put together here is not just witty. It's just really smart. Yeah, but and how about that? Did you just notice the clock on his shelf? Mm-hmm? It's cool. That's that that's that's from a what's his name? It's a famous house painter. Oh No, oh, yeah that melting clock isn't it famous isn't it? It's not it's the one with the screaming screamer right the No, no, no, no, no, he's known for oh Good grief. Hold on. I'm looking it up Um great content here. This is great content Salvador Dolly, oh gotcha Yeah, no, I love that clock, but riveting content. That's why I'm so sad that I Well, obviously all this coronavirus stuff happened But like because we were supposed to see him live in concert because he was coming here to Inglewood And we were a hundred percent going hundred percent going and I was gonna hoping we would be able to like it was nothing set in stone But I was hoping to be able to like get in contact with his people So we could like either just sit down with him and talk to him or yeah Interview him because he seems like a man that would be so like intriguing to talk to and fun to talk to But like intelligent wise as well Yeah, well, and here's a little fun fact for a little trivia. I think you know this story But for those of you who don't know this Actors tend to be especially theater actors can tend to be a superstitious lot That I've worked with actors who if you're whistling backstage will rip your freaking head off And I I remember Beth McBeth Yes, we were do that's why I love that Lin Manuel Miranda put in Hamilton They think me McBeth every night He makes them say McBeth on stage and that's a superstition for actors to not say That play by name in a theater because the legend is if you say that in the theater the theater is gonna close Well, we were doing Camelot at the Pasadena Playhouse We were having a conversation me being with two of the other actors and I just I'm not superstitious So we were talking about our favorite Shakespeare plays and we were talking about plays and I mentioned McBeth One of the actors turned to me and he said what did you just say? I said sorry The Scottish play he said you said it No joke for the first time ever in its history When Camelot closed so did the Pasadena Playhouse And it was closed for like six months and they read they did them I don't remember if they did like a bankruptcy or what they did But I remember turn when they gave us the news. I remember turning to that actor. He was like I Told you So dumb so it is Yeah, love Vir Das One of the best things about this whole coronavirus is that People are putting out just content now Yeah, Vir Das and then there's like other Celebrities or just regular regular people as well that putting out some content and it's so it's good for the consumer Just bad for our mental health having to stay inside all oh Yeah, it's getting to me