How Can I count table iD rows in Lumira

[Former Member]

Hi Guys

Can someone please help me

Id	Header 2	Header 3	Header 4
1
2
3
4
5
6

I want to count the number of rows in the table

I created a measure call Record wit the formula Count(ID), unfortunately it did not work

Can anyone please help

Thanks

Ade

[TammyPowlas · Accepted solution]

I usually "cheat" and add a column called "Count" and sum the rows - that is a work-around

[Former Member · Accepted solution]

That works

Thank you very much

[TammyPowlas]

One more idea - could you change the aggregation in the Visualize room and use Count?  See screen shot below -

[Former Member]

Hi Tammy

How do I convert Months in number (1, 2, 3, 4, 5, ...... 12) to Month Name like Jan, feb, Mar, Apr, ....... Dec) in SAP Lumira

Thanks

Ade

[TammyPowlas]

Hi Ade - in the future please create a new thread for a new question

You can use the Replace feature to change 01 to Jan, etc.

You can search for how to do this in the upper right corner Search box on this site.

Good luck