Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm wondering whats the load script equivalent of the below Chart Expression?
if(count(Total <PBI> Incident_ID)<=1,1,
if(count(Total <PBI> Incident_ID)> 1 and count(Total <PBI> Incident_ID) <=5,'2-5',
if(count(Total <PBI> Incident_ID)>=6 and count(Total <PBI> Incident_ID) <=10,'6-10',
if(count(Total <PBI> Incident_ID)>10,'10+'))))
As I cant seem to add the above Expression as dimension.
You need an aggr() to create a calculated dimension which includes an aggregation-function, for example with something like this:
aggr(pick(match(count(Total <PBI> Incident_ID), 0, 1, 2, …, 11, …), '1', '1', '2-5', …, '10+', …), PBI)
The suggested pick(match()) is just a replacement for multiple if's to get a better readability of the expression and often also an improved performance.
- Marcus