Forum Discussion
Solved
Bars chart without repeated data
Hi! I am trying to create a bar chart without some repeated data. Imagine we have a table similar to this: TABLE1 TEST_ID CATEGORY SUBCATEGORY CHECKED 123 ...
Hi,
I think the desired output you have shown above is wrong i believe. There are only 2 distinct TESTID's for CAT1 and 2 for CAT2. In that case, it will show bar chart something like below.
If this is what required, To get only the unique test ids selected for categories. Keep TESTID as below and select distinct count.
Hope this one works.
Hi,
I think the desired output you have shown above is wrong i believe. There are only 2 distinct TESTID's for CAT1 and 2 for CAT2. In that case, it will show bar chart something like below.
If this is what required, To get only the unique test ids selected for categories. Keep TESTID as below and select distinct count.
Hope this one works.
