https://community.jmp.com/t5/Discussions/Custom-Binning-how-to-edit-the-bins/m-p/718047#M89984 <P>Wow, custom binning even works with dates, cool!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1705832337221.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/60442i545C2B93EB9C3D7D/image-size/medium?v=v2&amp;px=400" role="button" title="hogi_0-1705832337221.png" alt="hogi_0-1705832337221.png" /></span></P><P>&nbsp;</P><P>There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.</P><P>What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?<BR /><BR /></P><P><div class="lia-vid-container video-embed-center"><div id="lia-vid-6345299038112w892h540r340" class="lia-video-brightcove-player-container"><video-js data-video-id="6345299038112" data-account="6058004218001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6058004218001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6345299038112w892h540r340'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.jmp.com/t5/video/gallerypage/video-id/6345299038112">(view in My Videos)</a></div></P><P>&nbsp;</P><PRE><CODE class=" language-jsl">dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); dt &lt;&lt; New Formula Column( Operation( Category( "Distributional" ), "Custom Binning" ), Columns( :Event Date ) );</CODE></PRE> Sun, 21 Jan 2024 10:33:44 GMT hogi 2024-01-21T10:33:44Z https://community.jmp.com/t5/Discussions/Custom-Binning-how-to-edit-the-bins/m-p/718047#M89984 <P>Wow, custom binning even works with dates, cool!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1705832337221.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/60442i545C2B93EB9C3D7D/image-size/medium?v=v2&amp;px=400" role="button" title="hogi_0-1705832337221.png" alt="hogi_0-1705832337221.png" /></span></P><P>&nbsp;</P><P>There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.</P><P>What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?<BR /><BR /></P><P><div class="lia-vid-container video-embed-center"><div id="lia-vid-6345299038112w892h540r466" class="lia-video-brightcove-player-container"><video-js data-video-id="6345299038112" data-account="6058004218001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6058004218001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6345299038112w892h540r466'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.jmp.com/t5/video/gallerypage/video-id/6345299038112">(view in My Videos)</a></div></P><P>&nbsp;</P><PRE><CODE class=" language-jsl">dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); dt &lt;&lt; New Formula Column( Operation( Category( "Distributional" ), "Custom Binning" ), Columns( :Event Date ) );</CODE></PRE> Sun, 21 Jan 2024 10:33:44 GMT https://community.jmp.com/t5/Discussions/Custom-Binning-how-to-edit-the-bins/m-p/718047#M89984 hogi 2024-01-21T10:33:44Z