Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a chart with DATE as dimension. So far so good ... Now, I'm trying to add WEEK numbers for better clarity (as in screenshot 1)
But when I add the WEEK dimension the chart gets completely messed up! I've no idea why ...
Regards,
Florian
Florian,
I think there are at least two issues here that mangle your chart:
First (the minor issue), the text on axis seems not to work correctly in your stacked bar chart with two dimensions and multiple expressions.
Second (the bigger issue), QV seems to show all dates for each week as dimension value, not only the dates that are linked to that week.
You see what I mean if you select say 2 weeks. No idea why QV does it this way, but it seems to work this way, I remember also some other posts here that described some similar problems (and noone came up with a clean solution, AFAIR).
I personally can only suggest some modifications to your app, having still only one dimension and showing the week number in a different way (as part of the text on axis). See attached for my suggestions.
Regards,
Stefan
Hi
Try like this,
Hope it helps
Thanks Mayil, but actually I'm trying to achieve a layout as you see in screenshot 1. Adding the weeknumber should just improve the usability of the chart ...
Regards,
Florian
Hi
I think that better approach to view the result more convenient for this data..
Florian,
I think there are at least two issues here that mangle your chart:
First (the minor issue), the text on axis seems not to work correctly in your stacked bar chart with two dimensions and multiple expressions.
Second (the bigger issue), QV seems to show all dates for each week as dimension value, not only the dates that are linked to that week.
You see what I mean if you select say 2 weeks. No idea why QV does it this way, but it seems to work this way, I remember also some other posts here that described some similar problems (and noone came up with a clean solution, AFAIR).
I personally can only suggest some modifications to your app, having still only one dimension and showing the week number in a different way (as part of the text on axis). See attached for my suggestions.
Regards,
Stefan
Hey Stefan,
okay, a bit weird though (bug?).
I like your workarounds, thanks a lot for your efforts!!
Regards,
Florian
Hi Stefan,
I'm having a similar issue.. However, it is not possible for me to open this file since i'm using a personal edition
Would it be possible for you to tell me your approach right here in the forum..? I'll try to work my way around it..
Would really appreciate your help!
Thanks
Hi Stefan,
I'm having a similar issue.. However, it is not possible for me to open this file since i'm using a personal edition
Would it be possible for you to tell me your approach right here in the forum..? I'll try to work my way around it..
Would really appreciate your help!
Thanks
The data model contains a Date, Weekday and Week field.
I used Date as dimension, three expressions for the stacked bar chart (display option bars) and one expression
=if(Weekday<>'Mo', Weekday,Week)
with display option text on axis.
Text format was set to
=if(Weekday='Mo','<B>')
and text color to
=rgb(100,100,100)
(in expression attributes for the text on axis expression).
So for each Monday, a bold week number is displayed on axis, for all other days, the weekday.
I think that's all.
Regards,
Stefan
Works for me Stefan.. Thanks a million!