Hi,
I have no idea why this isn’t working. What is supposed to happen is the bar chart would calculate the current year and then using the reference point as a previous year. But the calculation works on a crosstab but is not recognizing the fixed part in the bar chart. Attached is a workbook along with these screens. In the real data, there are multiple org type so I’ve limited it for this question to one. You can see when both calculations are in the cross tab (red tab) the countd part is working like it should and when inserting that part into the dynamic org counts, it just ignores it and counts every unique id. If I can get the dynamic org counts current calculation working then I’ll use the same thought for the prior calculation.
Any ideas?
Thank you!
@Thomas Pierre
Hi, I guess you may use:
{ FIXED [Kindship Location ID K] :
COUNTD(IF [Current Date Period] THEN [Uniquie ID] END)}
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
