9 Replies Latest reply: Mar 20, 2018 12:50 AM by munirathnam p

Calendar Drill Down issue

munirathnam p Mar 19, 2018 7:54 AM

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

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?
Like Show 0 Likes (0)

Actions
- 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.
  
  Like Show 0 Likes (0)
  
  Actions
  - 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.
    
    Like Show 0 Likes (0)
    
    Actions
    - 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.
      
      Like Show 0 Likes (0)
      
      Actions
      - 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.
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        Like Show 0 Likes (0)
        
        Actions
        
        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.
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Calendar Drill Down issue
        
        Digvijay Singh Mar 20, 2018 12:45 AM (in response to Digvijay Singh)
        
        Drill down issue for one possible value
        
        Like Show 0 Likes (0)
        
        Actions
        
        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?
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post