Friday, May 13, 2016

Salesforce Interview Questions-Reports & Dashboards Part-1

1. What are different types of reports?
  • Tabular report. This is the most basic report. It displays just the row of records in a table like format with grand total. Tabular reports cannot be used for generating dashboards.
  • Summary report. This is the most commonly type of report. It allows grouping of rows of data. It supports sorting and displaying subtotals. For example in a recruiting app, a summary report could be used to display open positions classified by department name.
  • Matrix report. This is the most complex report format. Matrix report summarize information in a grid format. Matrix reports allows records to be grouped by both columns and rows.
  • Joined Reports: Joined reports let you create multiple report blocks that provide different views of your data. Each block acts like a “sub-report,” with its own fields, columns, sorting, and filtering. A joined report can even contain data from different report types.
2. What all reports can be used to generate dashboards?
Summary and Matrix reports

3. What all things are not supported in joined reports?
The following items aren’t supported in joined reports, and aren’t converted:
  • Bucket fields
  • Cross filters
  • The Rows to Display filter
4. What are bucket fields?
Bucketing lets you quickly categorize report records without creating a formula or a custom field. For example, create a bucket field named Size based on the # Employees field. Then, create buckets that group records into “Large,” “Medium,” or “Small” ranges that you define. Bucket fields can be used like any other field to sort, filter, and group your report.
You can add up to five bucket fields per report, each with up to 20 buckets. Only numeric, picklist and text field can be used for bucketing. Other data types are not supported.

5. Can we create a formula type in reports?
Yes.
Formula are not available in tabular reports but available for other report types.
Formula can be only in number, currency and percent format.

                                                                                Reports & Dashboards-Part 2

