Forum Discussion
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 by rate class (rate class is in another dimension)? So I want to see January 4, 2020, hours 1 thru 24 and their totals by hour per rate class. Is this possible with this table structure?
| Rate Class 1 | Rate Class 2 | |||
| Jan 4, 2020 | Hour 1 | 300 | 150 | |
| Jan 4, 2020 | Hour 2 | 500 | 600 |
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.
2 Replies
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.
