switching timeframe chart in dimension

[#1]

Hi there,

I trying to do a monthly and weekly trend chart switch.

But it doesnt let me toggle the change between monthly or weekly.

And how can i change the font size of the value in the chart?

I cant find it anywhere to change it.

Thanks

[fvelascog72]

Hi,

Can you explain more your first question?

To the second question you can use:

If(Month=6,'<B>'&'<I>'&'<U>'&'<H1>')

in Text Format in graphics attributes of the expression.

[Frank_Hartmann]

see attached file.

try creating a cyclic group. then you are able to switch.

hope this helps

[#4]

Hi Federico,

I got the solution already, thanks anyway for the font size.

[Frank_Hartmann]

for your second probleme try as following:

[#6 · Accepted solution]

Hi Kok,

Below picture illustrates how drill down works, if thats not how you intended, use cyclic group provided by 'Frank Hartmann'.

[#7]

Hi Frank,

I have managed to do the switch time frame on the chart by cyclic group.

How can i create a separate Button instead to toggle the time frame(month,week,day) instead on the chart itself.

Thanks

[Frank_Hartmann]

have a look at attached sample!

hope this is helpful!

---- Edited ----

[#9]

Hi Frank

Doesnt work on my version, not sure what is missing.

Showing '1' and '4'

[Frank_Hartmann]

in the listbox you will have to put this formula to the expression, not to the title:

=if($Field='Week',$Field,if($Field='Month',$Field,if($Field='Day',$Field)))

In the charts only use this expression as dimension:

=$(= '[' & ONLY($Field) & ']')

Thats it. See attached sample

hope this helps!