Forum Discussion
Solved
Chart for Hourly Data
Hello i have hourly data where each hour (1-24) of a day is stored in a separate column of the table. How do I display this in a visual or table (example shown below) to show a total hourly...
Hi kargus ,
According to your description, I create a sample. Here are two tables.
Here's my solution.
1.Select all hours at the same time(Ctrl +select), then click Unpivot Columns tab under the Transform ribbon.
Get the table below.
2.Create relationship between the two tables by the column Service Rate ID.
3.In the matrix visual, put Read Date and Hour Name in rows, Rate Class in columna and Value in values, get the expected result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
