Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share your data or app?
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 |
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
You are using which chart? Please check attached screenshot. Let me know.
Like this?
And, this is not the right way to provide sample data. You should have used excel file for providing sample data.
Manish please check attached qvw. We are we using expression here when it's coming by default. Please advise.
Thank you!
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)
Thank you