How to create the visual

prashantg364 — Wed, 15 May 2024 09:29:47 GMT

Hi,

I have 2 tables in my data set.
Table 1 has 2 columns, Product ID & Category against each Product ID

Table 2 has multiple columns, showing service count of Category on a given date.

Ex 1: Product ID 123 has 3 Category - 1000,1001,1002 as shown in table 1

on 1 Jan, out of 3 only 2 category has service count i.e 1000 & 1001

Ex2:

Product ID 126 has 5 Category - 2001, 2002, 2003, 2004, 2005 as shown in table 1

on 1 Jan, out of 5 only 3 category has service count i.e 2001, 2002, & 2005

Output i am looking for to check on a given date which category has how many service count and which category has 0 count - as shown in Output table

Pls suggest

Table 1: Product ID-Category

Table2: Product ID-Category-Service

Output Table

Re: How to create the visual

xifeng_L — Wed, 15 May 2024 15:45:53 GMT

You can refer to below demo.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~