Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a set analysis expression which uses the union operand ("+") to identify unique Order Numbers that may be affected by errors from 2 areas.
Count({$<FOCGroupClass = {'Damaged'}>+<[Credit Reason] = {'Damaged Goods'}>}DISTINCT [Order Number])
We have a field called FOCGroupClass which indicates whether the Order was damaged, and similarly, we have a field called CreditReason which will also capture where an Order has been damaged. I need to count the unique Order numbers that have been affected which the above expression does very nicely within a table.
However, when i wish to use this in a chart with a week dimension and a year dimension, the Year dimension is being ignored.
Is there another aspect that needs to be included in the Set Analysis to take this into consideration?
Hope this is clear, if not, i can attach the file.
Thanks,
Nick
Yeah, a line chart is limited to two dimension + one expression or one dimension + any number of expressions. You could create more expressions for every year-supplier combination. But you might as well create that as a calculated dimension: supplier&'-'&year
Hi,
Can you attach the sample file.
Regards,
Jagan.
Not a problem,
Please find enclosed.
Thanks for your help
Nick
As far as I know you can use only one dimension in a line chart. There's only one x-axis after all. What do you expect to see in the chart?
I was hoping that it would create separate lines for each year such as;
I'm assuming this doesn't happen since i have more than one expression in the other chart? Is there anyway i could create the above image with multiple expressions as well?
Yeah, a line chart is limited to two dimension + one expression or one dimension + any number of expressions. You could create more expressions for every year-supplier combination. But you might as well create that as a calculated dimension: supplier&'-'&year
check the sample this might be you expected
Thanks Sivaraj but that then hides the split by Supplier.
I have taken Gysbert's advice and have built an expression for each year.
Thanks everybody for their help.
Nick