Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushi2020
Creator II
Creator II

Sanky Chart Count not showing correctly

Hi All, 

I am using a Sanky chart here. When i am adding dimensions in that with a measure the numbers are showing in correctly on that. when I am checking it with a Pivot table, it is showing correctly. Please suggest. 

measure: 

count({<RP_Type={'Prep'},Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}distinct Id)

kaushi2020_1-1722925058487.png

 

Below is the expected count for Prep:

kaushi2020_0-1722925039551.png

Similarly for Status, For Active below is the count when used a KPI. But in Sanky it is different. 

kaushi2020_2-1722925119672.png

 

Please suggest. thanks in advance. 

 

0 Replies