Comments
-
Hello @Lester_Tai , Thanks for reaching out to our community forum. Beast Mode (Percent Complete per Region) CASE WHEN SUM(`Ordered unit`) >= SUM(DISTINCT `PAR in PQ`) THEN SUM(DISTINCT `PAR in PQ`) / SUM(DISTINCT `PAR in PQ`) ELSE SUM(`Ordered unit`) / SUM(DISTINCT `PAR in PQ`) END >>> Apply the filters in the card or…
-
Hello @afieweger Thanks for reaching out to our community forum. 1. Use a Page-Level Filter (instead of a paired filter) i. Add a page-level filter using the SGId field from Dataset A only. ii. This allows the filter to recognize all SGIds, even if no corresponding record exists in Dataset B. iii. Both cards will respond…