Difference in Count of Synthetic Key Values

[chiranjivdas]

I have data from two sources:

File Name: Production

File Name: Sales

(please see attached)

I uploaded them and the synthetic Key is Model. In Production, there are 9 values under Model where as in Sales there are only 4. I want a chart to count only 4 Models and not 9. What script should I use in the Expression field?

Thanks,

CD

[swuehl · Accepted solution]

Maybe create another field in the Sales table:

LOAD

     Model,

     Sales,

     autonumber(Model) as SalesModelNum

FROM Sales.xlsx;

Then do a count(distinct SalesModelNum) in your chart expressions.

[rwunderlich]

Stefan's advice is spot on. You should ever count key fields as the results will be unpredictable.

-Rob