Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Expression that shows a list of Projects or items. Its tied to a Alternate state I would like to Calculate the Total count of rows for it without having to use the built in Total mode. Reason is I want to place it in on a different location.
I was considering using these functions, but have had any success.
NoOfRows() function or Count( TOTAL ) not sure what to use to replicate this TOTAL mode option.
If you simply want a count of the rows in a chart object you can use something like this:
Count({Alt_State_Here} aggr(1, Dim1, Dim2, Dim3 etc))
Replace Alt_State_Here with the name of your alternate state and Dim1, Dim2, Dim3 etc with the dimensions of your chart.
If you simply want a count of the rows in a chart object you can use something like this:
Count({Alt_State_Here} aggr(1, Dim1, Dim2, Dim3 etc))
Replace Alt_State_Here with the name of your alternate state and Dim1, Dim2, Dim3 etc with the dimensions of your chart.
Ok, so Aggr has to be used. Question on aggr(1, Dim1, Dim2, Dim3 etc)) is the 1, placed there on purpose ?
The 1 allows an output otherwise it returns 0. The current output should be 97 based on my selections, but is returning 830. Hmmmm. getting closer....
Ok, So I took what I had and added the aggr() as you mentioned. It Works. Thank you so much Gysbert!
=Count({Alternate_A <Project = $::Project, RevMonth = $::RevMonth, BacklogType = $::BacklogType, EndUserCat = $:: EndUserCat, WorkLocation = $:: WorkLocation, [BusSector] = $::[BusSector],
[ClientPartner] = $:: [ClientPartner], ProjType = $:: ProjType, RevType = $:: RevType, FlgCF = $:: FlgCF, Gate = $:: Gate, PWin =$:: PWin > } aggr(1, Project))