Forum Discussion
Anonymous
6 years agoNot applicable
Histogram by PQ Systems
I am trying to create a histogram by importing SPC hisotgram. I am unable to find any clear documentation. I am trying to
plot datavalue in value field and date in order field but it is just giving me a single line. I have used the other hisotgram and it looks perfectly shaped but i am unbale to figure out how to make SPC histogram look correct. can someone please help
This is something how my data looks as below. I am taking count of Datavalue as frequency and Datavalue in Values field of green histogram below. I am using the same Datavalue in Values field but unable to genrate a proper histogram
| SN | DateTime | DataValue |
| 50001 | 1/14/2020 | 0.1776 |
| 50001 | 1/14/2020 | 0.1533 |
| 50001 | 1/14/2020 | 0.179 |
| 50001 | 1/14/2020 | 0.1775 |
| 50001 | 1/14/2020 | 0.124 |
| 50001 | 1/14/2020 | 0.1023 |
| 50001 | 1/14/2020 | 0.0964 |
| 50001 | 1/14/2020 | 0.0998 |
| 50001 | 1/14/2020 | 0.0977 |
| 50001 | 1/14/2020 | 0.1022 |
| 50001 | 1/14/2020 | 0.1028 |
| 50001 | 1/14/2020 | 0.1874 |
| 50001 | 1/14/2020 | 0.1056 |
| 50001 | 1/14/2020 | 0.1849 |
| 50001 | 1/14/2020 | 0.1583 |
| 50001 | 1/14/2020 | 0.1694 |
| 50001 | 1/14/2020 | 0.1484 |
| 50001 | 1/14/2020 | 0.1791 |
| 50001 | 1/14/2020 | 0.1762 |
| 50001 | 1/14/2020 | 0.1726 |
| 50002 | 1/2/2020 | 0.1728 |
| 50002 | 1/2/2020 | 0.1509 |
| 50002 | 1/2/2020 | 0.1306 |
| 50002 | 1/2/2020 | 0.1298 |
| 50002 | 1/2/2020 | 0.1086 |
| 50002 | 1/2/2020 | 0.1215 |
| 50002 | 1/2/2020 | 0.1171 |
| 50002 | 1/2/2020 | 0.1007 |
| 50002 | 1/2/2020 | 0.1006 |
| 50002 | 1/2/2020 | 0.1161 |
| 50002 | 1/2/2020 | 0.1237 |
| 50002 | 1/2/2020 | 0.167 |
| 50002 | 1/2/2020 | 0.1101 |
| 50002 | 1/2/2020 | 0.1925 |
| 50002 | 1/2/2020 | 0.1915 |
| 50002 | 1/2/2020 | 0.1448 |
| 50002 | 1/2/2020 | 0.1243 |
| 50002 | 1/2/2020 | 0.1785 |
| 50002 | 1/2/2020 | 0.1508 |
| 50002 | 1/2/2020 | 0.1815 |
| 50003 | 1/2/2020 | 0.2 |
| 50003 | 1/2/2020 | 0.1602 |
| 50003 | 1/2/2020 | 0.1692 |
| 50003 | 1/2/2020 | 0.1369 |
| 50003 | 1/2/2020 | 0.1047 |
| 50003 | 1/2/2020 | 0.0999 |
| 50003 | 1/2/2020 | 0.1094 |
| 50003 | 1/2/2020 | 0.1178 |
| 50003 | 1/2/2020 | 0.102 |
| 50003 | 1/2/2020 | 0.1138 |
| 50003 | 1/2/2020 | 0.1042 |
| 50003 | 1/2/2020 | 0.1984 |
| 50003 | 1/2/2020 | 0.0964 |
| 50003 | 1/2/2020 | 0.1989 |
| 50003 | 1/2/2020 | 0.1875 |
| 50003 | 1/2/2020 | 0.1617 |
| 50003 | 1/2/2020 | 0.1596 |
| 50003 | 1/2/2020 | 0.1903 |
| 50003 | 1/2/2020 | 0.1812 |
| 50003 | 1/2/2020 | 0.1733 |
PQ Histogram