Problem from Same Dates and values counts are showing 1

[#1]

Hi All,

I am facing problem with same dates having same values so I want to show my data in Table box or straight Table, in that data showing only one date with all values count. I will give you some data.

I have a data like this:

Date            Values

1/2/2016.      Fix

1/2/2016        Fix

1/2/2016.      Fix

1/2/2016.        Fix

When I am using starlight table its shows:

Date.          Values

1/2/2016.      Fix

If I use count or sum express:

Date            Value.      Count(fix). Sum(fix)

1/2/2016.    Fix.            1.                4

What I am expect results to want to show all dates and values in individual rows

Date            Values    Sum.    Count

1/2/2016.      Fix          1.          1

1/2/2016        Fix          1.          1

1/2/2016.      Fix.          1.          1

1/2/2016.        Fix          1.          1

Right now I am using Date field as a dimension Please guide me how to achieve this.

Regards,

Sunny

Note: Formatting edited by Community Moderator

[swuehl · Accepted solution]

Load your data in using a primary key, e.g. using RowNo():

LOAD *, RowNo() as Key

INLINE [

Date,           Values

1/2/2016,      Fix

1/2/2016,        Fix

1/2/2016,      Fix

1/2/2016,        Fix

];

Then create a straight table chart with dimensions Key and Date and your expressions.

You can hide the Key column on presentation tab, if you want.

[#3]

Thank you Swuehl its working for me.Thank you for your  answer