Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Line chart with below items
Dimension1 : =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)
Dimension2: Productname
Expression: Count(DISTINCT {$<DateType={'EnterDate'},Fromcolumn={'0'},Flag={2}>} ProductID)
I would need to show the trends of Products each week. How can I get this can anyone help me.
Thanks.
Dimension 1
and Dimension2 in dimension i.e first take dimension1 and then dimension 2
and expression in expression
product should appear as legends
hope this helps
Hi Amelia,
How you have it should show you the trends of products for each week. Is the line chart not showing anything or showing something incorrect?
Karl
Thanks and please can you make it a bit more clear.
Thanks. The values are correct but I need to show the count of moving trend line of products each week
So you have a table now and you want to make it a line chart?
No, I have line chart. In that line chart I need to show the trends. Is it possible?
What do you mean by trends? Line charts by themselves show trends.
Thanks. I need like attached. May be is it possible with Bar Chart. Is that correct?
Hi Amelia
See the Attached.
If found helpful than just add your expression in the Chart by replacing it.
Regards
Aviral Nag