Hello,
I put a “dimension command” in a report to toggle my charts to ‘months’ (“mois” in french) or “weeks”(“semaines” in french).
In my data sources, months and weeks are considered as dates.
If I set the “month” dimension in my chart, the weeks are not in the right order:
However, when I switch to month in Front Office, I don’t see the month total but several week totals…
I’ve tried everything but not the right solution, but perhaps you can inspire me?
Sorry for my bad english,
Jeff
Hi,
Just to clarify, in your source data, are the months and weeks in separate columns?
Hi,
I suggest checking the following: (sorry if you have done this already).
Check each bar chart is using the field “date_ajout” as the sort order.
If your “date_ajout” field contains the dates for more than one year, setting your Dimension Control as follows might help you.
Hello,
Thank you for your reply. I didn’t manage to do it. I put the same dimensions as you on my graphs and I sorted by “date_ajout”.
When in Front Office, I select by month, there is only one month which appears, there should be 2, and the number is not good.
When I select week, there are only 2 when there should be 6.
sorting is in date_ajout
Thank you for your help,
Hi,
It seems that something goes wrong when trying to use a date field to sort data in combination with a Dimension Control.
In the below example I have re-created the built in Dimension Control, by creating a ‘Parameter’ instead (‘LOD’), and using a calculated field(‘Month or Week’), and it seems to work. Does this help you? (if you make a copy of the dashboard you should be able to see the settings for each chart and fields).
