Hi all,
I'm trying to solve something a bit weird. It was working correctly, and without doing anything, my card is not working anymore. When I'm editing it, it's completely broken
Type of data
date|service|daily_service_sales|placement|daily_placement_sales
2021/04/01|Service_A|80|Placement_AA|10
2021/04/01|Service_A|80|Placement_AB|12
2021/04/01|Service_B|40|Placement_BA|13
2021/04/01|Service_A|90|Placement_AA|20
2021/04/01|Service_A|90|Placement_AB|10
2021/04/01|Service_B|30|Placement_BA|8
2021/04/01|Service_B|30|Placement_BA|6
What I'm trying to achieve is to build a is a Line + Grouped bar chart per week with 3 types of data
You can notice that the daily_service_sales values is repeated each time a placement is performing
3 beast mode are used into the following card
weekly_service_sales : sum of unique daily_service_sales per week
(SUM(SUM((daily_service_sales)) OVER(partition by YEAR(`date`),WEEK(`date`), `service`))
weekly_placement_sales: sum of daily_placement_sales per week
(SUM(SUM((daily_placement_sales)) OVER(partition by YEAR(`date`),WEEK(`date`), `service`))
weekly_ratio : weekly_placement_sales / weekly_placement_sales
The current card
When I'm trying to edit it or trying to create a new one.
Am I doing something wrong?
Help me please,
Julien