Yearly,Weekly,Monthly charts

[Uma7]

Hi,

For the data of region,sales org based failed,success & failure % counts how to show 12 bars for monthly,4 bars for quarterly,7 bars for weeekly in combo chart of bars & lines based on time filters selected by users.
How can this be done?

[Sabrina_V]

You can make a hierarchical group with your dimensions : Quater, Month and Week

what value the users are selected ?

[Uma7]

filter pane has yearly/monthly/quarterly/weekly upon selection the bars should reflect as:
yearly -2 bars considering 2 years of data.

monthly-24 bars

quarterly-8 

how can this be achieved?

[Sabrina_V]

Ok so forget the hierarchical group.

a cyclic group and the user choose the axis he wants by clicking on the arrow 

[Uma7]

how to create a cyclic group fo year,month,week ?

[Sabrina_V · Accepted solution]

Use the alternative dimension in each object you create

[Uma7]

thanks