Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
does this make sense? Do I need more detail here?
I am trying to run a histograph for days on market for a subdivision. I want to take all of the data that closed 0-30 and have in one column; 31-60 in another column; 61-90 in a third; 91-120 in a fourth.
the data I need is days on market and closed dates which I have in an excel spreadsheet.
here is example of three. First property closed on 2/22 and was on market 1 day. Second closed on 6/22 and was on market 2 days. Third closed on 4/29 and wasn't on market a day before a contract. This is a sample where the spreadsheet is 125 properties.
2/22/22 0:00 | 1 |
6/22/22 0:00 | 2 |
4/29/22 0:00 | 0 |
any help would be greatly appreciated!! I'm new at this
Read about column charts and binning. That'll give you the histogram you need. Good thing that you have a fixed list of bucket ranges. It would be harder with dynamic bucket sizes.
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |