Forum Discussion
Bell Curve with User Filtered Date Range from a Dataset
Community SupportHi Chaipup，
"I'm trying to build a Bell Curve based on a date range in my database e.g. I have data from 2014 but I would like to create the chart based on a user filtered date range (slicer) which is usually a month or so's worth of data."
<--- Which column do you want to set your slicer on? In addtion, can you give some details about your table and expected result?
Regards,
Jimmy Tao
Hi Jimmy, thanks for your reply;
I have a date range field for each record: "BookingDate" which has data from 2014 to current. I want to be able to use a slider to have a user definable range. I then have a field called "DeliveryMinutes" which creates a value based on how many minutes early or late we collect from the customer. I want to be able to plot all these records and create a chart to show how well we're doing. I've done it in excel and works fine but that's because I only use a dataset from a particular time period.
In the video the guy uses the distribution for each record as the start and end of his date range (to give him the x-axis) which means when I build his Bell Curve graph it gives me all the records from the data warehouse.
I hope that helps?
Thanks
Iain