Report on number fields

[nm13]

1 to 30 are integer type fields and it contains numbers against certain product names (hidden due to client information). Lets say for example we have 500 products and each day we track the number of units sold with 1 being 1st day of the month upto 31st being 31st day of the month. Kindly note 1 to 31 are INTEGER type fields and contains whole numbers only.

I want to display a line graph of this: 

X axis - Total Count of items sold on a given day say 1st day  

Y axis - 1 to 31 fields

Pls help on how to achieve this. Tried reporting but looks like a limitation. 

Or I can achieve this via scripting but how to pull that into report if I can return an array of integers for total count of  each day 1 - 31. 

Thanks in advance. 🙂 

Cheers.

[Bert_c1]

Hi,

A table design where 'day-of-month' is a single field, that can have values from 1 to 31 would make this easy using a Pivot table report. My guess is 'product' is cut off in your screenshot and would be the row value.  Perhaps provide more detail on your "Units sold" table design, and you may be more ideas.

[nm13]

Thanks @Bert_c1 , here are some more details: This is the hypothetical table,

The TOTAL row is just for showing the sum of sales on that day and not an actual row in the servicenow table.

The sum of total sales should look like below image once plotted. 

Pardon the rough plot by hand. 🙂 

Thanks in advance! 

[Bert_c1]

Hi mn13,

Is your screenshot of data from a list view of a "units sold" table? The first screenshot does look like a list view of records, but the second screenshot does not. As you show a Total row, and something else generates that page. Knowing that would be useful.

You may want to look into a Performance Analytics widget/report, that is based on a table where the 'number of units sold' is stored. PA supports a Calendar feature.

And from your first post, you can achieve your goal via scripting, I would say your script could create records in a table for reporting purposes.