Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We receive a file with just year (ex 2017) in the Date column, but requirement is we need to show bar chart for all the months (From jan to dec in 2017)
Please find attached.
Thanks
So is each file stamped with the Month it belongs to? If that is true you can extract the month from the file name.
Sounds like you need the same value repeated for each month.
Best way would be to create an inline table with months and do a join on them between the inline and your table.
If you only care about this 1 chart you could also add a calculated dimension with a valuelist. And make it the 1st dimension.
=ValueList('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')
Hi,
No we just get the year filed , no month information is available.
But we need to show the count across all the months of that year and count should be same for all the months
Thanks