Is there any way to split the dimension based on the selected date.Say for an example,If user selects 15 april to 15 may in period selector then I need to find the numbers of weeks in between and split the dimension( basically a table with that many number of rows)
@arusiva89 Why can't you add the week as your dimension and it will show only those weeks which are between your selection of period unless you are not picking period in a field
Date is my granularity. I need to show the values for the current period vs previous period for all dimensions(Date,Week,Month,Quarter) using buttons.Say for an example,if an user selects some 2 weeks in the period selector(assume week button is selected) then I need to break the table in to 2 rows.One for each week.
@arusiva89 Again I feel like what you are saying might just work just by adding Week as a dimension. or may be I am not entirely sure what you are looking to do. Would you be able to share a sample or some sample data and elaborate on your requirement by providing the expected output based on the sample provided?
problem is, I have associated dates with Flag to achieve the Previous period selected values. When I break the dimension for weeks & Month. I am getting value like this
.png){kind=link}