Assist with Expression

[QFanatic]

hi

Please find attached.

so the Data looks as given.

I need to create a chart (below) that looks like the desired output. Hope you can assist!

Thanks

[petter · Accepted solution]

I presume that the first table you show is a table that is exactly like that in the Data Model as a data table and not a UI table having aggregates...

If so then simply create a UI regular table in a sheet:

1) Create a dimension with the field [Table]

2) Create a measure with the following expression:  Count( [Table] )

And you will get what you asked for....

[sayalip]

Hi,

create a straight or pivot table with dimension table and expression =aggr(count (cardno),table)