Forum Discussion
Non-numeric data
Hello. I have trouble understanding how to proceed in cases like this. This is a table with call data from a call center. The main data to display is the number of contacts achieved (Contact column, ...
Hi,
Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Likewise, create a Time Table with 24 rows representing each hour of the day. In another column, create Time bands. Create a relationship (Many to One and Single) from he two columns of your Data Table to the 2 tables created (Calendar and Time). To your visuals/slicer/filters, drag Date/time from the 2 created tables.