Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how do I create a bar chart where the X axis is a subset of a field: ie: the field is [Day of Week}, how do I specify only "Mon" for that dimension? I'm trying to figure out what function that is, for the expression of that dimension. thanks
becki kain
Hi Becki,
if you want ALL your measure data, but everything aligned to Monday, the week start, then create a field in your data load like so:
WeekStart(YourDateField) as WeekStart
If you want to filter your data so that only meaure data relating to Monday is shown, then you can use a set analysis expression, for example if your measure is sum of sales it would be soething like this:
sum({$<[Day of Week]={'Mon'}>} Sales)
Marcus
May be this?
If(Match([Day of Week], 'Mon'), [Day of Week])
And do suppress for that calc. dimension.
what is suppress?
is that all Mondays or just one Monday? thanks
so that would sum sales on the other axis, and just show Mondays on the first axis? thanks
It would result in your expression only returning a value for Mondays, so the non Monday values in your dimension won't display
Can you share a screen shot with an expected output?
if I had a screen shot, I'd be done 🙂
You can always draw on a paint or something or on a piece of paper and take a screen shot of your expected output to be...