InQuarter Count

[knightwriter]

Hi all,

I have discussed previously the issues I was encountering for my InQuarter count and I thought it maybe be easier to start fresh.

I am looking to count the number of activities by quarter depending on the what Year the user has selected. I am using 2015 & 2016 data only and cannot get it to change result when the year selected changes. Below is what I am currently using. Many thanks.

=(Count(Distinct If ( [Activity.Status]='Completed' AND InQuarter([Activity.Completed Date], Yearstart(Today()), 0), [Activity Id], )

[sunny_talwar]

Which Quarter's value would you like to see here? Quarter 1 or all Quarters?

[knightwriter]

Hi Sunny,

I would like 4 separate List Box Properties - one for Q1, a second for Q2 etc

[maheshkuttappa]

Could you share sample data ?

[knightwriter]

Does this make sense? Or should I take a different approach?

As per sample below.

[avinashelite]

may i know why your using the Yearstart in your expression because it always starts your date with the 01-01 for that year so it always corresponds to that particular Quarter or Q1. could you please elaborate bit more on this