The task is to build migration matrix of 1 measure with possibility to change variable.
I have a table with various dates, clients and its ratings (which can change from date to date). I have made the variable input with dates, so I can switch them and all data on sheet is recalculated. th idea is to make matrix ( I use Heatmap chart), where I can see all the changes, and filter them by clicking on the concrete pile.
My code for measure is like aggr(only({<date={"$(vDate1)"}>}rating),client) , the same for vDate2. In table it shows me what needed, but when I click on heatmap pile - it gives mistake with incorrect parameters and shows incorrect data.
What I did wrong?
Moreover, when i'm trying to make measure to filter only clients with changes in rating, it gives me only "0", which is wrong. code is : =if ( aggr(only({<date={"$(vDate1)"}>}rating),client)= aggr(only({<date={"$(vDate2)"}>}rating),client),1,0).
How can I do it?
Thx in advance.
