Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Someone have already made a Sales and Buy graph like this please :
I would like someone share its methode because my methode prevents me to add some option like filter on a another category.
Hi, @Irache
You can try the following methods.
Sample data:
Is this the result you expect? If not, can you provide sample data for testing? Sensitive information can be removed in advance.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
This is what I want but how do you make this calcul and can you filter on a category ?
Hi, @Irache
What does your source data look like? What does the category look like?
Please refer to the attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a database which contain lot of article with a "in" date, "out" date and a shop it's not concern sales and buy but it's the same idea like this :
Article | Shop | IN week | Out week |
A1 | A | 2023-04 | 2023-05 |
A2 | A | 2023-05 | |
A3 | B | 2023-05 | 2023-06 |
For exampl they two IN and one OUT for fifth week of 2023, and if we specify by shop for the A shop I have one IN and one OUT for the same week. I want to make a visualisation like I show in my previous message except that the method I use makes it difficult to filter this visualization by store.
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
20 |