Hi There, This line chart displays the daily production count for each day based on the start day and end day filter applied. [image] When I click on the drill down to hour option, the graph shows empty like the below image. [image] This is my calculated field to find the daily production value …

Hello @Harsheena , this is going to be a lot to explain but I think I have resolved your date issue. I’ll do my best to talk through this. So, I think the best solution with be a few steps. You want a user to select a day that will show them the hour by hour from 7am to 7am (a full 24 hours). My tho…

Hello @Harsheena ! I think it could be a few things happening at once. First, how are you trying to drill down to hour? I see that you have a control labeled “Period”, is that what you are attempting to use to drill down? Also, those two calculated fields are set to “Day” as their time period so t…

@WLS-D Hi, Thanks for your reply. Period Control is used for the conditional layout visualization. It has two values hourly and daily. When hourly is chosen it will show yesterday’s 24-hour production data. [image] When Daily is selected it will show the start day and end day parameters, and ba…

@WLS-D , Would you have suggestions on this issue?

Hello @Harsheena , the suggestion Duncan made I believe will be the best scenario for this. You can use the ifelse statement from the Period control to determine which value will show. One calculated field that will choose between Daily_Production or Hourly_Production then another for Hourly_maxgcnt …

Hi @WLS-DM , Thank you for your response. I have already implemented your second suggestion, which involves displaying hourly and daily production using the period parameter control with free-form layout conditional rules. [image] This is my hourly production report, which accurately shows the 2…

Hello @Harsheena , what if you used the calculated field I suggested, eliminating the drill down feature, and rather than using drill down to go into a specific day you add another control that would allow the user to select a day and filter you visual based on that parameter value? I think you are g…

Hi @WLS-DM , [image] If I create two controls for the start time and end time and then use the calculated field in the filter for these parameters, again the visual will show for 8 a.m. to the following day 11 p.m., it isn’t limited to the next day 7 AM Condition 3 = ifelse( addDateTime(7, ‘HH’,…

Hi @Harsheena , I forgot the hours were being handled by the calculated field rather than a filter. You wouldn’t need a filter then, they could just change the date connected to those parameters and it should work.

Hi @WLS-DM , I am a little confused now, not able to follow your last suggestion.

Hello @Harsheena , I mean you can create a control connected to the start date and end date parameters that will control the values for the calculated field. It will determine the day and then run the functionality through the addDateTime calculation that you created but you wouldn’t need an addition…

Drill down to hour shows empty visual

Q&A

WLS-DM September 22, 2023, 6:52pm 15

Hello @Harsheena, I know this is similar to the question we were working on, but this topic is becoming rather verbose. Could you please initiate a new question about this so we can keep solutions related to the specific question being asked?

Apply filter to change the visualization

Topic		Replies	Views
Dashboard Drill in/out for date Q&A feature-request , quick-sight , Business-Intelligence-Engineer	1	148	October 12, 2023
Apply filter to change the visualization Q&A filters , quick-sight , Business-Intelligence-Engineer	2	322	September 28, 2023
Drill down from Week to Day Q&A analysis , filters , date , quick-sight , visuals , calculations , Business-Intelligence-Engineer	6	103	December 20, 2024
Clustered Bar Combo Chart with Dynamic Drill Down on X-axis date field Q&A date , quick-sight , visuals , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	10	697	November 17, 2023
Link DateTime Field in the parameter to a dataset field Q&A quick-sight , calculations	10	1275	September 14, 2023

Drill down to hour shows empty visual

Related topics