How do I group values as true/false in a pie chart?

[Tommy IKEA Sahl]

Hi all,

I need to create a pie chart, based on Knowledge Articles (table kb_knowledge) that are in the Draft workflow. Some of these KAs have been created based on an incident, others are created from scratch.

• If a KA is created based on an incident, the INC number is recorded in a field named Source Task.
• If a KA is created from scratch, the Source Task field is empty.

I can create the chart, grouping by the Source Task field. However, it of course shows a "slice" for every INC number, instead of the "empty/not empty" that I want. Does anyone know how to do this? Many thanks in advance  /Tommy

[Arav · Accepted solution]

Hi,

Try to group it by "Source Task.Task Type". That way it will show empty and incident as two options.

Note that it will display additional options in case knowledge articles are created from other classes too (like problem).

Thanks,

Arav

[Tommy IKEA Sahl]

Hi Arav,

thanks for your reply, what a clever solution! Worked just fine (as you can see in the screenshot) and the fact that it shows a distinction between INC and PRB is an extra bonus. ????

cheers  /Tommy 

[Arav]

Glad that it worked 🙂