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, 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.