Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community.
I have attached a sample dashboard where I am trying to create a calculated dimension that summarizes the available data based on what the user clicks in the City list box.
The result I am looking for is in the text box below, how can I do this as a dynamic dimension field?
Thanks in advance.
=GetFieldSelections(City, ', ') & ' has ' &Count(Name)& ' first name people which include ' &count({<occupation={analyst}, Type={First}>}occupation)&' analysts and '&count({<occupation={doctor}>}occupation)& ' doctors'
=GetFieldSelections(City, ', ') & ' has ' &Count(Name)& ' first name people which include ' &count({<occupation={analyst}, Type={First}>}occupation)&' analysts and '&count({<occupation={doctor}>}occupation)& ' doctors'
Thanks Lisa_P for the quick TAT.