Forum Discussion

Chaipup's avatar
Chaipup
Frequent Visitor
8 years ago

Bell Curve with User Filtered Date Range from a Dataset

Hi,

 

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.

 

I've looked at the video below and it works perfectly for the whole table however it doesn't filter.

 

https://www.youtube.com/watch?v=5bPVMFrUnrU

 

My question is: How do I put a date filter on this!!

 

Thanks in advance

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi 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

    • Chaipup's avatar
      Chaipup
      Frequent Visitor
      8 years ago

      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