Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Can anyone help me about below scenario.
I want to display the count of Wais Number for Top 20 codes and In that top 20 codes I want to display the count of Wais Number for Top1,Top2 till Top20 codes in seperate line chart(20 Line charts for each code) for perid dimension from 2019/05 to 2020/04.
whenever i select the Number dimension values it should dynamically change the Top20 codes as well.
For your reference i will attach sample data.
Pls anyone can help me.
Thanks
What is your measure? Let's say that you want top 20 by count(code), you can try this
Count({<[Wais Number] = {"=Rank(Count(Code)) < 21"}>} Code)
Hi Sunny,
Above expression is not my requirement,My Expression is Count([Wais Number]). In that i want ot display top 20 Codes in bar chart and among Top20 Codes i have to create line chart(use period as dimension) for each code in.Means Top1 in one line chart and Top2 in another line chart, similarly for other codes till top20 codes.
Thanks,
Vinod