I have three columns: cd_store_id, cd_cluster, and dt_created_at. Using these, I want to create a line chart where each line shows the percentage of each cd_cluster relative to the total number of cd_clusters (which matches the total count of cd_store_id).
Each cd_store_id has a unique line and a unique cd_cluster, so I think you guys can ignore this column.
Similar to the image below, but instead of bars, I need lines for each cd_cluster, and instead of raw counts, I need the percentage of the total for each month.
There is nice article in the learning section that could guide you to computive Percentage of Total calculation and use the same in your desired visualization.
Hi @Marcelo_Antonio_Pasq,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
