Data based on month selection

[balaji_m]

Dear Experts,

Please help us on this below request

I have date  and count (records) for particular date.

when I select dec 2017 I will get one month date i.e 1st Dec 2017 to 31st Dec 2017 based on below screenshot.

My out put should show additional one bar with 1-Jan-2018 date and corresponding value.

it should show all the months based on use selected month.

i.e...if user selected June 2017.it should show 1-jun-2017 to 1-July-2017.

Regards,

Balaji

[MK_QSL]

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

[isingh30]

Can you share your data or app?

[balaji_m]

Hi Ishtdeep,

Please find data below:I need to apply monthwise filter.

Date	Val
1-Jan-18	173
2-Jan-18	2091
3-Jan-18	5324
4-Jan-18	4800
5-Jan-18	2430
6-Jan-18	15
7-Jan-18	41
8-Jan-18	2521
9-Jan-18	2534
10-Jan-18	2755
11-Jan-18	2620
12-Jan-18	2165
13-Jan-18	30
14-Jan-18	23
15-Jan-18	1652
16-Jan-18	3181
17-Jan-18	3708
18-Jan-18	2314
19-Jan-18	2827
20-Jan-18	58
21-Jan-18	308
22-Jan-18	3971
23-Jan-18	3352
24-Jan-18	3545
25-Jan-18	3145
26-Jan-18	807
27-Jan-18	24
28-Jan-18	457
29-Jan-18	8444
30-Jan-18	5958
31-Jan-18	3089
1-Feb-18	2091
2-Feb-18	5324
3-Feb-18	4800
4-Feb-18	2430
5-Feb-18	15
6-Feb-18	41
7-Feb-18	2521
8-Feb-18	2534
9-Feb-18	2755
10-Feb-18	2620
11-Feb-18	2165
12-Feb-18	30
13-Feb-18	23
14-Feb-18	1652
15-Feb-18	3181
16-Feb-18	3708
17-Feb-18	2314
18-Feb-18	2827
19-Feb-18	2091
20-Feb-18	5324
21-Feb-18	4800
22-Feb-18	2430
23-Feb-18	15
24-Feb-18	41
25-Feb-18	2521
26-Feb-18	2534
27-Feb-18	2755
28-Feb-18	2620
1-Mar-18	2165
2-Mar-18	30
3-Mar-18	23
4-Mar-18	1652
5-Mar-18	3181
6-Mar-18	3708
7-Mar-18	2314
8-Mar-18	2827
9-Mar-18	58
10-Mar-18	308
11-Mar-18	3971
12-Mar-18	3352
13-Mar-18	3545
14-Mar-18	3145
15-Mar-18	807
16-Mar-18	2091
17-Mar-18	5324
18-Mar-18	4800
19-Mar-18	2430
20-Mar-18	15
21-Mar-18	41
22-Mar-18	2521
23-Mar-18	2534
24-Mar-18	2755
25-Mar-18	2620
26-Mar-18	2165
27-Mar-18	30
28-Mar-18	23
29-Mar-18	1652
30-Mar-18	3181
31-Mar-18	3708
1-Apr-18	2314
2-Apr-18	2827
3-Apr-18	58
4-Apr-18	308
5-Apr-18	3971
6-Apr-18	3352
7-Apr-18	3545
8-Apr-18	3145
9-Apr-18	807
10-Apr-18	24
11-Apr-18	2091
12-Apr-18	5324
13-Apr-18	4800
14-Apr-18	2430
15-Apr-18	15
16-Apr-18	41
17-Apr-18	2521
18-Apr-18	2534
19-Apr-18	2755
20-Apr-18	2620
21-Apr-18	2165
22-Apr-18	30
23-Apr-18	23
24-Apr-18	1652
25-Apr-18	3181
26-Apr-18	3708
27-Apr-18	2314
28-Apr-18	2827
29-Apr-18	58
30-Apr-18	308
1-May-18	3971
2-May-18	3352
3-May-18	3545
4-May-18	2091
5-May-18	5324
6-May-18	4800
7-May-18	2430
8-May-18	15
9-May-18	41
10-May-18	2521
11-May-18	2534
12-May-18	2755
13-May-18	2620
14-May-18	2165
15-May-18	30
16-May-18	23
17-May-18	1652
18-May-18	3181
19-May-18	3708
20-May-18	2314
21-May-18	2827
22-May-18	58
23-May-18	308
24-May-18	3971
25-May-18	3352
26-May-18	2091
27-May-18	5324
28-May-18	4800
29-May-18	2430
30-May-18	15
31-May-18	41
1-Jun-18	2521
2-Jun-18	2534
3-Jun-18	2755
4-Jun-18	2620
5-Jun-18	2165
6-Jun-18	30
7-Jun-18	23
8-Jun-18	1652
9-Jun-18	3181
10-Jun-18	3708
11-Jun-18	2314
12-Jun-18	2827
13-Jun-18	58
14-Jun-18	308
15-Jun-18	3971
16-Jun-18	3352
17-Jun-18	3545
18-Jun-18	2091
19-Jun-18	5324
20-Jun-18	4800
21-Jun-18	2430
22-Jun-18	15
23-Jun-18	41
24-Jun-18	2521
25-Jun-18	2534
26-Jun-18	2755
27-Jun-18	2620
28-Jun-18	2165
29-Jun-18	30
30-Jun-18	23
1-Jul-18	1652
2-Jul-18	3181
3-Jul-18	3708
4-Jul-18	2314
5-Jul-18	2827
6-Jul-18	58
7-Jul-18	308
8-Jul-18	3971
9-Jul-18	3352
10-Jul-18	3545
11-Jul-18	3145
12-Jul-18	807
13-Jul-18	24
14-Jul-18	2091
15-Jul-18	5324
16-Jul-18	4800
17-Jul-18	2430
18-Jul-18	15
19-Jul-18	41
20-Jul-18	2521
21-Jul-18	2534
22-Jul-18	2755
23-Jul-18	2620
24-Jul-18	2165
25-Jul-18	30
26-Jul-18	23
27-Jul-18	1652
28-Jul-18	3181
29-Jul-18	3708
30-Jul-18	2314
31-Jul-18	3181

[balaji_m]

Hi Manish,

Thanks for your response.

I want to add next month start date should be append end of current selected month...I have to apply monthly filter as well.

Regards,

Balaji

[isingh30]

You are using which chart? Please check attached screenshot. Let me know.

[MK_QSL]

Like this?

And, this is not the right way to provide sample data. You should have used excel file for providing sample data.

[isingh30]

Manish please check attached qvw. We are we using expression here when it's coming by default. Please advise.

Thank you!

[sunny_talwar]

I think OP wants to see one extra day worth of data then the selection would show... for example

if Feb 2018 is selected, they want to see Feb 1st to March 1st..... (March 1st won't be part of regular Feb 2018 selection)

[isingh30]

Thank you