I want to create the chart which counts the ID based on the following date values Today()-14,Today-30,Today()-90 and YTD. I thought of doing it by passing these days values in the cyclic group. Is it the right way of doing it. I am little confused how to do this. Does any one have sample application which does the same thing? If you can attach it will be helpful for me.
I wrote the expressions on my way home without checking, sorry for that.
I may also misunderstood your original question, I now think you were asking about the way to present your data, not to calculate them..
You could probably use a cyclic group or container to switch between the different values, but I am not sure if this the best way if you are not really out of real estate.
Maybe I would just show them side by side in a table or bar chart, but the periods for which the values are calculated differ, so you can't really compare them one to another, so I would make it pretty clear, what the difference (i.e. period) is. If these values are known KPIs, showing them all side by side (or in distinct objects, side by side) would be ok, I think.
It could also be valuable if you would compare the distinct values to e.g. last years values.
I think instead of using <= we need to use >=, as we are count based on Today() to Today()-14. What do you say? I am little confused with this expression plese clear my doubt. Hope needs are clear are for you.