6 Replies Latest reply on Oct 25, 2015 8:57 PM by Jane Crofts

    I have a very simple use case where I want to be able to create a drill-down filter which displays aggregate data based on year->month-.day.

    Antonio Ye

      I have a very simple use case where I want to be able to create a drill-down filter which displays aggregate data based on year->month-.day. Ideally, I have a bar chart that show the count for each year and want to be able to click on a given year and have the chart display the count for each month of that year and if I click on any month I want the chart to show the counts for each day of that month. I have created three dimensions from the date dimension using the create custom date and including them in a hierarchy dimension I create. I then added that hierarchy dimension as the column in my chart. I can drill-down but when I do the chart shows the yearly counts, the monthly counts, and all the daily counts but I only want the daily counts for the year and month that I am interested in. Any ideas on how to do what I want?