Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a barchart which shows month date in dimension and count as measure.. Right now it is showing 12/1 to 12/17.. but if we select November in filter it is showing 30 days(november) records..
But my actual requirement is by default it has to show last 30 days in my bar chart dimension.. that is 11/17 to 12/17.. and depends on calender selection , it has to show 30 days from the month Iam selecting. Any way we can do that..
no calculation made in dimension field
sum({<[Year Field]=,[Month Field]=, [Your Date Field]={">=$(=Date(Today()-30))<=$(=Today())"} >} SalesVolume)
Hi,
I am not using any aggr function like Sum , count in Dimension.. Using direct date field in dimension..
Any formula without sum function
Thanks for the reply. It worked in default view.. but when i changed the month in filter, data is not changing..