Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently I have a bar chart that gives me the total number of a holding bins.
However, sometimes theses hospitals have a number of different products
Currently I'm using the expression... "Count([Holding Bins])
I was wondering what kind of expression I could use to counnt the number of products in the holding bins as opposed to just the holding bins.
Hopefully that makes sense! Thanks for reading...
What do you use as you dimension now?
I'm thinking you might want to make [Holding Bins] your dimensions and Count([Products]) as your expression. This assumes Products are tied to a bin. Is this what you mean?
actually, i got it, no worries
used this expression... aggr(sum(quantity),[HoldinglBin])
Thanks for the help Moshea, appreciate it!