Forum Discussion
Table with Dynamic Column
Hi, Anonymous
Is this the result you expect? There is no direct relationship to the date column.
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.
Hi, Anonymous
Based on the data you provided, can you give 2 examples of what your desired output is? Sensitive information can be removed in advance. You can also show it with Excel.
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.
Hi v-zhangti
Refer to this sample, please.
User input: 30/04/2022
"Data Considerada" = "User input" + 3
"O-Q" = "Data Considerada" - "Data-base fim"Input:
Order ID Category Data-base fim Data Considerada O-Q B Plan Critico B Critico 1 001 04/10/2021 03/05/2022 211 1 0 1 2 001 24/01/2022 03/05/2022 99 1 0 0 3 001 24/01/2022 03/05/2022 99 1 0 0 4 001 14/03/2022 03/05/2022 50 1 0 1 5 001 07/03/2022 03/05/2022 57 1 0 0 6 001 23/11/2021 03/05/2022 161 1 0 0 7 001 20/11/2021 03/05/2022 164 1 1 0 8 002 08/11/2021 03/05/2022 176 1 0 0 9 002 06/12/2021 03/05/2022 148 1 0 0 10 002 06/12/2021 03/05/2022 148 1 0 0 11 002 13/12/2021 03/05/2022 141 1 1 0 12 002 15/11/2021 03/05/2022 169 1 1 0 Total 12 3 2 Output
Category Sum of B Plan Sum of Critico Sum of B Critico 001 7 1 2 002 5 2 0 Total 12 3 2 It doesn't need necessarily to show total on the table.
What I do need is a total to show in a card visual. But if a insert "B Plan" in a card, for example, it doens't show the total = 12.
I also need these results to sum to another measures from another table.
Hi, Anonymous
Is this the result you expect? There is no direct relationship to the date column.
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.