Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to calculate the "count of the Orders" based on "device_type" for this Quarter and last Quarter.
I tried below one for this Quarter but that is always showing count 0 instead of the actual value.
Count({<ordered_on = {">=$(=Date(Quarterstart(max(ordered_on)), 'MM/DD/YYYY'))<=$(=date(max(ordered_on), 'MM/DD/YYYY'))"}>}device_type), where date format in my db looks like "06/01/2019 05:05:25 PM"
I see more examples using Quarter filters, but i don't want to use Quarter filters in my project. I need it to be applied in a column using Expressions. I tried modify most of the expressions to my needs from the community and nothing worked. I am looking for the working Expressions
Please guide me to achieve this.
Hi Usermonk,
I would suggest you to do it in 2 steps:
Thanks.
Martin
Or
Hi
Can you share sample data...
Regards,
Sunil Paul