Need help in buliding a Gauge chart which shows weekly changes

[Anonymous]

Hi Experts,

I'm new to clikview and really need your help.

I have a data and weekly data will be appended to this file.

Based on selected weeks, i want to track if there is any difference in records,
if there is difference in count the gauge should point at 'Change' if not 'No Changes' and other gauge should point out increased or decrease in those weeks.

Below is the sample data,

1) in the below data If i select weeks 27/20/2017 and 12/11/2018, one gauge should show as changed since record count decreased, and other gauge should show decreased.

    If i select weeks 27/20/2017 and 2/10/2018, one gauge should show as No changes and other gauge can point in center, since record count matches.

2) second thing if possible, a box which show which items(game column) are not common in those selected weeks.

sample data:  

S.no	Game	Rule1	Rule2	Week	Week no
1	Cricket	11 members game	six balls per over	27/10/2017	1
2	basketball	5 members game	Player Positions	27/10/2017	1
3	Vollyball	6 members game	Maximum of three hits per side	27/10/2017	1
4	Cricket	11 members game	six balls per over	2/10/2018	2
5	basketball	5 members game	Player Positions	2/10/2018	2
6	Vollyball	6 members game	Maximum of three hits per side	2/10/2018	2
7	Cricket	11 members game	six balls per over	12/11/2018	3
8	basketball	5 members game	Player Positions	12/11/2018	3
9	Cricket	11 members game	Three balls per over	18/11/2018	4
10	basketball	5 members game	Player Positions	18/11/2018	4
11	Vollyball	6 members game	Maximum of three hits per side	18/11/2018	4
12	Hockey	11 members game	Offside (or two-line)Pass	18/11/2018	4