Forum Discussion
Counting Rows in a Matrix [unsolved 15/01]
So let me explain:
I have imported the table "project risks" from an excel file on those different days shown in the filter so that I could see the changes in my values over time.
1) want to select a range from the date slicer and see what rows have changed from each table.
2) I want to create a card which counts those rows.
E.g. If I select 22/12- 24/12 and I have 3 rows that have changes between those dates then I want a measure which counts those 3 rows and displayed in a card.
So ultimately a measure which dynamically counts the number of rows shown in the matrix when filtered by "date created"
FU OK, so that I am absolutely clear. You may or may not have more than 3 rows in the matrix is that correct? But, you only want to count the rows where the status has changed between any dates, right? Or, do you want to count only if the min and max dates status is different?