Unable to slice the data at quarter level.

[deepak_d03]

I have a master table that has the list of JIRA items information. (Created date, closed date, status, created by etc). I have a date table created and connected to the master table. Date table has the columns for month, year and quarter. I am trying to get the count of JIRA items opened at a quarter level. SO created a measure using countrows(mastertable). I am then trying to slice the measure by using the Quarter column from the Date table using a matrix visual, but I am always getting the total count and not at the Quarter level. 

[deepak_d03]

@tamerj1 - The 'final' table is the resultant of appending 2 other tables. So the data model has a 1:1 relationship between these tables. Not sure if this creates any issues here. Please suggest.

[deepak_d03]

The quarters I created from the date table are Q1-23, Q2-23, Q3-23, Q4-23 and Q1-24. I have these as the rows for the matix visual but then only the columns name 'Quarter' is displayed. I expected 5 rows for the above quarter values. 

[tamerj1]

Hi @deepak_d03 

connected via which column?

[deepak_d03]

the date from the date table and the created date from the master table

[tamerj1]

@deepak_d03 

Please make sure the relationship is set to active and that you are using the correct columns from the correct tables. 

[deepak_d03]

relationship is active and columns too are correct. IS there anything else you can think of why it doesn't work? The data and tables are in another laptop so I cannot really put it here. 

[tamerj1]

@deepak_d03 

Either the the measure refereces the wrong tsble or the quater column placed in the matrix is from a wrong table or you are placing a totally wrong measure. Nothing else I can think of. 

[deepak_d03]

If I drag the quarters column first, I can see 5 rows. But when I pull the measure to the values field, thats when the 5 rows vanishes. So I guess the measure (COUNTROWS('final') - 'final' is the other table having all the master data. ) isn't compatible here? The problem could be the way the measure has been defined?

[tamerj1]

@deepak_d03 

Check the data type of both date columns in both tables. 

[deepak_d03]

@tamerj1  - They are both the same.