Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi experts,
i have two tables like below i want last 3 days(without holidays) and 5 days(without holidays) as a separate buckets.when ever i click 3 days bucket or 5 days bucket it has to display last 3 days sales or 5 days sales in bar chart.
in billing day 1-working day 0-holiday,
can you please help me...
Date | Sales | Country |
1-Apr-15 | 4566.24 | Germany |
2-Apr-15 | 4122.30 | Germany |
3-Apr-15 | 4185.72 | Germany |
4-Apr-15 | 5073.60 | Germany |
5-Apr-15 | 951.30 | Germany |
6-Apr-15 | 4566.24 | Germany |
7-Apr-15 | 4724.79 | Germany |
8-Apr-15 | 3963.75 | Germany |
9-Apr-15 | 4230.11 | Germany |
10-Apr-15 | 4299.88 | Germany |
11-Apr-15 | 5073.60 | Germany |
12-Apr-15 | 317.10 | Germany |
13-Apr-15 | 3963.75 | Germany |
14-Apr-15 | 3963.75 | Germany |
15-Apr-15 | 4724.79 | Germany |
16-Apr-15 | 3963.75 | Germany |
17-Apr-15 | 4230.11 | Germany |
18-Apr-15 | 1458.66 | Germany |
19-Apr-15 | 1204.98 | Germany |
20-Apr-15 | 4724.79 | Germany |
21-Apr-15 | 3963.75 | Germany |
22-Apr-15 | 4230.11 | Germany |
23-Apr-15 | 4724.79 | Germany |
24-Apr-15 | 3963.75 | Germany |
25-Apr-15 | 1426.95 | Germany |
26-Apr-15 | 780.07 | Germany |
27-Apr-15 | 4724.79 | Germany |
1-Apr-15 | 5288.40 | UK |
2-Apr-15 | 4774.25 | UK |
3-Apr-15 | 4847.70 | UK |
4-Apr-15 | 5876.00 | UK |
5-Apr-15 | 1101.75 | UK |
6-Apr-15 | 5288.40 | UK |
7-Apr-15 | 5472.03 | UK |
8-Apr-15 | 4590.63 | UK |
9-Apr-15 | 4899.12 | UK |
10-Apr-15 | 4979.91 | UK |
11-Apr-15 | 5876.00 | UK |
12-Apr-15 | 367.25 | UK |
13-Apr-15 | 4590.63 | UK |
14-Apr-15 | 4590.63 | UK |
15-Apr-15 | 5472.03 | UK |
16-Apr-15 | 4590.63 | UK |
17-Apr-15 | 4899.12 | UK |
18-Apr-15 | 1689.35 | UK |
19-Apr-15 | 1395.55 | UK |
20-Apr-15 | 5472.03 | UK |
21-Apr-15 | 4590.63 | UK |
22-Apr-15 | 4899.12 | UK |
23-Apr-15 | 5472.03 | UK |
24-Apr-15 | 4590.63 | UK |
25-Apr-15 | 1652.63 | UK |
26-Apr-15 | 903.44 | UK |
27-Apr-15 | 5472.03 | UK |
2nd table
Date | Billing Day | Country |
1-Apr-15 | 1 | Germany |
2-Apr-15 | 1 | Germany |
3-Apr-15 | 1 | Germany |
4-Apr-15 | 0 | Germany |
5-Apr-15 | 0 | Germany |
6-Apr-15 | 0 | Germany |
7-Apr-15 | 1 | Germany |
8-Apr-15 | 1 | Germany |
9-Apr-15 | 1 | Germany |
10-Apr-15 | 1 | Germany |
11-Apr-15 | 0 | Germany |
12-Apr-15 | 0 | Germany |
13-Apr-15 | 1 | Germany |
14-Apr-15 | 1 | Germany |
15-Apr-15 | 1 | Germany |
16-Apr-15 | 1 | Germany |
17-Apr-15 | 1 | Germany |
18-Apr-15 | 0 | Germany |
19-Apr-15 | 0 | Germany |
20-Apr-15 | 1 | Germany |
21-Apr-15 | 1 | Germany |
22-Apr-15 | 1 | Germany |
23-Apr-15 | 1 | Germany |
24-Apr-15 | 1 | Germany |
25-Apr-15 | 0 | Germany |
26-Apr-15 | 0 | Germany |
27-Apr-15 | 1 | Germany |
28-Apr-15 | 1 | Germany |
29-Apr-15 | 1 | Germany |
30-Apr-15 | 1 | Germany |
1-Apr-15 | 1 | UK |
2-Apr-15 | 1 | UK |
3-Apr-15 | 1 | UK |
4-Apr-15 | 0 | UK |
5-Apr-15 | 0 | UK |
6-Apr-15 | 1 | UK |
7-Apr-15 | 1 | UK |
8-Apr-15 | 1 | UK |
9-Apr-15 | 1 | UK |
10-Apr-15 | 0 | UK |
11-Apr-15 | 0 | UK |
12-Apr-15 | 0 | UK |
13-Apr-15 | 1 | UK |
14-Apr-15 | 1 | UK |
15-Apr-15 | 1 | UK |
16-Apr-15 | 0 | UK |
17-Apr-15 | 1 | UK |
18-Apr-15 | 0 | UK |
19-Apr-15 | 0 | UK |
20-Apr-15 | 1 | UK |
21-Apr-15 | 1 | UK |
22-Apr-15 | 1 | UK |
23-Apr-15 | 1 | UK |
24-Apr-15 | 1 | UK |
25-Apr-15 | 0 | UK |
26-Apr-15 | 0 | UK |
27-Apr-15 | 1 | UK |
28-Apr-15 | 1 | UK |
29-Apr-15 | 1 | UK |
30-Apr-15 | 1 | UK |
please post your expected result.
thanks
regards
Marco
Hi
PFA
Did the script step by step for understanding purpose.
in list box
bucket3
bucket5
when ever click in the bucket need to show last 3days sales in bar charts