topic Re: Creating graphs and other visuals in Developer

Creating graphs and other visuals

Kins_ — Wed, 06 Mar 2024 07:51:47 GMT

I have a form in CRM that has over 200 columns. These colums' values vary from 0, 0.5, 0.75 and 1. I want to be able to generate visuals such as bar graphs using this columns and be able to count the specific values of the columns. For example, the of 0's and 1's in a certain column.

Re: Creating graphs and other visuals

Anonymous — Thu, 07 Mar 2024 02:29:41 GMT

Hi @Kins_ ,

Here are the steps you can follow：

1. Unpiovt column in Power Query for columns that need to be calculated.

Ctrl +A to select all.

Ctrl + Left mouse click + Cancel columns that do not need to be calculated.

Transform – Unpivot Columns.

2. using matrix visual - place [Value] columns in Rows and Value respectively and set Count in Value.

3. In visual filter - Basic filtering - set 0 and 1.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Creating graphs and other visuals

Kins_ — Thu, 07 Mar 2024 09:33:18 GMT

Hi @Anonymous
Thank you this it really helps. Please assist on this, NB: the form includes a column labeled “Police Station”. To narrow down the data, I intend to create a list that specifically highlights those police stations where the count of zeros in a certain column is approximately five. How can I achrive that? Add the bar graphs should look like this,

Thanks,