Days of week count from three different tables

[jcastr02]

I have three different tables with requests coming into our business.  I need to be able to visually show on graph the number of requests depending on the day of the week.  Each table has a column for day of the week (Mon, Tues, Wed, etc.) but I don't know how to tie/count all three together so the graph just shows as total count.  

[jdbuchanan71 · Accepted solution]

Hello @jcastr02 

You can create a table in your model with the following code

Days = 
DATATABLE (
    "Day of week", STRING,
    "Order", INTEGER,
    {
        { "Sun", 1 },
        { "Mon", 2 },
        { "Tue", 3 },
	{ "Wed", 4 },
	{ "Thu", 5 },
	{ "Fri", 6 },
	{ "Sat", 7 }
    }
)

Then join each of your data tables to this Days table.  Then you pull the [Day of week] from this days table into your visual and that will let you count, by day, the number of lines in each of your 3 data tables.

I have attached my sample file for you to look at.