4

I have a report on events which includes three checkbox (Boolean) fields: Attended, Canceled, Waiting List. I would love to either create a custom field for just the report or a bucket field with values such as "Attended", "Did not cancel or attend", "Canceled". Currently I have the three fields as groups on a summary report, but "Attended: []" is not as user friendly as I want.
I suspect that I may have use VisualForce or Apex. If that's the case please be detailed as I've only been using Salesforce for two months and with no formal training.

1 Answer 1

2

You cannot create a custom field in a report. Fields are created at the object level only. As you've noted you can indeed create "Buckets" which might be one way of displaying the desired results without adding an additional field to your object, however as Mike has pointed out below, only picklist, text and numeric fields can be bucketed which won't solve your issue.

5
  • 2
    You can't bucket checkboxes; only picklist, text, and numeric fields - help.salesforce.com/apex/…. Unless you meant a custom field that did the bucketing?
    – Mike Chale
    Nov 18, 2013 at 20:22
  • 1
    I would love to bucket from the multiple checkbox fields, but I don't think that's on option. Looks like creating an object (maybe "Result") on the event using a formula with if or case. Thank you for the help.
    – SCARon
    Nov 19, 2013 at 14:02
  • Good catch Mike. Thanks for adding the clarification on what can be bucketed. I was primarily attempting to answer the creating fields portion of the question without considering whether or not checkboxes could be bucketed.
    – crmprogdev
    Nov 20, 2013 at 19:48
  • @SCARon, did you ever figure out a workable solution? Feb 25, 2014 at 21:03
  • @JustAGirlyGeek, unfortunately no. I could have made a formula field, but since this was just for a one-time report, that seemed a bit excessive.
    – SCARon
    Jan 9, 2015 at 19:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .