topic Re: Chart of 15 days evolution for different products in App Development

Chart of 15 days evolution for different products

jjmarti — Mon, 08 Jul 2019 17:17:38 GMT

Hey, I have a list of 20 different products with a different launch day... I want to show in a card the impact during the first 15 days of each product.

Product	Launch Date	Sales
A	22-01-2019	1000
B	22-02-2019	1300
C	22-03-2019	900

I just make here like total sales but I have the daily sales data

Thank you!

Re: Chart of 15 days evolution for different products

Lauri — Mon, 08 Jul 2019 20:26:36 GMT

I would use set analysis. With Product as the Dimension of the table, the Sales measure can be:

=Sum({<SaleDate={"<=$(=LaunchDate+15)"}>} Sales)

Re: Chart of 15 days evolution for different products

jjmarti — Tue, 09 Jul 2019 19:30:36 GMT

Hi!

Thank you for your help, maybe I was not 100% correct with my question..

I made an example about what I need exactly, is to check in a chart the first 15 days (even month or other) of each product that means that axis X must contains the number of days, months or others and the axis Y contains the Sum of sales for each of the days, month or other

You can see in the right side table that sales for product B start days later and even the Product C, but in the chart all the product have start at "day 1" till the end.

that means that the visualisation shows you, let me say, how good is your product and can proof a tendency about which product is going to be better with time. In that case looks that PRODUCT C is the best one for a new promotion and Product A had a bad performance and you need to change something

Re: Chart of 15 days evolution for different products

Lauri — Thu, 11 Jul 2019 17:39:15 GMT

I understand your goal now. Do you need help transforming your data? Or creating the chart?