Hello, I have the following problem. I want a chart where I want to compare some products of my store with products that I produce, where myProducts I want to represent them with lines and the other products with bars. I did this with my 3 product as a line and 1 product of a foreigner, but now I want to select more than 1 foreigner's products and not to lose the color pattern. To be more specifical
dimensions: Date, ProductName
expressions: myProduct1, myProduct2, myProduct3, =Only(ProductName)
I tried to just do it without my products and it is fine even if a product appears each time it has the same color
then I tried to put it all in one expression and I keep the coloring but I don't have the desired result where myProducts will be represented with lines and the foreigners' ones with bars
here is the expression
=(
sum(
{<
CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},
ChannelName -= {'myProduct1', 'myProduct2', 'myProduct3'}
>}
ProductStatistics.Total)
+
sum(
{<
CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},
ChannelName = {'myProduct1', 'myProduct2', 'myProduct3'}
>}
ProductStatistics.Total)
)
/
(
count(
{<
CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},
ChannelName -= {'myProduct1', 'myProduct2', 'myProduct3'}
>}
distinct ProductStatistics.DateTimeReaded)
+
count(
{<
CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},
ChannelName = {'myProduct1', 'myProduct2', 'myProduct3'}
>}
distinct ProductStatistics.DateTimeReaded)
)
