Guage, expression, two tables!

[#1]

Please can someone help me with the attached example.

I have two tables on the attached:

CONCERNS and TRANSACTIONS.

I would like to create TWO guages - one for the current month and one for the previous

month which show the percentage of concerns.

To work out the no of the concerns I need to do a count on concernID

To work out the transcations do a count on the pick column where it is '1'

So for example - current month

needs to be count of concernID / Count of Pick * 100 BUT only for the current month ?

can someone help me achieve this?

I also do not want to fix it so that I can select on plant that only appears in the transactions table !!

Thank you

[Anonymous]

their is only one table which is Concern only

[Anonymous · Accepted solution]

try like this:

CurrentMonth:

=(Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField)))'}>} concernID )

/

Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField)))'}, PickField={'1'}>} concernID or PickID))*100

Previous Month:

=(Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField))-1)'}>} concernID )

/

Count({<MonthField=,Year=,MonthField={'$(=max(month(DateField))-1)'}, PickField={'1'}>} concernID or PickID))*100

[#4]

Oops!  Added

[Anonymous]

NP, you can try expression shared with you earlier

[Anonymous]

Again, how these two tables are linked as their is no mapping of these two tables?