Variable percentiles for different product groups

Question

Good day,&nbsp;I would like to have a summarized view different product groupings within my dataset. My data is in the following form:I have n many variables, each row indicating a particular group the customer belongs to. I would like to have a percentiles view for each group type. The final dataset would take the following form for Group 1:&nbsp;This view would show the front end user how the particular group behaves across the different variable types.&nbsp;&nbsp;I have done quite a bit of searching through the forums, looking for a way to create this interface - without any success. Could you please advise.&nbsp;&nbsp;&nbsp;

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
I'd suggest you add the custom column and do some transformation in the query editor,&nbsp;you might consider creating a pbix file that will contain some sample data, upload the pbix to one drive or dropbox and share the link to the file. I'll draw it up for you.
&nbsp;

anonymous · Answer

Hi,&nbsp;I have created a test file. Unfortunately, I cannot share the original data - as the data is proprietary.https://www.dropbox.com/sh/1ynxde6ru1ogx0v/AAChiYE1ur_CE_jRrvAInp54a?dl=0Thank you so much for your assistance.

Forum Discussion

Variable percentiles for different product groups

2 Replies

Related content

Different schema into different destination

Variable percentiles for different groups

Variable Library

Percentile

Percentile of a table stored in a variable