-
Re: Calendar Drill Down issue
Niclas Anderström Mar 19, 2018 7:57 AM (in response to munirathnam p)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
munirathnam p Mar 19, 2018 8:10 AM (in response to Niclas Anderström )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
Niclas Anderström Mar 19, 2018 8:11 AM (in response to munirathnam p)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
munirathnam p Mar 19, 2018 8:27 AM (in response to Niclas Anderström )Sorry Niclas...i can't share either query or app.
-
Re: Calendar Drill Down issue
Niclas Anderström Mar 19, 2018 8:36 AM (in response to munirathnam p)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
munirathnam p Mar 20, 2018 12:39 AM (in response to Niclas Anderström )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 Mar 20, 2018 12:44 AM (in response to munirathnam p)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
munirathnam p Mar 20, 2018 12:50 AM (in response to Digvijay Singh )Yes, Digvijay...i have only single quarter (for 2018).
Is that an issue?
-
-
-
-
-
-
-