It is easier to do above 10.3, by Join Calculation between all your Requests on 1:1, What I did, I did Same Thing, But Created another Table with 2 Columns Request and Number and Joined with Your data 1:1. and Filtered by writing a Calc and I think You Need this
If It Helps, Pl Mark It Helpful and CORRECT to Close Thread
Request- sample.twbx 58.6 KB
Deepak Rai, thank you for the quick reply. I understand the solution you have provided. In this method, I will not be able to filter by other features, which is important for us. So I need to present an analysis where the filtering is possible.
This is to help others,
I was able to find a solution that suited my needs. My database has a huge number of rows and columns. The above-proposed solution would duplicate all the other columns in the database. This would pose a problem for me because some of the columns are supposed to be unique values. Also, I had 3 more columns that had multiple values in each row. Either would have to create separate databases for each sheet to analyze each of the columns. Also added newer records would not be easy. So here is what I did:
I created calculated fields for the columns that had multiple values for the row. 1 calculated field for every unique value. That way for Request I created 4 new columns- Request1, Request2, Request3, and Request4. Check for the substring and add 1 under the particular column if the value is present.
Drag the Measure values to Rows. Remove the measures you do not need from the Measure Values card.
By default, Measure Values had numbers with the decimal part. So I changed the format.
Then drag and drop the Measure Names into columns. It should automatically show up under Filter and Marks cards.
to improve the appearance I added color and the total number of the count on the sheet. Also added few other dimensions into the Filter card, which was a requirement for me.
Request- sample.twbx 22.4 KB