Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, I am trying to create a 3 month count for the various products that have been demo'd. Eg. If month selected is 'Aug', then the count would be for the months - Jun, Jul, Aug. I do not want it to be a distinct count. Could anybody please help me with it. Its really urgent. Must finish the report by Friday!# I tried using the Rangecount() with Aggr() but it provides distinct values. I tried set analysis using a variable but again I am unable to get the desired value. Your help is much appreciated.
Hi Sneha,
Is this something similar to what you are looking for?
If I choose a date from the date list box, the table only will show the number of companies within 3 months of selected date:
The expression I used:
Hope this helps.
Hi Sinan, In theory Yes, I am looking for something similar. My month field displays values as 'Aug, Apr' so can I use getfieldselected() here to do identify the past 3 months?? I want to be able to select a month and then create a chart with values for 3 months.
Thanks for your help
Hi Sneha,
You may need to add the below script to load script:
And then in your expression, you can write something like the below:
I am attaching the sample qvw in case you need it.
Hope this helps.
Hi Sinan, Your formula does work, but the problem I have is that it still gives a months data and not for 3 months. I am so not understanding where I am going wrong. Count(products) gives the same value as your formula. What can I do next?
Would you mind sending some sample data?
I cannot open an app so that's why I said just some sample data.
Thanks