Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to make a text box where I can do something along these lines.
=Count({<Status={'In Production'}>} Status)
The problem is that the number should come out to being about 4,000 but it's only coming out to 3.
When I make a multi box, I can select the "ITMS Type", "Status" (which is In Production), and then I can get a count of those two combined variables because I sent a count command using SQL.
What I want is the count of all ITMS Types with the Status of "In Production". How do I go about doing that?
I worked around it by using SQL code "SQL SELECT * FROM db WHERE db.tbl.[Application Status] = 'In Production'"
After that I did "=Sum([Count of ITMS Type])" in the Text field of the Text Object.
Problem solved.
Try counting [ITMS Type] values instead of Status: =Count({<Status={'In Production'}>} [ITMS Type])
maybe something like this
sum(aggr(Count({<Status={'In Production'}>} Status),["ITMS Type]))
Would you be able to share a sample to show the issue you are facing?
I worked around it by using SQL code "SQL SELECT * FROM db WHERE db.tbl.[Application Status] = 'In Production'"
After that I did "=Sum([Count of ITMS Type])" in the Text field of the Text Object.
Problem solved.