Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try the ARRIVAL_DATE as the dimension and under the expression type in =count(RECEIPT_REFERENCE)
Hope this helps.
try this
AGGR(count(RECEIPT_REFERENCE),Month)
Hi Chris,
Please follow these steps:
Thanks,
AMIT SAINI
Hi Chris
Check the Attachments
Regards
Aviral
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.