Forum Discussion
Table Visualization; Ignoring part of a relationship?
Solution Found: Firstly, I duplicated the query and established an additional relationship between the 'Quarter' in the dates table and the duplicated 'Quarter' in the assessment table. Next, I introduced a measure to the visual column using an IF function. This function considers the selected value from the first table for 'Target' and the selected value from the duplicated table (with the extra quarter relationship) for 'Non-Target.' As a result, the visualization now displays either one date or is empty for 'Target,' and for 'Non-Target,' it showcases the same date three times across all months in a quarter or remains empty, achieving the desired outcome.
Solution Found: Firstly, I duplicated the query and established an additional relationship between the 'Quarter' in the dates table and the duplicated 'Quarter' in the assessment table. Next, I introduced a measure to the visual column using an IF function. This function considers the selected value from the first table for 'Target' and the selected value from the duplicated table (with the extra quarter relationship) for 'Non-Target.' As a result, the visualization now displays either one date or is empty for 'Target,' and for 'Non-Target,' it showcases the same date three times across all months in a quarter or remains empty, achieving the desired outcome.