Hello,
I need help to create a symmetrical matrix, day-wise. and also thinking that is possible or not.
pbix file : FileDownloadpdix
it should look like this :
Explanation :
In pbix file, Test 1 column contains all events(names), Test 2 column contains all ids,
so supposed I choose one date like
15 April 2020 then It should show me data in the symmetrical matrix(symmetrical matrix pic reference which I shared).
Like: (horizontally)
- 15 April:
- 1st block: count of distinct ID's who has the name "Create Account" on 15th April
- 2nd block: show in percentage same Ids who match(at least one) with any other names(except Create Account) for 15 April
- 3rd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 16 April
- 4th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 17 April
- 5th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 18 April
- 6th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 19 April
- 7th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 20 April
- 8th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 21 April
- 9th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 22 April
- 16 April(next line):
- 1st block: count of distinct ID's who has the name "Create Account" on 16th April
- 2nd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 16 April
- 3rd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 17 April
- 4th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 18 April
- 5th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 19 April
- 6th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 20 April
- 7th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 21 April
- 8th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 22 April
- 17 April (next line):
- 1st block: count of distinct ID's who has the name "Create Account" on 17th April
- 2nd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 17 April
- 3rd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 18 April
- 4th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 19 April
- 5th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 20 April
- 6th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 21 April
- 7th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 22 April
So on till 22 April
same Ids, Means which you are uniquely counting on 1st block for each date.