topic Re: Calendar Drill Down issue in App Development

Calendar Drill Down issue

rathnam_qv — Mon, 19 Mar 2018 11:54:14 GMT

Hi All,

I have created a drill-down group like Quarter-->Month-->Date.(Have data only for Current year).

But Quarter is not coming in the drill only Month-->Date is working fine.

What will be the reason for this.

Any help is appreciate.

Thanks,

Muni.

Re: Calendar Drill Down issue

niclaz79 — Mon, 19 Mar 2018 11:57:47 GMT

Hi, this would happen if the quarter is not properly defined in your model or if it's not available based on your other selections. Could you provide more info on your model itself?

Re: Calendar Drill Down issue

rathnam_qv — Mon, 19 Mar 2018 12:10:16 GMT

Hi Niclas,

I am using single table not joining any other table to it and i am using a DATE filed and calculatin Quarter,Month from it.

Thanks,

Muni.

Re: Calendar Drill Down issue

niclaz79 — Mon, 19 Mar 2018 12:11:54 GMT

Is there a chance you can provide the script for calculating the quarter, or even the application itself? It's much easier to click in an actual application to find out where it goes wrong.

Re: Calendar Drill Down issue

rathnam_qv — Mon, 19 Mar 2018 12:27:39 GMT

Sorry Niclas...i can't share either query or app.

Re: Calendar Drill Down issue

niclaz79 — Mon, 19 Mar 2018 12:36:08 GMT

Ok, then without any screenshots, code or other information it's where hard to figure out what has gone wrong.

Re: Calendar Drill Down issue

rathnam_qv — Tue, 20 Mar 2018 04:39:00 GMT

Hi Niclas,

PFB logic which i am using to extract Year,Quarter and Month.

Year(Date_Field) as Year,

'Q' & ceil(month(Date_Field)/3) as Quarter,

Month(Date_Field) as Month,

Thanks,

Muni.

Re: Calendar Drill Down issue

Digvijay_Singh — Tue, 20 Mar 2018 04:44:55 GMT

Do you have a single quarter in your data? Currently there is a bug in drill down design, it skips the dimension and goes to the next one automatically if there is only one value selected or available for that dimension.

Re: Calendar Drill Down issue

Digvijay_Singh — Tue, 20 Mar 2018 04:45:52 GMT

Drill down issue for one possible value

Re: Calendar Drill Down issue

rathnam_qv — Tue, 20 Mar 2018 04:50:48 GMT

Yes, Digvijay...i have only single quarter (for 2018).

Is that an issue?