Please find the attached work book.In the sheet all meters i am showing responded and not responding meters from two different data sources( PrTotalServices and PrTotalDCwiseMeters) . in page aaimatha-2 based on feederid total meters are 5752 and responded meters are 4904 only. I need the calculation based on feederid (PrTotalServices) (or) feeder in other data source ( PrTotalDCwiseMeters).
need to show in pie based on feederid or feeder -5752-4904=848 as not responded.
thanks in advance
suresh.
@Suresh Pusuluri Hi, l looked at your calculations and the only thing that I added was the filter options into the calculations. The first calculation I removed the filter and added into the calculated field COUNT(IF [FeederId]=19 THEN [ServiceNo] END). Similarly for the other data source. COUNT(IF [Feeder]="AAI MATHA" THEN [Service No] END).
Here's the end result.
For your use, I attached the revised workbook.
Many thanks,
Tatyana Nikolova
2023 Tableau Forums Ambassador
**If this response resolved your query, please "Select as Best"**
