user047019 Member

Thanks both, let met investigate and come back to you

Impossible to achieve that.. I really don't understand why it's not working

What I want to get is the chart per week. Fully aggregated. and I have another card to be able to select Service(s) and/or placement(s) Here is the graph with those beastmode weekly_placement_sales: (SUM(SUM(`daily_placement_sales`)) OVER(partition by YEAR(`date`),WEEK(`date`))) weekly_service_sales :…

Here is the result And when I'm filtering on a specific service:

And now, when I'm trying to build a new dashboard from a new data set with new beast mode, duplciation of week is happening all the time.

Thanks for trying to help me I 'm sortering my graph by date. And I don't have so much specific properties I'm trying to show this graph per week. As you can see, on the second chart, there is a multiplication of number of week. When I'm trying to share calculation through Dataset, the duplication on the graph is happening.

Thanks all

hi @jaeW_at_Onyx , Thanks for that quick answer. I was thinking about that solution but I would have to multiply all the existing line by the number of currency I want to track . It's a cumbersome solution. But thanks anyway.

By any chance, is it possible to integrate automatically this tags on the dataset? Instead of doing that manually one by one