Creating charts - Help please :)

[#1]

Hi All,

I'm hoping this is a relatively straight forward question.

I have 2 tables holding data like below:

Table 1:

Status_ID	Status
1	Completed
2	In Progress
3	Not Started

Table 2:

REC_ID	Status_ID
764856	1
342454	3
124652	2
278095	1

I am trying to create a bar chart which counts the amount of REC_ID's completed and I want the axis to display the Status by looking up the Status_ID in Table 1.

Does anybody have any instructions as to how to do this? I am currently trying to display it in a Bar Chart.

Thanks

Victoria

[CELAMBARASAN · Accepted solution]

Hi,

     Use Status as Dimension.

     Expression as Count({<Status={'Completed'}>} REC_ID)

     Are you looking for this?

Celambarasan

[#3]

Thank you, That works a treat