Forum Discussion
Chart visualization
You could try a line / area chart of accounts vs duplicates plotted over time, and put the categories (countries) as small multiple
Or, potentially do a cumulative burndown chart, with bars showing closed vs new, lines showing accounts and duplicates or planned vs. actual clean-up
Hi kellyylx
It is expected, a change in either of aggregations used in the stacked column charts will change the percentage of one to the total of both. So, if initially, active account is 2 and duplicate is 4, that would be 2/6 and 4/6 respectively. If active then becomes 1 and 4 remains the same, that would 1/5 and 4/5 respectively.
Unless you mean something else.
Hi, the duplicate count will always be smaller than the active count because I am counting the number of duplicates withint the active accounts.
I am wondering if there is a better visualisation/chart i can use that involves th Newly Created Acc Count column in the analysis of tracking the number of duplicates in each country
I dont think it's another viz that you need but rather getting the correct measures. If you could provide a workable sample data (not an image) and your expected result from that and the reasoning behind, I might be able to whip up some DAX measures for you.
