How to ensure data for each month gets displayed in one row in this table chart instead of2rows

Abhijith

Beast mode used

Approved Shifts = CASE WHEN `Approved` = 1 THEN SUM(`Total Charge`) ELSE 0 END

Unapproved Shifts = CASE WHEN `Approved` = 0 THEN SUM(`Total Charge`) ELSE 0 END

ST = SUM(`Total Charge`)

Kindly advise what could be done to rectify it. Thanks

GrantSmith

@Abhijith

wrap your entire case statement with the SUM instead of just the condition

SUM( CASE WHEN `Approved` = 1 THEN `Total Charge` ELSE 0 END)

SUM( CASE WHEN `Approved` = 0 THEN `Total Charge` ELSE 0 END)

amehdad

Hi @Abhijith, before the beast mode, in your ETL, add in a 'Group By' tile to group SUM(`Total Charge`) by MonthYear.

GrantSmith

@Abhijith

wrap your entire case statement with the SUM instead of just the condition

SUM( CASE WHEN `Approved` = 1 THEN `Total Charge` ELSE 0 END)

SUM( CASE WHEN `Approved` = 0 THEN `Total Charge` ELSE 0 END)

Abhijith

Thanks, @amehdad

Thanks, @GrantSmith