Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Kok,
Below picture illustrates how drill down works, if thats not how you intended, use cyclic group provided by 'Frank Hartmann'.
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.
see attached file.
try creating a cyclic group. then you are able to switch.
hope this helps
Hi Federico,
I got the solution already, thanks anyway for the font size.
for your second probleme try as following:
Hi Kok,
Below picture illustrates how drill down works, if thats not how you intended, use cyclic group provided by 'Frank Hartmann'.
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
have a look at attached sample!
hope this is helpful!
---- Edited ----
Hi Frank
Doesnt work on my version, not sure what is missing.
Showing '1' and '4'
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!