29 comments:

  1. I would like to thank you for the efforts you have made in writing this blog
    https://onlineitguru.com/salesforce-online-training-placement.html

    ReplyDelete
  2. Thanks for sharing useful info!
    looks great
    We are Top in salesforce Online Training Hyderabad@Capitalinfo solutions. We provide quality training for salesforce, Devops with realtime project+Placement Assistance
    slaesforce online training
    slaesforce Integration training
    slaesforce online training
    capitalinfosolutionsindia

    ReplyDelete
  3. Share wonderful details concerning your blog site, Blog truly useful for us. Annual Report Inner Page Design

    ReplyDelete
  4. I rejoice to this blog offering distinct as well as handy understanding regarding this subject. Branding

    ReplyDelete
  5. This blog is really helpful to deliver updated affairs over internet which is really appraisable. Bakery Layout

    ReplyDelete
  6. Great blog ! I am impressed with suggestions of author. Wordpress Help

    ReplyDelete
  7. Share wonderful details concerning your blog site, Blog truly useful for us. Digital Marketing In Lucknow

    ReplyDelete
  8. Thanks a lot for sharing a posts with valuable information
    salesforce administrator training.

    ReplyDelete
  9. last question i dont understand proper ...whats is formula type in report?

    ReplyDelete
  10. You truly did more than visitors’ expectations. Thank you for rendering these helpful, trusted, edifying and also cool thoughts on the topic to Kate
    Best Project Management Software

    ReplyDelete
  11. how many record can be seen when you run you run report

    ReplyDelete
  12. how many record can be seen when you run you run report

    ReplyDelete


  13. Techforce services is a Salesforce Consulting Services in Australia Specialising in delivering end to end Salesforce solutions ,Consulting, Implementation DevOps partners in australia We deliver applications and services more rapidly and reliably, but it’s more than a methodology – it cuts to the very core.Salesforce Data Analytics let us help you become a data driven organisation and ensure your data is working hard for your business This includes implementi
    Salesforce Consulting Services in Australia
    Salesforce Staff Augmentation in Australia
    Salesforce Data Analytics
    DevOps Partners in Australia
    Managed Projects Salesforce Australia

    ReplyDelete
  14. i love reading this article so beautiful!!great job! digital marketing questions

    ReplyDelete
  15. Do you Need Instant Loan from $2,000 to $50,000,000.00 with no collateral required and receive a no obligation loan approval.We welcome the opportunity to show you how effective we are at helping our clients obtain the money they need to succeed. Our professional staff is available for a Free Consultation.At Patiala legitimate company Pvt , contact us now 2% interest rate, both long and short term cash reply to us (Whats App) number: +919394133968 patialalegitimate515@gmail.com 
    Mr Jeffery

    ReplyDelete
  16. HOW I GO MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY LAST WEEK. Email for immediate response: drbenjaminfinance@gmail.com

    Hello everyone, Am here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr.Benjamin Scarlet Owen he holds all of the information about how to obtain money quickly and painlessly via Email: drbenjaminfinance@gmail.com

    and consider all your financial problems tackled and solved. Share this to help a soul right now, Thanks


    ReplyDelete
  17. [6:31 pm, 09/12/2021] +1 (804) 582-4540: It Tears me Up Whenever we receive complaints from Clients About Their Experience With the Hackers They Met Before They Heard about us.
    These Days There Are alot of Hackers Online, You Just Have to Be Careful about who you meet for help, because many people now don't know who to ask for help anymore but there's actually a solution to that which I am giving you for free, Don't go out there seeking for Hackers Yourself, Because the probability of getting a Real Hacker Out there Is Very Slim . ❌❌ ❌ Most Of Them are actually not who they say they're, they are just here to Rip people Off, You Can Always Identify Them With Their False Advertisements and False Testimonies Trying To Lure you Into their Arms, And most of them use yahoomails, gmails and other cheaper email providers which could easily expose their vulnerabilities, Please Don’t Fall For Them🚷 Come To Think Of It, Why would a Legit Hacker Be using a gmail or a cheap email provider that exposes his vulnerabilities????⚠️⚠️⚠️
    Well, Our Purpose Here Is To Link You Up With Top Legit Hackers With Great Online Reputations and Impressive LinkedIn Profiles That’ll Blow Your Mind.

    ☑️ COMPOSITE FIRMWARE SECURITY SPECIALISTS is here to Provide you with The Best Hackers, So you can get saved from The Arms of the Fake Hackers❌❌.


    ☑️All our Specialists are well experienced in their various niches with Great Skills, Technical Hacking Strategies And Positive Online Reputations And Recommendations🔘
    They hail from a proven track record and have cracked even the toughest of barriers to intrude and capture all relevant data needed by our Clients.

    We have Digital Forensic Specialists, Certified Ethical Hackers, Software Engineers, Firmware Security Experts, Private investigators and more. Our Goal is to make your digital life secure, safe and hassle free by Linking you Up With these great Professionals such as JACK CABLE, ARNE SWINNEN, SEAN MELIA, DAWID CZAGAN, BEN SADEGHIPOUR And More. These Professionals are Well Reserved Professionals who are always ready to Handle your job with great energy and swift response so that your problems can be solved very quickly.
    All You Need to Do is to send us a mail and we’ll Assign any of these specialists to Handle your Job immediately.

    ☑️ Below Is A Full List Of Our Services:
    ▪️ FUNDS RECOVERY ON SCAM INVESTMENTS, BINARY OPTIONS TRADING and ALL TYPES OF SCAMS.
    ▪️ WEBSITE AND DATABASE HACKING 💻
    ▪️ CREDIT REPAIR. 💳
    ▪️ PHONE HACKING & CLONING (giving you 📱 Unnoticeable access to everything Happening on the Target’s Phone)
    ▪️ CLEARING OF CRIMINAL RECORDS ❌
    ▪️ SOCIAL MEDIA ACCOUNTS HACKING 📱
    ▪️RECOVERY OF DELETED FILES 📤
    ▪️LOCATION TRACKING 📌
    ▪️BITCOIN MINING ⛏ And lot More.


    ☑️ CONTACT:
    .....
    firmwarehacks@gmail.com
    🔘2021 © composite firmware specialists
    🔘Want faster service? Contact us!
    🔘All Rights Reserved ®️

    ReplyDelete
  18. The post is really informative about charts and reports for jira service desk and keeps posting and this is an Interesting Blog. Thanks for sharing.

    ReplyDelete
  19. Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY JEAN INVESTMENTS

    Hello, Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY JEAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com

    We invest in all profitable projects with cryptocurrencies. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options, Are you interested in earning a consistent income through binary/forex trade? or crypto currency trading. An investment of $100 or $200 can get you a return of $2,840 in 7 days of trading and you get to do this from the comfort of your home/work. It goes on and on The higher the investment, the higher the profits. Your investment is safe and secured and payouts assured 100%. if you wish to know more about investing in Cryptocurrency and earn daily, weekly OR Monthly in trading on bitcoin or any cryptocurrency and want a successful trade without losing Contact MRS.DOROTHY JEAN INVESTMENTS Email profdorothyinvestments@gmail.com


    YOURS IN SERVICE
    Mrs. Dorothy Pilkenton Jean
    Financial Advisor on Bank Instruments,
    Private Banking and Client Services
    Email Address: profdorothyinvestments@gmail.com
    Operation: We provide Financial Service Such As Bank Instrument
    From AA Rate Banks, Cash Loan,BG,SBLC,BOND,PPP,MTN,TRADING,FUNDING MONETIZING etc.

    ReplyDelete
  20. This comment has been removed by the author.

    ReplyDelete
  21. This comment has been removed by the author.

    ReplyDelete
  22. Nice article! It was very innovative thing with unique title and keep it up...
    Abogado De Divorcio En Virginia

    ReplyDelete
  23. פריצת כרטיס כספומט ריק למכירה. איש קשר ב-Hangout: cchacker0002@gmail.com

    אני רוצה להעיד על Dark Web כרטיסי כספומט ריקים. (מכונת הכספומט הרשמית) הם מוכרים כרטיסי כספומט ריקים אוטומטיים שבהם אתה יכול להשתמש כדי למשוך כסף בכל מכשיר כספומט ברחבי העולם. הזמינו את כרטיס הכספומט הריק שלכם עכשיו עם הקופה האוטומטית הרשמית. ראיתי כל כך הרבה עדויות באינטרנט על האופן שבו האקרים של Web Dark מייצרים כרטיסי כספומט ריקים אוטומטיים ומוכרים אותם לאנשים שונים ברחבי העולם. הזמן את כרטיס הכספומט הריק שלך עכשיו. . שימו לב שזה לא בחינם

    ReplyDelete
  24. i highly recommend ethicsrefinance@gmail.com, for they did a hack for me and i successfully received $60,000 through their bank wire transfer... they are really awesome, indeed i can say they are the best hacker in the world.......CONTACT THEM VIA

    EMAIL:ethicsrefinance@gmail.com

    WEBSITE:www.ethicsrefinance.com

    ReplyDelete
  25. Reading this blog post feels like taking a refreshing dive into a pool of knowledge! Really helpful for my digital marketing agency in Lucknow

    ReplyDelete