expression used for chart properties, dimensions

[becki_kain]

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

[marcus_malinow]

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

[Anil_Babu_Samineni]

May be this?

If(Match([Day of Week], 'Mon'), [Day of Week])

And do suppress for that calc. dimension.

[becki_kain]

what is suppress?

is that all Mondays or just one Monday?  thanks

[becki_kain]

so that would sum sales on the other axis, and just show Mondays on the first axis?  thanks

[marcus_malinow]

It would result in your expression only returning a value for Mondays, so the non Monday values in your dimension won't display

[vishsaggi]

Can you share a screen shot with an expected output?

[becki_kain]

if I had a screen shot, I'd be done 🙂

[vishsaggi]

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...