I am trying to create a stacked bar chart of different diseases. Each bar should contain the disease's respective year (4 bars per disease). However, I am getting the total disease count rather than the count by year. I created a "Choose a Disease" parameter and a calculated field "p. Disease"
p. Disease:
CASE [Choose a Disease]
WHEN 1 then SUM([Hemolytic uremic snydrome post-diarrheal, Cum 2020†] + [Hemolytic uremic snydrome post-diarrheal, Cum 2021†] + [Hemolytic uremic snydrome post-diarrheal, Current week] + [Hemolytic uremic snydrome post-diarrheal, Previous 52 weeks Max†])
WHEN 2 then SUM([Hepatitis A, acute, Cum 2020†] + [Hepatitis A, acute, Cum 2021†] + [Hepatitis A, acute, Current week] + [Hepatitis A, acute, Previous 52 weeks Max†])
WHEN 3 then SUM([Hepatitis B, acute, Cum 2020†] + [Hepatitis B, acute, Cum 2021†] + [Hepatitis B, acute, Current week] + [Hepatitis B, acute, Previous 52 weeks Max†])
END
Is there something I could do to fix this? Thanks.
