-
1. Re: Unable to use COUNTD while blending data sources!!
Alvino Vaz Jun 8, 2019 11:58 PM (in response to Sri Kumaran Thirupathy)You could refer to the following articles
Count Distinct from Secondary workaround
Cannot blend the secondary data source because one or more fields use an unsupported aggregation
Hope this helps.
-AV.
-
2. Re: Unable to use COUNTD while blending data sources!!
Sri Kumaran Thirupathy Jun 9, 2019 10:35 AM (in response to Alvino Vaz)1 of 1 people found this helpfulThanks for sharing the articles! I have gone through these articles and found these are not feasible for my use case.
Use Case:
Source -
Category Sub-Category Sub-Sub-Category Job Run A B S1 6/1/2019 A B S1 6/2/2019 A C S2 6/1/2019 A C S2 6/2/2019 A C S3 6/2/2019 Steps -
00. Context filter to choose the period. Ex. Jun-2019
01. From the filtered set (Step-00), pick the latest run at Sub-Sub-Category level using LOD
{FIXED [Category], [Sub-Category], [Sub-Sub-Category]: MAX([Job Run])} = [Job Run]
02. From the filtered set (Step-01), calculate COUNTD of Category, COUNTD of Sub-Category, COUNTD of Sub-Sub-Category.
Any option to populate the flags dynamically? So that, I can do COUNT on the flags.
Category Category Flag Sub-Category Sub-Category Flag Sub-Sub-Category Sub-Sub-Category Flag Job Run A 1 B 1 S1 1 6/2/2019 A 0 C 1 S2 1 6/2/2019 A 0 C 0 S3 1 6/2/2019