Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want my report to work as follows.
- When the report is opened and reloaded it should show data for today and the previews 6 days in a graph
- It should also be possible to manually select the date range you are interested of.
- it should be possible to drilldown in a graph between Hour-Day-Week-Month
The drilldown works OK if I manually select the date range but not if look at previous 6 days..
I added a button in order to make drilldown work but I prefer to not use a button and instead always be able to drilldown.
See enclosed qvw
/Stefan
Did you mean to use a Cyclic Group as opposed to a Drill-down Group ?
Yes. Cyclic Group is what I have used
Hi again!Maybe there is a better way to do this
Why not change it to a Drill-down Group ?
I have used this expression to get the previos n days (v.Previous) as default.
I also have a button that disables the formula (v.Dril).
What I would nee is a way to avoid the v.Dril button and still be able to drill down both for default 6 days and manually selected dat range.
if (v.Drill='1' , sum({<Date={">=$(=AddMonths(Max(Date-v.Previous),0))<=$(=Max(Date))"}>} RecordsIn) , sum(RecordsIn))
