Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please consider the following excerpt from a fact table:
Model SKU Jobs
=============================
Model3 SKU5 0
Model1 SKU1 1
Model1 SKU2 1
Model1 SKU2 0
Model1 SKU3 0
Model2 SKU4 1
Model3 SKU5 1
Model1 SKU2 0
Model3 SKU6 1
Model1 SKU2 0
Model4 SKU7 1
Model1 SKU2 0
... ... ...
This is the logic:
Now I would like to define these measures enabling visualizations based on the selected data set:
Your help will be greatly appreciated.
hi
you can use these expressions :
sum(aggr(if(count(distinct SKU)=sum(Jobs),1,0),Model))
sum(aggr(if(count(distinct SKU)>sum(Jobs) and sum(Jobs)>0,1,0),Model))
sum(aggr(if(sum(Jobs)=0,1,0),Model))
hi
you can use these expressions :
sum(aggr(if(count(distinct SKU)=sum(Jobs),1,0),Model))
sum(aggr(if(count(distinct SKU)>sum(Jobs) and sum(Jobs)>0,1,0),Model))
sum(aggr(if(sum(Jobs)=0,1,0),Model))
Thanks Liron for your time and expertise.
You have really helped my learning process!
Hi Sergio
It's my pleasure