Bar Chart Help

[#1]

Good morning all.  I am stuck on creating a bar chart and wondered if you can pleae help.

Background:

5,000 receipts happened over two months.  The basic data of ARRIVAL_DATE (Date transaction occurred) and RECEIPT_REFERENCE (transaction reference) is needed to make a graph - BUT I have not had much experience with this.

Basically, I want to create a graph with a different bar for each month (as the X axis), showing a count of the receipt references  .

Similar to the below;

I am confused as to what should be a dimension and what should be an expression.

Can you please help?

cheers

[albertovarela]

Try the ARRIVAL_DATE as the dimension and under the expression type in =count(RECEIPT_REFERENCE)

Hope this helps.

[#3 · Accepted solution]

try this

AGGR(count(RECEIPT_REFERENCE),Month)

[amit_saini]

Hi Chris,

Please follow these steps:

1. Right click--->New Sheet Object--> Charts
2. Select  Bar chart
3. Select  ARRIVAL_DATE as Dimension (Which belongs to X-axis)
4. Write Count(RECEIPT_REFERENCE) in Expression

Thanks,

AMIT SAINI

[aveeeeeee7en]

Hi Chris

Check the Attachments

Regards

Aviral

[#6]

hi

Dual(Month(MyDate) & '-' & Date(MyDate, 'YY'), Num(Year(MyDate)) & Num(Month(MyDate), '00')) AS MonthYear, 

as dimension.

Note the Date(MyDate, 'YY') in the expression above.