Forum Discussion

bubbletao's avatar
bubbletao
Frequent Visitor
7 years ago
Solved

Create a histogram from calculated measure and joined tables

I am attemping to create an histogram to show the distribution of a metric(Bounce Rate) from number of customers.   The end goal can be shown  in the following example excel chart, and it needs to ...
Need Help
bubbletao's avatar
bubbletao
Frequent Visitor
6 years ago

Hi v-juanli-msft  Thanks for the sample file. 

 

I am still having a hard time understanding the logic of the measure.  Can you provide a bit more context, why this works etc?

Measure = var m=SUMMARIZE(SiteTraffic,SiteTraffic[customer id],"m1",CALCULATE(IF(MIN('Table'[min])<=[BounceRate]&&(MAX('Table'[max])>=[BounceRate]||MAX('Table'[max])=BLANK()),1))) return COUNTX(m,[m1])

In the meantime, I have found out using a Python Script custom visual can bridge the gap.  The catch here is the python visual is much slower than the native column chart, especially applying slicer. 

dataset = dataset.dropna()
import matplotlib.pyplot as plt
import seaborn as sns
sns.distplot(dataset[Bounce Rate],bins=15, color='k')