Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field 'SIZE' Currently It has values: Grande, Tall and Medium. Sometimes Small also gets added in the records for the same field. Req is to create a straight table that shows count of records by size. My question is how do I show count for SIZE Small is equal
to zero when there are no records with 'Small' field value. Please help.
May be add a Inline Table Like this:
LOAD * Inline [
SIZE
Grande
Tall
Medium
Small
];
And then may be SIZE as dimension and Count({<UniqueIndetifier = {'*'}>}SIZE) and on the presentation tab may be uncheck 'Suppress When Zero'
Note: UniqueIndentifier needs to be a field which isn't null for the table where you have SIZE in. You would want to make sure to not use a field which can have null because then those nulls rows will be excluded.
Hi Sunny Thank you for your reply. I will post update soon