Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I don't get the behaviour of my barchart and the data behind it. I want to see all the sales per month for the current year. In addition the sales are divided by the workdays ("AT je Monat") per month.
This is the Set Analysis that I'm using for that with some other filters:
(sum( {1<
[Businessyear] = {$(=year(today(2)))}
>}
sales
))
/
[Workdays per month]
This is how the chart looks like without any other filters:
Only two months are shown which is not correct
This is how the bar chart looks with a filter for the business year (here 2019). I don't know why it works here with the filter...
Do you have any idea?
Thanks!
Hi,
I think the problem is
/ Workdays per month
which are many values in one month over the years
so change to
max({{1<[Businessyear] = {$(=year(today(2)))}>} [Workdays per month])
that only one number of business days per month are calulated
Regards
Hi,
I think the problem is
/ Workdays per month
which are many values in one month over the years
so change to
max({{1<[Businessyear] = {$(=year(today(2)))}>} [Workdays per month])
that only one number of business days per month are calulated
Regards
It works! Thank you so much!