Best Of
Re: Test Post
You can delete the post, but you can’t delete the memories. I’ve already become emotionally attached. 😢
Re: 💎 Domopalooza 2026 — Registration LIVE!
I don't understand how these rumors get started. I look nothing like that guy.
Re: 💎 Domopalooza 2026 — Registration LIVE!
Can't wait to see everyone IRL!! I heard @ArborRose isn't actually a viking IRL 😱
Re: When converting a dataset to a view the type of some columns is changed
That's bizarre. The "fix" looks a more like a magical spell than a logical cure, but maybe it will help troubleshooting. Thanks!
Re: Join the Slack Domo User Group!
I heard Ben Schein is related to Henry Schein, is that true?
Re: Splitting Appointments
lol….Yeah, who's Brent?
I don't see anything where you designate the % split across time. One way you could do this is to organize something to show the date duration and split %, maybe something like:
Provider | Galley | Split % | Start Date | End Date |
|---|---|---|---|---|
Mitch | John | 100% | 1900-01-01 | 9999-12-31 |
Justin | John | 100% | 1900-01-01 | 9999-12-31 |
Kristin | Tanner | 100% | 1900-01-01 | 2024-12-31 |
Kristin | Tanner | 50% | 2025-01-01 | 9999-12-31 |
Kristin | Brent | 50% | 2025-01-01 | 9999-12-31 |
You could add more splits or rule without changing code.
Re: Splitting Appointments
I'm not seeing Brent in your sample table so I'm having trouble visualizing a solution, but maybe that is part of your issue because that is how the data is coming across?
Regardless, I often use a webform or similar to create a lookup table to help with the effective date piece. I may have some other ideas based on what your sample table actually looks like.
Re: Brag Time!
Congratulations on your certification!
Safe space? The best? I am a potato. I put on a helmet and a seatbelt before entering the forum.
Re: When converting a dataset to a view the type of some columns is changed
Careful though—if you run it three times in a row while holding down Shift, you might accidentally summon a demon.